Security Issue

[azizrasul]

I have an MS Access 97 db on a closed LAN. If I take a copy of the db and go onto a stand alone PC with MS Access 2k, I can't open it.

I get a message which says:-

The current user account doesn't have permission to convert or enable this db.

What do I have to do to open and convert the db?

Any help would be appreciated.

 

[bat17]

If the database has been secured then you will need a copy of the system .MDW file that is used with the database.

Peter

 

[azizrasul]

I have the system.mdw file from the Access 97 m/c. If I join it, successfully, it prompts me for a password when I open the Access 2000 db. What do I do now?

 

[bat17]

once you enter the password it should let you convert it to 2000 or use it as it is. you should only need to convert if you are planning to make alterations to the DB design.

Peter

 

[azizrasul]

What password do I use?

 

[bat17]

The same password you use to open it at work?

 

[azizrasul]

On the Access 97 m/c no password is entered. Only my colleagues username appears. By pressing Enter, the db opens.

 

[bat17]

It sounds as if your colleague has not had a password set againt his username. what happens in 2000 if you just hit enter with your colleagues username?

Peter

 

[azizrasul]

Still doesn't work. It comes up with the original message "The current user account doesn't have permission to convert or enable this database".

The ownership of the db belongs to my colleague, if that helps.

 

[bat17]

I dont know what else to suggest but that you try to desecure the database while still in A97 and then convert to A2K

Check out the Security fAQ at M'soft

HTH

Peter