Senin, 02 Mei 2016

[MS_AccessPros] Re: Access Locking SQL Server

 

Bill,

Thanks for responding. There is a primary key in the table. It is the Part No. I believe everything is set to No Locks but I can't remember where to find that. Where is that setting?


Doyce



---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

Doyce

I've never seen an Access front end lock up a table in SQL. What's your record locking set to on the GUI? I use "Edited record" for all my locks. But you also need to run down where the lock is staying put. 

Check that the table has a primary key and Access is indexing it. If it has a primary key you should be able to see it in design view. If it doesn't have a primary key or is actually a view you can delete it and link to it again. Access should ask you to choose the field(s) that will constitute a unique row.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <winberry.doyce@...> wrote :

Hello Pros,

I have an Access 2013 db that is linked to my ERP system SQL server by ODBC. This database is somehow locking up SQL and I can't figure out why. It contains a form where users select a part number in the Part Master table from the SQL DB and it prints labels. When they walk away and leave the program open, I think it locks the record for the part number that used last. When this happens, the SQL server manager shows the status of that PC as being "suspended" and if another user tries to use a function that loops through the part master in our ERP system or tries to do something with that part number like ship it in Part Sales, they get a db timeout error. I have 2 other DBs connected to this same SQL server the same way and they never cause a problem. How can I figure out why this one is locking the server and fix it?


Doyce

 

__._,_.___

Posted by: winberry.doyce@roadsysinc.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Tidak ada komentar:

Poskan Komentar