database splitting

A

AccessMan

I would like to split a database to take advantage of what that offers. The
database was originally created in Access 2003, but is now used exclusively
with Access 2007. It remains an mdb, i.e., it has not been updated to accdb.
It has a startup password and makes use of user-level security.

I'm inclined to simply use the facility within Access 2007 (Database
Tools/Move Data-Access Database), but I'd like to know what to expect
regarding the password and user-level security. I'd greatly prefer to not
update to accdb just yet.

Does anybody have any wisdom/experience with this situation? Thanks!
 
A

Allen Browne

Provided you do not convert the database to an ACCDB, you can continue to
use it with user-level security in Access 2007.

You don't get the menu items for security, but you can still interface it if
needed with:
RunCommand acCmdUserAndGroupPermissions
 

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

Similar Threads

How do you connect Word 2003 to Access 2007 accdb database??? 3
Error message when trying to convert database to 2007 6
HOWTO convert programmatically .MDB to .ACCDB 1
Cannot open ACCDE file - receive "database is in unrecognized form 0
Looking for C++DAO Direct/ Acedao samples to work with Access 2007 0
Access 2003 format database with security invocation 2
Access 2007 database multiple files splitting 2
Splitting a database with a password 2

Top