Problems entering access application

[Carlos Santos]

Hello,

i've an application developed in access with vba. it's important to say that
it's a shared database. My problem it's when user's want to enter in
application. Sometimes they enter, other time they can't enter. The message
that appear in the screen is: "Could not lock file"

Please help me,

Thanks,
Carlos Santos

 

[TC]

To the best of my knowledge, Access itself does not have any message
that says "Could not lock file". So maybe it's a message that is issued
by some custome code within the database? Open any module, click Edit :
Find, type "not lock file" (without the quotes), click the box that
says to search the whole project, then click OK, to see if you can find
the code that issues that message.

HTH,
TC

 

[TC]

Ooo, I do see some entries for that. Go to groups.google.com and enter
the following search:

"could not lock file" groups:*access*

Maybe there's an answer in there.

HTH,
TC

 

[Joan Wild]

You should split the database into frontend (contains all objects except
tables/relationships) and backend (just the tables/relationships).

The backend mdb is put on a server in a folder *where users have
read,write,create,delete permissions* - that is important in order for the
associated ldb file to get created/deleted.

You put a copy of the frontend on each user's PC. I contains linked tables
(linked to the backend on the server).