Deploying a Database without users seeing the Back end

[McObraz]

Hello all.

I have created an access 07 database and split it to a back-end and a front-end with linked tables.

I wish to deploy it an a network of 4 computers, 3 of which are running on XP. The back-end will be on a computer running on XP. Now, from the instructions I have come across online, the Back-end has to be located on a folder where all users have Red and Write rights!!! And I am thinking, if the users on this network can actually see the back-end since it is on a shared folder where they have all the rights, then does that not compromise the security?

Is there a way of linking to the back-end on a network WITHOUT the users being able to access the back-end?

I am new to access so, any help will be highly appreciated.

Thanks.
Maurice

 

[jkl0]

This thread shows one way by using a password.

http://www.access-programmers.co.uk/forums/showthread.php?t=250024

 

[DavidAtWork]

This is fairly straightforward to do. You can write a function that can be called from an autoexec macro (which will fire naturally when the database opens). The function will reconnect the back-end tables and then hide the database window.
However if your users are quite Access knowledgeable then they may be aware that using the shift key will bypass the autoexec, if this is the case then it is still doable but it becomes a lot more complex.

David

 

[Lightwave]

Again not a fool proof solution.

You can hide the file and folder and then set the view options within explorer to not view hidden files and folders.

Any front end linked to the back end will still work.

 

[McObraz]

Jkl0,

Thank you very much for your reply, it was REALLY helpful.