By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,435 Members | 2,033 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,435 IT Pros & Developers. It's quick & easy.

Run-time error 3155 ODBC insert on linked table '???' failed

P: n/a
I have been using a SQL database with a VB5 frontend for about 5 years.
Works well. Unfortunately I don't have access to the source code.

I was tasked with implementing a "job entry" application that will allow a
restricted list of users to enter jobs in the database. We do not want
these users to be able to access all the data.

I created an application in Access 2002 that performs this function
seemingly quite well. However we now seem to intermittently get a hard
crash and the error Run-time error 3155 ODBC insert on linked table failed
when attempting to insert data into a specific table through the VB 5
frontend. This only happens with certain records. It seems to initiate
randomly but once it is there it sticks to that record.

Interesting enough I am doing nothing to that table in Access.I'm not even
linked to it. I am updating a table that this table references when it
loads the initial information.

For examople in the Access application
I create a job in the tblJobs
I create a record for each sample in tblSamples depending on the quantity
specified in tblJobs. Thats all.

In the VB5 app you enter a form that contains a list of steps for each
sample. I'l callthis tblSteps.
Example sample #1 was washed 1/1/2005,
dried 1/2/2005
You get the picture.

If you enter the form and there are no steps assigned to the sample. This
occurs only after initial creation. A default list of steps is loaded for
that sample. Sometimes there is no problem. Other times during this action
the dreaded Run-time error 3155 ODBC insert on linked table '???' failed.

The VB5 app may be looking at tblSamples during this time but I'm not sure.
I think VB5 still uses a Jet engine. Otherwise, I don't understand the
linked table error. Any help would be greatly appreciated.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.