LDB file

[Hermione]

Hi

Is it possible when I open the database I want the ldb file will have a
different name than the mdb file


Ex: my database is: client.mdb I want the ldb to be test.ldb not client.ldb

Thanks for your help

 

[Rick B]

I am pretty sure they have to be the same name. If they varied, how would
Access know which ldb was associated with which database? You can have
multiple databases opened at a time, and Access would need to know which ldb
went to which mdb.

Why would you care what the ldb is named? The ldb is just a locking file
used by Access.

Rick B

 

[Hermione]

The probleme is that I have a program which I rename the .mdb file into .her
and .tiy but they're a mdb files

for that when the user open with access:

client.her the client.ldb will be created

and when the user opne

client.tiy the client.ldb will be created

so the second client.ldb will replace the first one, and I have problem after

Any idea how can I resolve this problem


Thanks

 

[Rick B]

I have no idea what you just said.

You are changing the file extension of your MDB files? Why?

 

[Immanuel Sibero]

Hermione,

Let's agree on file naming rule first. The rule is:
FileName.FileExtension
FileName can be anything. FileExtension can be anything but is commonly used
to identify the file. For example, MDB is Access, XLS is Excel.

One of Microsoft Access rules is when you open an Access database (mdb
file), another file (a locking file) will be created. This locking file will
have the same FileName as the mdb file and LDB as the FileExtension. You can
not change this rule!!!

So if you open two Access database files Client.xxx and Client.yyy, you will
have a conflict if both files are in the same folder. You can work around
this by placing your Access data files in different folders.


HTH,
Immanuel Sibero