I cannot open an Access 2003 database in Access 2007

[John Mitchell]

I have an Access 2003 database that was originally created in Access 97 using
a custom Workgroup with permissions.

When I try to open this database in Access 2007 I get a message saying: "You
do not have the necessary permissions to use this file. Have your
admistrator create the permissions for you.

I have a stand alone PC and I am the administrator as far as I know. And
since I loaded up the Access 2007 I can no longer start up Access 2003.

Can anyone help me?

 

[Joan Wild]

You still need to use the secure mdw file when opening it in 2007. Try
creating a desktop shortcut with the following in the target:
"path to 2007 msaccess.exe" "path to your mdb" /wrkgrp "path to secure mdw"

"can no longer start up Access 2003" - do you get an error? does nothing
happen?

When you installed 2007 did you choose to not uninstall older versions
(easily overlooked)?

 

[Allan V. Pimble]

I don't know if this will work in this circumstance, but try compacting and
repairing the database. This can be done from the Immediate window using
Application.CompactRepair. The syntax is given below:


Application.CompactRepair(SourceFile As String, DestinationFile As String,
[LogFile As Boolean = False]) As Boolean