MS Access Error - 3155

[Guest]

I have a custom MS Access app which works on some XP Pro PC's and not others.
All PC's are running this .mdb are MS Access 2003 on XP Pro. When
performing a particular task in our app, 2 of our 5 PC's error, saying that
it cannot insert a record into a particular ODBC table (we are connecting to
mySQL ver 4.0.24_Debian-10sarge1-log).

I have carefully relinked the tables and the ODBC link tests out fine (by
running the link test in Windows/admin components/) . I also know this
because the app is able to pull down info from the DB no problem, so the
basic ODBC connection is absolutely there.

The specific error is "3155" ODBC -- insert on a linked table
'tbl_Remote_temp_Bid_Items_For_Update' failed.

This is very stange as this very same app runs fine on 3 of the 5 PC's in
our network.

One of these 2 PC's is only a few months old (well updated) and has been
using this app successfully until last Thurs when this problem started. The
other PC is very old. All PC's are running MDAC 2.8 SP1 on SP2.

A big mystery!

 

[G. Vaught]

Make sure the two PCs that error out have the same reference settings as the
ones that work. Whenever you copy a database from one PC to another, there
is no guarantee the references are set the same.

 

[Guest]

Make sure the two PCs that error out have the same reference settings as the
ones that work. Whenever you copy a database from one PC to another, there
is no guarantee the references are set the same.



Can you please tell me what you mean by references.

Bill