2 different view of access one for me and one for staff

[kingdoz]

Hi Guys,

I was wondering how to do this.

We have Access 2007 datanbase built and my Database has sensitive data includind clients details, staff salaries and invoices etc.

i Created 1 database to just hold the all table data.

Then a full blown databse linked to the tablesm with all the forms and queries etc. with all the info available.

Then a third database (for my staff) (imported the tables) to connect just to what they need, (and I removed all forms that shoed the sensitive data).

However, my staff can bybass the forms by viewing the linked tables directly and seeing the sensitive data.

Im tryint to work out the best way to run my database so I see everything and thier database sees just parts i want them too (without any editing either).


ANy ideas would be appreciated
Thanks
Don

 

[HiTechCoach]

Then a third database (for my staff) (imported the tables) to connect just to what they need, (and I removed all forms that shoed the sensitive data).

Imported?

Both front end should be linked to the same back end.


Try renaming the staff's front end to a .accdr

 

[kingdoz]

Hi,

Thanks for your response. I actually did mean linked rather than imported. I have thought of renaming teh file, however they can easily rename back so its not really an option - or is it???

Thanks
Don

 

[HiTechCoach]

Hi,

Thanks for your response. I actually did mean linked rather than imported. I have thought of renaming teh file, however they can easily rename back so its not really an option - or is it???

Thanks
Don

Don,

How would they easily rename back? I have never had that happen.

Note: I use VBA code to relink my SQL server tables that also does the rename if needed.

If you do not want to rename the tables from the SQL Server to match your original Access table names then you will have to go through the entire Access Front End database and modify all the table names in Queries, Forms, reports, Macros, Modules, etc.

I have some VBA code that will remove the dbo_ if that would help.