April 10, 2006 at 4:49 am
Hi everyone , hope someone can offer some asssitance with this one.
Have an issue when trying to add a record via an Access front end to an SQL 2000 database. When trying to add a Type A record into the database via the application front end and by the database back end get the above error.
We can however add a Type B record into the database via the front end and database back end into the same table without error.
Can anyone offer any advice on what is happening , and how I can check to see what the issue is ?
Many thanks
April 10, 2006 at 1:08 pm
That needs some deeper digging.
It is probably a locking issue. Are you familiar with enterprise manager/query analyer/sql profiler of sql server 2000.
Do you retrieve all the records you request instead of on need basis?
April 10, 2006 at 1:09 pm
That needs some deeper digging.
It is probably a locking issue. Are you familiar with enterprise manager/query analyer/sql profiler of sql server 2000.
Do you retrieve all the records you request instead of on need basis?
April 11, 2006 at 12:52 am
Well managed to sort this.
What we did was to re - run the index creation script on the said table. Following this we were able to add records via app and database table.
If this particular index was damaged \missing would this have produced the issues we were seeing ? (Assuming yes , as we can now input data again !! )
cheers
April 11, 2006 at 9:02 am
Access projects has a default timeout of 30 seconds. You can increase
this to 5 minutes (300 seconds)
goto Tools/Options/Advanced and change the OLE/DDE timeout from 30 to 300.
Rich
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply