table lock

  • Thread starter Thread starter jnewl
  • Start date Start date
J

jnewl

i created an application for our call center that allows them to access an
mde data base to retrieve specific info while on the phone with a customer.

everything is fine, if only person is using the mde. if more than one, get
the enclosed error message. i don't see any option in access that indicates
allow multi users.

how can i allow multi users to use the mde file? thanks for your help

i tried this but did not get results...

DoCmd.RunSQL "delete from [system table]"
'DoCmd.SetWarnings True
Me.System.RowSource = ""
DoCmd.RunSQL "delete from [system table]"
DoCmd.OpenQuery "qry find system"
Me.System.RowSource = "system table"
Me.System.Requery


error message 'the expression after update you entered as the event property
setting produced the following error: you tried to lock table [system table]
while opening it, but the table cannot be locked because it is currently in
use. wait a moment, and try again'
 
In a multi-use environment, it is imperative that you split your database
into a frontent (where your queries, forms, reports, and code reside) and a
backend (where your data resides). I cannot remeber the exact steps for
2003, but in 2007, you select the Database Tools tab of the ribbon bar, then
select the "Access Database" in the Move Data section.

Once you have the application split, you can save the frontend as an mde
file, to make it less susceptible to user modification. Then, you need to
install the frontend on each users machine. They should not try to use the
same frontend, as this is a likely source of data corruption. If you have
frequent updates to the application, you might want to consider implementing
Tony Toew's front end updater

http://www.granite.ab.ca/access/autofe.htm

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
To split a database in 2003:

Tools -> Database Utilities -> Database Splitter


Or you can do it manually:
Start a new db from scratch (your backend)
Import all the tables from your existing (frontend), making sure to include
relationships and data under the options menu of the import wizard.
Close your backend
Open your frontend
Delete all the tables
Link all tables from the Backend into the frontend.




--
Jack Leach
www.tristatemachine.com

- "A designer knows he has reached perfection not when there is nothing left
to add, but when there is nothing left to take away." - Antoine De Saint
Exupery


Dale Fye said:
In a multi-use environment, it is imperative that you split your database
into a frontent (where your queries, forms, reports, and code reside) and a
backend (where your data resides). I cannot remeber the exact steps for
2003, but in 2007, you select the Database Tools tab of the ribbon bar, then
select the "Access Database" in the Move Data section.

Once you have the application split, you can save the frontend as an mde
file, to make it less susceptible to user modification. Then, you need to
install the frontend on each users machine. They should not try to use the
same frontend, as this is a likely source of data corruption. If you have
frequent updates to the application, you might want to consider implementing
Tony Toew's front end updater

http://www.granite.ab.ca/access/autofe.htm

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



jnewl said:
i created an application for our call center that allows them to access an
mde data base to retrieve specific info while on the phone with a customer.

everything is fine, if only person is using the mde. if more than one, get
the enclosed error message. i don't see any option in access that indicates
allow multi users.

how can i allow multi users to use the mde file? thanks for your help

i tried this but did not get results...

DoCmd.RunSQL "delete from [system table]"
'DoCmd.SetWarnings True
Me.System.RowSource = ""
DoCmd.RunSQL "delete from [system table]"
DoCmd.OpenQuery "qry find system"
Me.System.RowSource = "system table"
Me.System.Requery


error message 'the expression after update you entered as the event property
setting produced the following error: you tried to lock table [system table]
while opening it, but the table cannot be locked because it is currently in
use. wait a moment, and try again'
Click to expand...
Click to expand...
 
Back
Top