Solved

Do not have permission to open mdb file after XP upgrade

Posted on 2004-04-07
4
269 Views
Last Modified: 2008-02-26
I have a client who upgraded to windows XP, and they have a MS access database that is secured through a workgroup file.

I downloaded a program from passware, and found the database file does not have a password associated with it - but the application does say it has a VB project and suggests using a VBA recovery program.

I took all the data and kept the same paths and tried getting this database to work on a 98 /office 2000 machine and it still doesnt work.

I found some docs that suggested using MS access Workgroup admin to create a new security file and trying to open the DB using a shortcut - still no dice.

Any help is appreciated.

Thanks!
0
Comment
Question by:ccondo
4 Comments
 
LVL 32

Accepted Solution

by:
jadedata earned 250 total points
ID: 10780880
Greetings ccondo!

  You need to find the copy of the MDW file used to create/maintain that MDB file and its DATA files.
  That MDW has the key words you need.

  If this application was running from a shortcut on the client machine, that shortcut may have a listing of the path/name of the MDW after a /wrkgrp command line switch.
  You could get lucky.

regards
jack
0
 
LVL 39

Assisted Solution

by:stevbe
stevbe earned 250 total points
ID: 10782585
Another option is if your client has the exact details of the information they used to create the mdw file you could recreate it using the exact same values.

Steve
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now