473,554 Members | 2,913 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2000 incorrectly deletes ldb file

stu
I have several databases that are opened using various versions of
Access and VB. Up till recently everything worked fine, then I started
getting a variety of lock file error messages, both on my PC and other
computers (both Win2k and WinXP).

After a lot of testing I found that if the database was opened by
Access 2.0 (or a VB3 16 bit application), and then subsequently a
Access 2000 (or VB6 32 bit application) opened the database, then when
the Access 2000 session ended, the LDB file was deleted, even if the
Access 2.0 session was still current. If more than 1 user was in the
database via Access 2.0 then the exit from Access 2000 corrupted the
LDB file.

The only way to clear the problem is to then get all users out of the
database and then go back in.

I don't get this problem on an older PC running Windows 98 so I suspect
that some automatic Microsoft update has caused the problem. Microsoft
told me they don't support anything to do with Access 2.0 so they
can't/won't help.

Nov 13 '05 #1
11 2249
Very interesting, Stu.

My recollection from the Access 2 days was that it did not delete the ldb on
exit, whereas Access 2000 does. I think there were some fairly major changes
to the security model after v2 as well.

I would have expected v.2 to have the file locked so it could not be deleted
though.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"stu" <st*@superdata. com.au> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com...
I have several databases that are opened using various versions of
Access and VB. Up till recently everything worked fine, then I started
getting a variety of lock file error messages, both on my PC and other
computers (both Win2k and WinXP).

After a lot of testing I found that if the database was opened by
Access 2.0 (or a VB3 16 bit application), and then subsequently a
Access 2000 (or VB6 32 bit application) opened the database, then when
the Access 2000 session ended, the LDB file was deleted, even if the
Access 2.0 session was still current. If more than 1 user was in the
database via Access 2.0 then the exit from Access 2000 corrupted the
LDB file.

The only way to clear the problem is to then get all users out of the
database and then go back in.

I don't get this problem on an older PC running Windows 98 so I suspect
that some automatic Microsoft update has caused the problem. Microsoft
told me they don't support anything to do with Access 2.0 so they
can't/won't help.

Nov 13 '05 #2
Hi, Stu.

Today is your lucky day. Hardly anyone uses Access 2.0 anymore so the
problem you are encountering is very uncommon. However, someone else had
the same problem recently and actually took the time to post his solution.
Hardly anyone does that, either. And I hardly ever stop by this forum.
Please see the following Web page for a solution to your problem:

http://groups.google.co.uk/groups?hl...15abad6&rnum=1

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"stu" <st*@superdata. com.au> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com...
I have several databases that are opened using various versions of
Access and VB. Up till recently everything worked fine, then I started
getting a variety of lock file error messages, both on my PC and other
computers (both Win2k and WinXP).

After a lot of testing I found that if the database was opened by
Access 2.0 (or a VB3 16 bit application), and then subsequently a
Access 2000 (or VB6 32 bit application) opened the database, then when
the Access 2000 session ended, the LDB file was deleted, even if the
Access 2.0 session was still current. If more than 1 user was in the
database via Access 2.0 then the exit from Access 2000 corrupted the
LDB file.

The only way to clear the problem is to then get all users out of the
database and then go back in.

I don't get this problem on an older PC running Windows 98 so I suspect
that some automatic Microsoft update has caused the problem. Microsoft
told me they don't support anything to do with Access 2.0 so they
can't/won't help.

Nov 13 '05 #3
"Allen Browne" <Al*********@Se eSig.Invalid> wrote:
My recollection from the Access 2 days was that it did not delete the ldb on
exit, whereas Access 2000 does.


A2.0 did not. A97 did. Don't recall about A95 as I hardly ever used it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #4
On Jan 21 2005, 12:44 am, "stu" <st*@superdata. com.au> wrote in
news:11******** *************@f 14g2000cwb.goog legroups.com:
After a lot of testing I found that if the database was opened by
Access 2.0 (or a VB3 16 bit application), and then subsequently a
Access 2000 (or VB6 32 bit application) opened the database, then when
the Access 2000 session ended, the LDB file was deleted, even if the
Access 2.0 session was still current.


One possible solution is to revoke the Delete permissions on the directory
of the MDB from all users of the app. This way the LDB file stays there
forever. Basically, the same approach as pointed out in '69 Camaro's
message, only you don't need a separate app to hold the LDB file open.

--
remove a 9 to reply by email
Nov 13 '05 #5
Dimitri Furman <df*****@cloud9 9.net> wrote in
news:Xn******** *************** *****@127.0.0.1 :
On Jan 21 2005, 12:44 am, "stu" <st*@superdata. com.au> wrote in
news:11******** *************@f 14g2000cwb.goog legroups.com:
After a lot of testing I found that if the database was opened by
Access 2.0 (or a VB3 16 bit application), and then subsequently a
Access 2000 (or VB6 32 bit application) opened the database, then
when the Access 2000 session ended, the LDB file was deleted,
even if the Access 2.0 session was still current.


One possible solution is to revoke the Delete permissions on the
directory of the MDB from all users of the app. This way the LDB
file stays there forever. Basically, the same approach as pointed
out in '69 Camaro's message, only you don't need a separate app to
hold the LDB file open.


But then you'll have more instances of "corruption " because you'll
never be re-initializing the LDB file.

I worked in that setup for one app of mine, and I found that the
best way was to have a couple of regular users who were
administrators so that I could give delete permission to the admins
and not to the users. This meant that every now and then, the LDB
would, in fact, get deleted.

Before I made that change, we were frequently needing to delete it
by hand because the LDB was getting corrupted entries in it that
were preventing compacting.

