Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open frm from frm->exclusive mode error 1

Status
Not open for further replies.

raymondo

Technical User
May 3, 2002
86
AU
On opening formA from formB, both of which acces the same table either directly (formA) or via a query (formB), I get a 'Table already open in exclusive mode by user or user interface error' (Err num 3008). I have checked the shortcut and there is no restriction. The appropriate option for the DB is set to shared access. Any suggestions?
 
What lock type are you using when opening the table in formA? If you are using a pessimistic lock it may have the record locked when formB opens for update.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top