2007 access to a 2003 database

[BCiel]

Hi

I have a database in 2003 that has user-level security. This database is
located on a server and 7 people have access to it. One of these people has
Access 2007. When they try and open the database they are told that they do
not have "Open/Run permission" for the form that is opened with the Startup.
Also, they are not asked to give a username or password when Access is opened.

Once I gave them permission in the 2003 version of the database to open the
form, that appears but nothing else works.

Anybody have any ideas how this database can be opened and used in 2007 but
remain a 2003 file???

Thanks

 

[Chris O'C via AccessMonster.com]

The Access 2007 user isn't joined to the secure workgroup. The fact that
he/she is opening it anyway means it's not fully secured.

1 - Read and study the security faq and then secure the db.

http://support.microsoft.com/?id=207793

2 - Split the db into a front end and back end. Back end has tables and
relationships only and is placed on the server. Front end has everything
else plus links to the back end tables. A copy of the front end is on each
user's desktop. All multiuser Access dbs should be set up this way to avoid
corruption and the problems with sharing the db file.

How does this sound? Your Access 2007 user could have an Access 2007 version
of the front end on his desktop and not interfere with the Access 2003 users
by reseting the library paths.

3 - Make a shortcut. (All one line)

"path to msaccess.exe" "path to db.mdb" /wrkgrp "path to db.mdw"

All users should be joined permanently to the default system.mdw workroup
file and use shortcuts to open secure dbs. How does this sound? They won't
be prompted for user name and password unless they're opening a secure db.

Chris

 

[BCiel]

First the security faq that you recommended is for Access 2000 and my files
are 2003.

I would rather not split the database into front end and back end if at all
possible. The reason that the database is secured was to lessen the
possibility of problems and corruption while sharing the db file.

I really just need to get the 2007 user able to open and run the reports
that are located in this database. That Access opens logged in as Admin
automatically but is not given the same permissions as the 2003 Admin.

Thanks but I still am looking for help.