Of course, that was all A97.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #6
stu
I had already created a small VB6 app that holds the database open
which solves the problem of deletion or corruption of the LDB file, but
still doesn't address the question of why this problem arose when the
Access 2 and Access 2000 databases had been working successfully
together for the last 2 years.

Nov 13 '05 #7
On Jan 22 2005, 07:51 pm, "David W. Fenton" <dX********@bwa y.net.invalid>
wrote in news:Xn******** *************** ***********@24. 168.128.86:
Dimitri Furman <df*****@cloud9 9.net> wrote in
news:Xn******** *************** *****@127.0.0.1 :
One possible solution is to revoke the Delete permissions on the
directory of the MDB from all users of the app. This way the LDB
file stays there forever. Basically, the same approach as pointed
out in '69 Camaro's message, only you don't need a separate app to
hold the LDB file open.


But then you'll have more instances of "corruption " because you'll
never be re-initializing the LDB file.

I worked in that setup for one app of mine, and I found that the
best way was to have a couple of regular users who were
administrators so that I could give delete permission to the admins
and not to the users. This meant that every now and then, the LDB
would, in fact, get deleted.

Before I made that change, we were frequently needing to delete it
by hand because the LDB was getting corrupted entries in it that
were preventing compacting.

Of course, that was all A97.


Well, I guess it depends. I had several A97 apps set up this way with zero
issues related to LDB file corruption, for about four years. That was on a
Netware network though.

--
remove a 9 to reply by email
Nov 13 '05 #8
"stu" <st*@superdata. com.au> wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com:
I had already created a small VB6 app that holds the database open
which solves the problem of deletion or corruption of the LDB
file, but still doesn't address the question of why this problem
arose when the Access 2 and Access 2000 databases had been working
successfully together for the last 2 years.


Is the server OS the same?

Has a server service pack been applied?

You'd be surprised what kinds of issues can be caused by server-side
hotfixes. I learned years ago that patches to the server OS can have
really weird side effects that have an impact on Access. In the case
where I learned this, we'd applied an Exchange hotfix (the one that
closes the message store to allow the OS to shutdown clean) and
within an hour or so, the client's replicated database "corrupted"
and in recovery, lost replicability. Eventually we identified the
proximate cause as the hotfix and backed it out, and, voila, no more
corruption/loss of replicability.

Jet interacts with the file system in some very mysterious ways, and
changes to the way the file system (including networking subsystems)
work can make Jet behave differently.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #9
stu
I am guessing that it must be some sort of security problem as it
doesn't happen on a Windows 98 system. However I get the problem on
both a W2K server as well as a workstation.

I have changed the Security on the LDB file by removing Full Control
and Modify permissions and this prevents Access 2000 deleting (or
corrupting) the lock file.

This still doesn't answer the question as to why Access 2000 clobbers
the lock file on exit.

If you want to emulate the problem, open a database with Access 2.0,
then open the same database with Access 2000. Exit Access 2000 and the
LDB file is gone !.

Alternatively open several instances of a database with Access 2.0.
Then open the same database with Access 2000. Exit Access 2000 and try
and open another instance of the database with Access 2.0 - file lock
problems because the lock file is now corrupted !.

If you exit all instances of Access 2, then the LDB file disappears and
you can now re-open the database.

Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2296
by: Bon | last post by:
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to migrate the backend database from MS Access 2000 to MS SQL Server 2000. However, I want to keep the MS Access 2000 interface. Would it be possible?
4
3701
by: Chris Parker | last post by:
I've been given the task to migrate some existing MS Access mdb's from 97 to 2000 . This exercise will include converting all table forms and code modules. I'm aware in Access 2000 you there is a menu command to covert to 2000 Have anyone migrated from 97 to 2000 before and if so I would be grateful if you could post any problems /...
4
2316
by: Dalan | last post by:
After reading and experiencing the phenomenon of installing MS Office 2000 on a system that already has MS Office 97, or for that matter just Access 97 Runtime, I saw the ugliness that ensues. If one elects the standard installation, then Office 2000 deletes a large percentage of the older files. Of course, if one happens to choose Custom...
2
1588
by: Rick Brandt | last post by:
I posted this issue a while back (over a year ago?) but thought I would take another crack at it. I have one user out of about 250 where my app's custom menu bar does not work on any of the drop-down menu items. I have four drop-down menus in the menu bar along with a half dozen or so other top level buttons. The top-level items all work...
2
4541
by: Mike Williams | last post by:
I'm trying to copy an mdb file from one computer to another - both xp home. Most copy without a problem. When I try to copy either of two files I get the message Cannot Copy filename: Access is Denied. The filea are not open on the source computer. Both are Access 2000 files. Other Access 2000 files copy with no error. Why should copy like...
6
4724
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance
5
1429
by: Tom | last post by:
Am about to upgrade several machines running access 97 to new boxes with access 2003. Got a massive access front end DB with a SQL back end. Guess I will have to "upgrade" that '97 front. Anyone have any advice or things to watch out for? Any VBA hasles? Horror stories?? Hope it goes seamlessly... Got enough headaches.
34
2552
by: Mathieu Trentesaux | last post by:
Hello I downloaded Office 2007 for this reason : It seems, once again, that it is impossible to save any modification done in a VBA library, from the main project in Access. The save button remains desperatly grayed. It also seems impossible to open the library in another Access instance
1
2440
by: Bobby | last post by:
Hi I am using Access 2003 mdb as a front end to an application which uses SQL Server 2000 as the backend. The two are connected using ODBC. On one particular table (the Stock table), I have a simple form which updates stock. When the user presses the delete key, he gets the usual warning about not being able to undo this command, and the...
0
7600
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7521
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7802
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7563
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7889
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
3560
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3548
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2020
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1134
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.