.ldb File Problem

[Angie]

I have recently converted two database from Access 97 to
Access 2000. After the conversion was complete and
everything ran successful, I discovered a problem with the
one database. When I open the database an .ldb file opens
for that database and the other one that I converted. So
essentially I have two .ldb files open which causes
errors. Does anyone know how I could solve this problem?

Thank you!

 

[Dirk Goldgar]

I have recently converted two database from Access 97 to
Access 2000. After the conversion was complete and
everything ran successful, I discovered a problem with the
one database. When I open the database an .ldb file opens
for that database and the other one that I converted. So
essentially I have two .ldb files open which causes
errors. Does anyone know how I could solve this problem?

Thank you!

I'm not sure what's going on. Is the one database opening a linked
table in the other? That would cause both databases' .ldb files to be
created. Or are you joined to a security workgroup that has the same
name as one of the databases? That would create an .ldb file with the
name as the database.

 

[Guest]

Both of the databases have linked tables from the other.
When I open only say database A only one .ldb file shows
up. When I open only database B, I get two .ldb files one
for the opened database and another for database A. I
think the second database is joined to two security files
if that is possible. I keep getting an error on open of
the database stating that one of its components are
missing.

 

[Angie]

I figured out the problem. I ended up placing the
databases in seperate folders then compacting both of them
while they were open exclusively.

Thank you.

 

[Douglas J. Steele]

Let's assume you've got two databases A.mdb and B.mdb.

When you open A.mdb, A.ldb is going to be created as well.

If A.mdb contains links to tables that are in B.mdb, then B.ldb will be
created when A.mdb is working with the data that's in B.mdb. Simply having a
linked table doesn't mean that B.ldb is actually going to be created,
though. If you're not working with the data, the locking table won't be
there.

 

[Joan Wild]

Both of the databases have linked tables from the other.
When I open only say database A only one .ldb file shows
up. When I open only database B, I get two .ldb files one
for the opened database and another for database A. I
think the second database is joined to two security files
if that is possible. I keep getting an error on open of
the database stating that one of its components are
missing.

Does your workgroup file (mdw) have the same name as database A? If so, it
shouldn't. They both need to create a ldb file. Rename the mdw to
something else.

 

[ou]

????:???,??????

 

[ou]

????????????????????