Open 2003 mdb with 2007

[Stacey Crowhurst]

Hi. I copied my database for a different user to look at and test out. He
is on Access 2007 and I am on Access 2003. My database has a security file
set up and I added him as a user. However, when he tries to open up the copy
he gets the error message that he doesn't have permissions. I can't figure
out how to point Access 2007 to the ShareWorkgroup.mdw. Or I can't figure
out how to have Access 2007 ask him to covert the 2003 database. Any
suggestions?

Thanks!

 

[Hans Up]

Hi. I copied my database for a different user to look at and test out. He
is on Access 2007 and I am on Access 2003. My database has a security file
set up and I added him as a user. However, when he tries to open up the copy
he gets the error message that he doesn't have permissions. I can't figure
out how to point Access 2007 to the ShareWorkgroup.mdw. Or I can't figure
out how to have Access 2007 ask him to covert the 2003 database. Any
suggestions?

Create a shortcut which includes the /WRKGRP switch so that Access knows
where to find the security file associated with your database.

Here is an example from my system which works with Access 20007:

"c:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE"
C:\Users\hans\Documents\NewDB.mdb
/WRKGRP C:\Users\hans\Documents\Security.mdw

The first line is the path to the Access executable; it's surrounded by
double quotes because the path includes a space.

The second line is the path to the database file. (No spaces in path ->
no quoting needed.)

The third line is the switch, followed by the path to the security file.

In order to make that work, I combined those three line into one, and
pasted it in as the "Target" for the shortcut.

Hope that makes sense.

Good luck,
Hans

 

[Stacey Crowhurst]

Thank you Hans. We created the three part shortcut... but ... when we double
click on it to open it tell us

"The command line you used to start Microsoft Access contains an option that
Microsoft Access does not recognize"

When you click 'ok' it does proceeds to open the database but then we are
still getting the user permission errors.

Any other ideas?

Thanks muchly,
Stacey

 

[Hans Up]

Thank you Hans. We created the three part shortcut... but ... when we double
click on it to open it tell us

"The command line you used to start Microsoft Access contains an option that
Microsoft Access does not recognize"

I got that error at first because I spelled the WRKGRP switch as WKRGRP.
After fixing my spelling error, the shortcut worked fine.

When you click 'ok' it does proceeds to open the database but then we are
still getting the user permission errors.

Any other ideas?

Please show us your shortcut's "Target" statement. Maybe someone here
will be able to figure out why it's not working.

Hans

 

[Stacey Crowhurst]

We have it working. Thank you very much Hans!

I got that error at first because I spelled the WRKGRP switch as WKRGRP.
After fixing my spelling error, the shortcut worked fine.


Please show us your shortcut's "Target" statement. Maybe someone here
will be able to figure out why it's not working.

Hans

 

[Hans Up]

We have it working. Thank you very much Hans!

You're welcome, Stacey. That's good news.

What was the glitch you had to overcome?

Regards,
Hans

 

[Stacey Crowhurst]

We had left out the /WRKGRP text of the the shortcut filepaths. Adding that
in solved both errors.