A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Write conflict" error



 
 
Thread Tools Display Modes
  #1  
Old August 23rd, 2004, 01:03 PM
Phil
external usenet poster
 
Posts: n/a
Default "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  
Old August 23rd, 2004, 04:51 PM
ihatepaperwork
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.