Opening 2003 security database in 2007

D

ddoblank

I have read thru on how to open a 2003 database with user level security in
2007 and it doesnt seem to work. I greated the database so I do have admin
access but it won't let me even type in a password. Any ideas on how I can
gain access to my 2003 version on 2007?
 
D

Douglas J. Steele

Try creating a shortcut to the database, and put the reference to the group
file (.mdw) in the shortcut. Note that the shortcut must include
msaccess.exe, not just the .mdb file.

"C:\Program Files\Microsoft Office\Office\MSAccess.exe"
"C:\MyApp\MyApp_FE.mdb" /wrkgrp "E:\Myapp.mdw"
 
D

ddoblank

Thank you so much Doug. That worked perfectly.

Douglas J. Steele said:
Try creating a shortcut to the database, and put the reference to the group
file (.mdw) in the shortcut. Note that the shortcut must include
msaccess.exe, not just the .mdb file.

"C:\Program Files\Microsoft Office\Office\MSAccess.exe"
"C:\MyApp\MyApp_FE.mdb" /wrkgrp "E:\Myapp.mdw"
 
A

Andre Adams

For some reason this doesnt work for me.
It tells me that the locations doesnt exist.
 
B

BruceM via AccessMonster.com

The first part:
"C:\Program Files\Microsoft Office\Office\MSAccess.exe"
is the location of your Access executable file (Access.exe). It may be in a
differenet location than the one in the example.

The second part:
"C:\MyApp\MyApp_FE.mdb"
is the location of the database file you want to open.

The switch:
/wrkgrp "E:\Myapp.mdw"
is the location of the workgroup file.

For all of these, use the actual locations of the files on your computer

Note that if you have Access 2007 you need to use the Access 2003 file format.


Andre said:
For some reason this doesnt work for me.
It tells me that the locations doesnt exist.
Try creating a shortcut to the database, and put the reference to the group
file (.mdw) in the shortcut. Note that the shortcut must include
[quoted text clipped - 6 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top