Two databases, One Form

[95DSM]

Is there a way to have two seperate Databases, one which has the forms and the other that has the tables and queries.

I would like to restrict users from editing the actual tables and queries. They would only be able to use the forms. If there is a way, please let me know.

[pbaldy]

It is the standard setup, actually. It's called splitting the application. More info here:

http://granite.ab.ca/access/splitapp/index.htm

[95DSM]

Thanks, but now I have another problem.

I split the database into two. I added a password to the BE but now when I log into the FE that has no password I get an immediate error, "Not a Valid Password". Thats before I even click anything. Any idea as to why this keeps happening? If I go to the FE >>> Linked Table Manager and relink the table I get the same error even though it doesnt ask for a password.


Thanks

[pbaldy]

I've never used a password on an Access backend. When you link the tables, are you given an option to save the password (I normally link to SQL Server tables, and the option does exist in that situation)?

[95DSM]

I've never used a password on an Access backend. When you link the tables, are you given an option to save the password (I normally link to SQL Server tables, and the option does exist in that situation)?

Nope, when I click on Linked Table Manager it brings up the normal window. I check "Always promt for new location", click "Select All" and then click "OK". I locate the BE and the Error appears.