LDB file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hermione - 30 Mar 2005 20:05 GMT

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

Reply to this Message

Rick B - 30 Mar 2005 20:17 GMT

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

> Hi
>
[quoted text clipped - 4 lines]
>
> Thanks for your help

Reply to this Message

Hermione - 30 Mar 2005 20:43 GMT

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

> 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
[quoted text clipped - 15 lines]
> >
> > Thanks for your help

Reply to this Message

Rick B - 30 Mar 2005 20:58 GMT

I have no idea what you just said.

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

> The probleme is that I have a program which I rename the .mdb file into .her
> and .tiy but they're a mdb files
[quoted text clipped - 32 lines]
> > >
> > > Thanks for your help

Reply to this Message

Immanuel Sibero - 30 Mar 2005 23:34 GMT

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

> The probleme is that I have a program which I rename the .mdb file into .her
> and .tiy but they're a mdb files
[quoted text clipped - 32 lines]
> > >
> > > Thanks for your help

Reply to this Message