Access 2000 - Security Issue - S.O.S !

[kostaskir]

Hello everybody,

I work for a big Car Manufacturing Company from Germany. Μy manager assigned me a kind of "Mission Impossible" project. It is critical for me to accompish this task my the end of the week. I would be greatful if you can give me some help or some guidelines.

I have an Access 97 application which creates Offers for the vehicles (You select the car, the extras, colour etc) and creates a report with the final offer to print.
Is not so simple as you can imagine. It has thousands of lines full of code in order to make composite offers.

This database also has permissions. Is connected with the system.mda file.

I have a mission to accomplish. I have to convert this database to Access 2000. Nice ha ?

When I open the db with Access 2000 I get the following message:

The current user account doesn't have permissions to convert or enable the database.

How can I inherit the permissions from 97 to 2000 ?

Also if you know any tool to make this convertion (Without changing the code) , it would be a great help.


Thank you in advance.

 

[Guus2005]

Open the database in Acc97 and remove the security. You can do this when you know the Admin password.

If you don't have that password, open a new empty Access 2000 database and import all tables this is your backend. Again open a new empty acc2K database end import everything else. Click options and don't forget the "import/output specifications".

HTH

 

[ghudson]

Open the database in Acc97 and remove the security. You can do this when you know the Admin password.

If you don't have that password, open a new empty Access 2000 database and import all tables this is your backend. Again open a new empty acc2K database end import everything else. Click options and don't forget the "import/output specifications".

HTH

If you don't have the password...

How can you import the objects if the source database is secured using workgroup security and you do not have the password to unlock the security?

 

[Guus2005]

If you don't have the password...

How can you import the objects if the source database is secured using workgroup security and you do not have the password to unlock the security?

You can't. Sorry, for my mix up.

There are tools available to show any password you might have lost.
Search for Nucleus Kernel Access or Intelore Office Password Recovery.

HTH