Code for Linked Tables Contained in a Secured Folder

[Robert Dunstan]

I have a database that is split into a FE and BE. The BE resides on a server without any restrictions i.e. open access and I have coded some simple security into the FE to restrict user access to certain forms and reports.

In the next few weeks I plan to add some more functionality to this database which includes sensitive payroll data. The plan is to store the new tables into a seperate .mdb and link these to the FE. However the new .mdb will be stored in a secured folder on the server. What code do I need to allow those users who have permission to access this .mdb

Any help will greatly appreciated

 

[Robert Dunstan]

I also should have mentioned that I'm using Access 2K

 

[kaspi]

Hi Rob
I do not think that you need to add any code to the database fe. The access is governed by the system log on. As long as the user has access to the shared folder on the server your linked tables should work.
kaspi

 

[Robert Dunstan]

Kaspi,

Thanks for the reply.

I'm having a re-think on where to store the tables so I'll post again if I need anymore help.