security with system.mdw

[LCalaway]

Hello all:

I have the following database structure:
Front End Application
Back End Application
No special mdw file was created.
Everyone is Admin

I am trying to secure the databases at the lowest level -- just a single
password to enter. Everyone who uses the application has complete access to
everything.

I put the same password on each database via "Set database password" in
Security.

The front end database opens okay using the password. When attempting to
access the data in the tables in the back end through the front end,
however, I get the following message: "There was an error executing the
command."

If I remove the password from the backend, everything works fine.

Am I trying to do something that cannot be done so easily?

Thank you

LCalaway

 

[LCalaway]

I have just answered my own question.

I didn't understand that I had omitted a fact that is so central:
The passwords were added AFTER the databases were linked.

To make everything work right, I deleted the links and relinked the now
passworded tables.
I feel really dumb.

Thank you for listening.

LCalaway

 

[TC]

There are no dumb questions when it comes to Access security!

TC

 

[Guest]

Relax, we all have our own "dah" moments. Better to ask and get the right
answer twice then guess and get the wrong answer once.

Troy

 

[Chris Mills]

There is NO Access security. Details can be found at Jeff Conrad's and Tony
Toews' MVP websites.
http://home.bendbroadband.com/conradsystems/accessjunkie/mdetomdb.html
http://www.granite.ab.ca/access/createmdbfrommde.htm

HTH
Chris

 

[Rick B]

Your post will be looked at by others that run into the same issue, and your
solution will help them out. No reason at all to feel badly!!