December 31, 2003 at 5:00 am
Hoping someone can help this newbie (first post ever). I am using MS Access 2000 as a front end for a SQL 7 database. My database has two tables for storing information about personnel in my company. The first table stores their names and Social Security Numbers and pay grades. The other table stores their pictures and barcodes for their ID cards (as well as SSN's). The queries in Access use both of these tables (joined via the SSN). We recently had a problem with the server running SQL. We had to reinstall NT and SQL 7 from scratch, but the data was all maintained on a separate physical hard drive on the server.
When I reattached the database to the server I found one strange error. One individual's record can not be updated via the Access front end any more. I keep getting a "two users are trying to update this record at the same time error" no matter what I do. It doesn't give me the option to keep my changes (it is grayed out), but it does allow me to drop the changes made or paste them to the clip board. I can update the record if I go directly in to SQL via the Console and not the Access front end.
I tried getting rid of this person's record entirely, and recreating it. I had to do it via the SQL Console and not from Access (the MS Jet database engine would give me an error when I tried to delete the record from Access). When I recreate the record, I get the same error. Just wondering if anyone had a suggestion of what else to try. Thanks in advance for your help.
December 31, 2003 at 8:00 am
Have you tried shutting down your SQL Server and ALL instances of MS Access then deleting the appropriate *.LDB files? IF some user had a crash and the *.LDB file couldn't clear the lock, then I think you might have a problem.
Butch
Butch
December 31, 2003 at 4:01 pm
Thanks Butch. I was hoping to try something else, so that I didn't have to kick everyone out of the database. Your suggestion may be the only way to go. I will try it this weekend. Thanks for your suggestion.
January 6, 2004 at 6:25 am
You receive the following write conflict error when you try to update records in a linked SQL Server table:
Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.
You are then given the following options: Save Record, Copy to Clipboard, or Drop Changes.
Access is creating Null bit fields, which causes a type mismatch. "
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply