Unable to open an Access 2.0 Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that was created in access 2.0 long before I started at the
company.

The tables were created under the administrator user id from what I can
tell. Various user accounts were created to input and or update information.

When I try to open the DB in Access2000 I get an error saying that I don't
have the permission to do so.

When I try to open it in 2.0 it is looking for an associated DB on a
specific drive and specific folder. It seems that this is somehow
'hardcoded' in the database.

I have tried creating a virtual drive letter with the requested directory
structure, and putting the requested files there, but that does not work.

Is there any other way around this to open the DB?

Thanks !

I opened the database back in access 2.0 and I was able to access the
database as it was, no errors or anything. I tried to add the permission to
open the database exclusively to the existing or orginal database as it was
created, but I don't have the permission to do this even in access 2.0.
 
You seem to have two problems:

(1) "When I try to open the DB in Access2000 I get an error saying
that I don't have the permission to do so."

(2) "When I try to open it in 2.0 it is looking for an associated DB on
a specific drive and specific folder."

Re. (2), does the database contain some Access Basic code that is
looking for that other database? If so, it's just a metter of finding
that code, & seeing /why/ it is looking for another database, & what
name & location has been hard-coded in. Hold the SHIFT key down while
you open the database in Access 2. This will stop any "automatic
startup" code from running. Then you can browse the internal;s of the
database to your heart's content.

Re. (1), you need to upgrade the Access 2.0 database to Access 2000.
This would include, upgrading all of the Access Basic code, to the new
language "Visual Basic for Applications" (VBA).

I know that Access 95 would convert an Access 2.0 db to Access 95. This
included, doing the best that it could to convert the Access Basic
code, to VBA.

But I have no clue whether Access 2000 will convert directlty from
Access 2.0, to Access 2000. Maybe someone else can help with that.

Whatever you do, DO NOT MUCK AROUND WITH THE PERMISSIONS OF YOUR
ORIGINAL ACCESS 2.0 DATABASE! If you can still open it, somewhat, in
Access 2, you are still ahead of the 8-ball. If you start mucking with
permissions, and it stops working over, you will then have gone
backwards - not forwards.

Take a /backup/ of the relevant files, and muck around with those
instead.

HTH,
TC
 
Back
Top