Locking Record File Types

[Rolly189]

Hi

I have inherited a number of 2007 Access databases that have a PDF (Adobe Acrobat Document) as the file type for the locking record.

These databases seem significantly slower, and have more frequent "Not Responding" periods on the network - especially when compared to those with a standard ldb file type locking record.

Is this the reality ?

What determines the file type for a locking record?

Can the Adobe locking record be changed to a ldb? and How?

Thanks
Rolly

 

[GinaWhipp]

Huh? Did someone change the *Open With*? Never seen a .PDF file used as a Locking file.

 

[gemma-the-husky]

I agree. I think you are missing something

a .mdb will use a temporary .ldb file
a .accdb will use a .laccdb file

 

[vbaInet]

a .mdb will use a temporary .ldb file
a .accdb will use a .laccdb file

Have you ever wondered why it isn't called lccdb instead?

 

[GinaWhipp]

@vbaInet...

I am wondering now!

 

[vbaInet]

My only guess is that Microsoft realised that their naming convention for the older format (ldb) was a bit off, so they decided to set things straight. They probably thought that the only format they'll have was an mdb so ldb meant "lock database". They should have initially called it lmdb "lock Microsoft database".
So I guess laccdb makes more sense, "lock Access 2007/2010 database".

Just my thoughts Gina.

 

[Uncle Gizmo]

>>>They should have initially called it lmdb "lock Microsoft database<<<

Years back before you were born, you could only have a three character file extension.

 

[GinaWhipp]

@vbaInet... I'll go with that!

@Uncle Gizmo... That I do remember!

 

[vbaInet]

Years back before you were born, ...

I just re-checked my birth certificate and it looks like I was around when this restriction was in place

 

[Rolly189]

Locking record is definitely a pdf - and it was someone had chage the "open with"

Thanks