Splitted database

  • Thread starter Thread starter JasonS
  • Start date Start date
J

JasonS

Hello everybody!
I've created a database, and then protected it with a password. Then I
splitted it into 2 databases. One of them contains tables, and second
contains all the forms, modules etc...
But now, only Forms-database is password protected, while Tables-database is
completely unprotected....

When I protected Tables-database with the same password as Forms-database.
When Forms-database loads and tries to connect to data from Tables-database,
I get an info, that "The password is incorrect"....

How can I fix it?

I can not use MDW file to protect these databases as my company doies not
allow this :((((

Thanx 4 any hint
 
after password-protecting the backend (tables) database, you need to open
the frontend (forms) database and relink the tables.

hth
 
JasonS said:
Hello everybody!
I've created a database, and then protected it with a password. Then I
splitted it into 2 databases. One of them contains tables, and second
contains all the forms, modules etc...
But now, only Forms-database is password protected, while
Tables-database is completely unprotected....

When I protected Tables-database with the same password as
Forms-database. When Forms-database loads and tries to connect to
data from Tables-database, I get an info, that "The password is
incorrect"....

How can I fix it?

I can not use MDW file to protect these databases as my company doies
not allow this :((((

Thanx 4 any hint
Click to expand...

You sound like you are progressing to some serious Access work. I
suggest that if security is important that you consider learning and using
user level security.

http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

If you do decide to give it a try, start by experimenting on a COPY of
your original database. It is easy to error and lock yourself out.
 
Back
Top