Access 2000 .mdb file Network accessing

[Guest]

Hi everybody,

I've got a very big problem:

The access .mdb file containing the data tables resides on the NOVELL
network server.

I have to update (replace) it while the users are connected to it through
another mdb interface file (they only need to read the data)

The problem is that if at least one user has an interface's form opened,
Access creates an .ldb file and it's impossible to delete/replace the data
table .mdb file

I've tried already to set the "recordset type" property of the form to
"Snapshot" or to open the recordset from VB code with the option "Read-Only"
, the data file is blocked anyway.

Could anyone help me?

Thanks a lot in advance

 

[Joan Wild]

I have to update (replace) it while the users are connected to it
through another mdb interface file (they only need to read the data)

The problem is that if at least one user has an interface's form
opened, Access creates an .ldb file and it's impossible to
delete/replace the data table .mdb file

You cannot replace the file while it is in use. I wouldn't imagine you
really want to replace the file. You should be able to modify tables (as
long as no one has a lock on that table). Usually this type of maintenance
is done when no one is using the backend.

 

[Phil J]

You cannot replace the file while it is in use. I wouldn't imagine you
really want to replace the file. You should be able to modify tables (as
long as no one has a lock on that table). Usually this type of maintenance
is done when no one is using the backend.

Hi

Can you tell me how I can get my DB.mdb file to open exclusive.?
Even though no one else has it open, Acess thinks they do, even though
there is only one admin user under security tools groups and users

I'm trying to redesign a view reports and 1 form just once, but Access
2003 will not let me, even if I put DB onto a system running Win XP
Pro. SP2

Thanks

Phil J

 

[Joan Wild]

Can you tell me how I can get my DB.mdb file to open exclusive.?

Try opening Access, then go to File, Open - select your database, and in the
lower right of the dialog choose Open Exclusive.