Record Lock

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

is there a way i can prevent my tables from automatically
locking when i open and access project so i can have
anothe program read the tables in it??

thanks in advance
 
Nathan, >you< know what you are talking about - but I doubt that anyone else
does!

- What do you mean when you say that the tables are "locking"?
- By "access project", do you mean an ADP, or something else?
- Why can't the other program read the tables? What happens when it tries to
do so?

TC
 
when you open an access file it creates a file
called "filename.ldb and thet pervents the tables from
being used i was wondering is there is a way i can
prevent the ldb file from being created

and when i run the other program the file opens but it
won't read the tables even if i don't have them open it
give me and err saying that the table is already in use i
have to close my access preject and then it will work
 
Access always creates an ldb file when you open the database in
non-exclusive, read/write mode. Access uses the ldb file to help it manage
conflicts when several users try to edit the same data simultaneously.

The ldb file does not, in and of itself, prevent external programs from
reading the tables. Your conclusions regarding this file, are not correct.

You can prevent the creation of an ldb file, by opening the database in
exclusive read-only mode.

HTH,
TC
 
Back
Top