Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 2nd, 2004, 12:05 PM
Registered User
 
Join Date: May 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2000 & 2002 upgrade problem

I have a web site using an access 2000 mdb file.
I have just upgraded my development machine to xp and access 2002.

If I open the original live MDB file using Access 2002 then it appears to lock the file since the web site now cannot access the MDB until I close it in access 2000.

Does anyone know if Access 2002 opens a 2000 created MDB in some funny manner that ends up locking the db from the 2000 jet oledb?.
NB I can open the db multiple times using multiple instances of access 2002!!


 
Old May 2nd, 2004, 05:31 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

If you have already convert the database.

Under tools
--> Options
--> advanced Tab

check and make sure the default open mode=shared
and also check default record locking=no locks

 
Old May 3rd, 2004, 02:42 AM
Registered User
 
Join Date: May 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thsnka for the ideas.

I didnt want to convert the database as some colleagues still have 2000, plus I was worried that the jet oledb wouldnt work.
However I just tried converting it and everything still works, BUT the problem stil remains . I tried different record lock types too
I had already double checked the open type, but thats correct. now I am really stumped.

Next port of call is that the 2002 upgrade is coincidental and its a security access user id issue

 
Old May 3rd, 2004, 03:23 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

You can still convert it back to OLDER version and to current version


Tools >> Database Utilities >> Convert Database >> To Current Access Database Version -- and select the older version .mdb file. This creates new file of current version.

Open the Current Version .mdb file and
Tools >> Database Utilities >> Convert Database >> To Prior Access Database Version -- and Give the New .mdb file. This creates a new .mdb of older version.

In both cases, you can't overwrite existing MDB files. Only new files can be created.

But it works fine with me if I convert it to either versions. So I work with one version of MDB and later convert to the other so as to update if any structural changes made to the MDB and keep both in sync.

I dont see any problems with JET engine. It works for both the versions.

-Vijay G
 
Old May 3rd, 2004, 04:55 AM
Registered User
 
Join Date: May 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Found it!.
The problem was elswhere with my upgrade.
The folder containing the mdb file had not carried over the permissions correctly, which was confusing as all programs worked on their own, but not togther.

Its to do with the LDB file, for some reason it could be deleted and created but not updated or soemthing like that.

I found it from an implication on another board

Thanks for the support





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2002 & Windows Print Services issue voyeur Access VBA 1 August 6th, 2008 06:56 AM
Upgrade 2000 DBs to 2005 or install SQL 2000/2005 cJeffreywang SQL Server ASP 0 February 13th, 2008 10:44 PM
Access Problem From Upgrade WinNt -> 2003 BrianWren Internet Information Services 0 March 22nd, 2007 11:39 AM
Access Problem From Upgrade WinNt -> 2003 BrianWren Windows Server 0 March 22nd, 2007 11:35 AM
Access97 local forms in Access 2000/2002 vance696 Access 2 October 14th, 2005 10:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.