Seperating Table and Forms

[Ian]

I want to seperate my db into tow; one for the tables and
another for forms (so that I can work on the forms while
it is still active). Right now it is in 1 db with
multiple user permissions. When I've done this in the
past (without and users or passwords defined) I simply
copied the db and deleted the tables from one and linked
them to the copy.

My question is -- in which db do I set the
users/passwords or is it both. If I set it in both will
it prompt for the password twice?

Thanks

 

[Lynn Trapp]

If you use the same workgroup information file to secure both databases and
open the frontend (db with forms, etc.) with a shortcut linked to that WIF
or are joined to that WIF, then you will only be prompted one time.