Secure the BE DB

[gls]

Hi

I have split my DB, FE & BE. The BE is located on a network drive and the FE is located on several local network drives for staff to use. Once I created a password for the BE, the main form would not open for the user on the FE. How can I secure the BE so the data can't be opened.

Thankyou

Garry

 

[KenHigg]

Did you un-link the tables and relink them?

 

[gls]

No, as I only created in password on the BE. Didn't think I needed to touch the links for the tables on the FE. Will this fix the problem??

 

[KenHigg]

It should.

 

[georgedwilkinson]

Or, you can just refresh the links, depending on the version of Access.

 

[KenHigg]

Didn't think of that

 

[gls]

Thankyou, I will try this.