Error Message???

  • Thread starter andrew v via AccessMonster.com
  • Start date
A

andrew v via AccessMonster.com

i have a welcome menu to the switchboard with three options: frmCUSTOMER
INFORMATION, frmASSESSMENTS, REPORTS. the DB is on a network with multiple
users (still reading and trying to understand the security issues to
implement it). anyhow...

frmCUSTOMER INFORMATION is tied to tblCustomerInfo
frmASSESSMENTS is tied to tblCustomerInfo and tblEvents

If there are other users using the DB and I try to open frmASSESSMENTS, I
get the error message "THERE WAS AN ERROR EXECUTING THE COMMAND." my
conclusion is that someone may have frmCUSTOMER INFORMATION opened,
therefore, that is why I cannot open frmASSESSMENTS. However, this only
occurred this morning.

If i go directly to the frmCUSTOMER INFORMATION and click on the assessment
button, it gives i get the message "the database could not lock table
'tblCustomer Info' because it is already in use by another person or
process."

If no one is using the DB, i could navigate through the different forms
with the buttons okay.

Any suggestions, please???
 
Top