If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
"Write conflict" error
I have an Access 2003 .mdb file, tables are linked by ODBC
to SQL 2000. Using subforms, I have recently started getting 'write conflict' errors where previously it worked fine. I have tried all sorts of things, there are no null value in bit columns, all are either 1 or 0. I have considered that the tables may be corrup in the SQL database so have re-creasted, even in a new database, but the problem persists. All KB articles suggest a null values in bit columns - that has been eliminated float values for numerical IDs - these are all int values multiple forms trying to simultaneously amend one table - again, this is not the case What else is there to look for? |
#2
|
|||
|
|||
Hi Phil,
It sounds like you might be changing records in the same table using two different forms. This has happened to me when I change something in one form, then link to another form without saving the data first. Try saving the record before the subform is accessed. I use this code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Hope this helps, Jen. "Phil" wrote: I have an Access 2003 .mdb file, tables are linked by ODBC to SQL 2000. Using subforms, I have recently started getting 'write conflict' errors where previously it worked fine. I have tried all sorts of things, there are no null value in bit columns, all are either 1 or 0. I have considered that the tables may be corrup in the SQL database so have re-creasted, even in a new database, but the problem persists. All KB articles suggest a null values in bit columns - that has been eliminated float values for numerical IDs - these are all int values multiple forms trying to simultaneously amend one table - again, this is not the case What else is there to look for? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access Runtime Error Number: 0 | Mike | General Discussion | 2 | August 13th, 2004 08:42 PM |
Write conflict corrupts the db | PJ | Database Design | 2 | June 17th, 2004 06:14 PM |
Write conflict corrupts db | PJ | Using Forms | 1 | June 16th, 2004 06:40 PM |
Write conflict corrupts the system | PJ | Database Design | 0 | June 16th, 2004 06:05 PM |
Continual Error 1321 Trying to Install Office 2003 | Chad Harris | General Discussions | 9 | June 11th, 2004 08:19 AM |