Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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!!


Reply With Quote
  #2 (permalink)  
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

Reply With Quote
  #3 (permalink)  
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

Reply With Quote
  #4 (permalink)  
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
Reply With Quote
  #5 (permalink)  
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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 05:15 PM.


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