Could Not Lock File

A

Aaron

Hello,

I've searched high and low for an answer to this problem.
I developed a very simple data entry form and table and
split into front end and backend. I want about 12
computers to share the same form. Hence, I distributed
the runtime on those 12 computers and am having them use
the same data entry front end all at the same time. I
have set the default open mode to sharing and no locks for
record locking and have checked the "open databases using
record level locking. I keep running into 2 problems and
they seem random...uggh.

Problem one is when I try to open the form on a runtime
computer, occasionally it just tells me that "could not
lock file". I don't believe I have any problems with the
default JET 4.0 lock settings because I'm only talking
about 12 computers accessing the backend at one time.

Problem two is that it seems at random...it says on the
runtime computers "Record Set Could Not Be Updated".

I don't have any of these problems when I open this file
on my own machine. Please advise if you can.

Thanks much,
Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top