Access 2007 Lock Violation

G

Guest

On Vista machine, in Access 2007 with a linked SQL Server database... Append
queries work just fine, but attempts to do an Update query result in Lock
Violation. On individual PC, so no conflicts with others. Closed SQL Server
management Studio so DB is not conflicted. Checked permissions in SQL Server
and Access. Made Update query VERY simple - just one table, simple select,
simple change - and still get Lock Violation. Any ideas? Thanks.
 
J

John Spencer

Does the SQL table have a TimeStamp field? If you are using ODBC to
link to the SQL table, you need a timestamp field in each table you want
to modify.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
G

Guest

John,
Yes, ODBC is used to link to the SQL table.
I added a TimeStamp field to the table, relinked it, and it made no
difference.

Any other ideas?
Thanks,
JudeD
 
J

John Spencer

Not really. I assume you have a primary key defined on the SQL table or
you defined a primary key when you linked the table.

Beyond that I am at a loss. Haven't really done much with 2007 yet.
Heck I just got some customers off of 97 this year. The only reason
they moved was that they were no longer able to get copies of Access 97
through their vendor(s).

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
G

Guest

Yep, everything's set up correctly. This is a setup we've used for years in
this manner, but I've upgraded and am blazing the trail in the Access
2007/SQLServer 2005/Vista territory. Some tables work fine and some don't,
and there's no apparent logical reason. Of course the ones I really need
right now don't work. Probably will open an incident with Microsoft.
Thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 Append query Key violation error 1
Merge Field Values from Different Records for Report with a Comma 1
Access 2010 append query to SQL is very slow 0
Append Query key violations... Autonumber entries 4
Query is too complex after install Access 2007 SP 2 !? 25
Does Access 2007 corrupt 2000 database queries? 1
Update access table to sql table 1
Update Top N records in Access 2007? 10

Top