By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,685 Members | 1,896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,685 IT Pros & Developers. It's quick & easy.

.ldb file size

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
--
This sig left intentionally blank
Nov 13 '05 #2

P: n/a
Trevor Best <no****@besty.org.uk> wrote in
news:41**********************@news.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.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #3

P: n/a
Bri
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:
Trevor Best <no****@besty.org.uk> wrote in
news:41**********************@news.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.


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.