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
 
Top