Solved

Do not have permission to open mdb file after XP upgrade

Posted on 2004-04-07
4
287 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…

821 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