dbTalk Databases Forums  

.ldb file size

comp.databases.ms-access comp.databases.ms-access


Discuss .ldb file size in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lee-Anne Waters via AccessMonster.com
 
Posts: n/a

Default .ldb file size - 11-29-2004 , 10:40 PM






Just a short question..

should all access .ldb record lock files always be 1kb in size. i have noticed on my app that at times the .ldb files can sometimes be 2kb in size

thanks

Lee-Anne
Perth WA

--
Message posted via http://www.accessmonster.com

Reply With Quote
  #2  
Old   
Trevor Best
 
Posts: n/a

Default Re: .ldb file size - 11-30-2004 , 02:18 AM






Lee-Anne Waters via AccessMonster.com wrote:
Quote:
Just a short question..

should all access .ldb record lock files always be 1kb in size. i have noticed on my app that at times the .ldb files can sometimes be 2kb in size
Would depend on number of users, locks, etc. it is after all just a
another database file, you put more in it, it grows.


--
This sig left intentionally blank


Reply With Quote
  #3  
Old   
David W. Fenton
 
Posts: n/a

Default Re: .ldb file size - 11-30-2004 , 09:15 PM



Trevor Best <nospam (AT) besty (DOT) org.uk> wrote in
news:41ac2cd8$0$1068$db0fefd9 (AT) news (DOT) zen.co.uk:

Quote:
Lee-Anne Waters via AccessMonster.com wrote:
Just a short question..

should all access .ldb record lock files always be 1kb in size. i
have noticed on my app that at times the .ldb files can sometimes
be 2kb in size

Would depend on number of users, locks, etc. it is after all just
a another database file, you put more in it, it grows.
And it can be compacted if no users are connected to it.

It is, after all, just an MDB with an MDW extension (and a few
custom system tables not found in a regular MDB). You can open it
and view its contents if no one is connected to it.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc


Reply With Quote
  #4  
Old   
Bri
 
Posts: n/a

Default Re: .ldb file size - 12-01-2004 , 11:05 AM



David,

You are talking about the Workgroup file (.MDW) and they are talking
about the .LDB file. Once nobody is connected to the .MDB the .LDB
should disappear. I know that you know this, I'm just making sure nobody
else is confused by your answer.

Bri

David W. Fenton wrote:
Quote:
Trevor Best <nospam (AT) besty (DOT) org.uk> wrote in
news:41ac2cd8$0$1068$db0fefd9 (AT) news (DOT) zen.co.uk:


Lee-Anne Waters via AccessMonster.com wrote:

Just a short question..

should all access .ldb record lock files always be 1kb in size. i
have noticed on my app that at times the .ldb files can sometimes
be 2kb in size

Would depend on number of users, locks, etc. it is after all just
a another database file, you put more in it, it grows.


And it can be compacted if no users are connected to it.

It is, after all, just an MDB with an MDW extension (and a few
custom system tables not found in a regular MDB). You can open it
and view its contents if no one is connected to it.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.