Open 2003 mdb with 2007

  • Thread starter Thread starter Stacey Crowhurst
  • Start date Start date
S

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!
 
Stacey said:
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?
Click to expand...

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
 
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
 
Stacey said:
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"
Click to expand...

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?
Click to expand...

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

Hans
 
We have it working. Thank you very much Hans!

Hans Up said:
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
Click to expand...
 
We had left out the /WRKGRP text of the the shortcut filepaths. Adding that
in solved both errors.
 
Back
Top