hiding the back end data

[fishqqq]

I have the back end data that all the users use on a server with
"server 2008" and all the users are using a front end program on
Access 2003 (operating sys is Windows XP). can someone tell me how to
hide the location of the back end mdb files - yet still allowing the
front end to link up to them?

thanks
Steve

 

[Chris O'C via AccessMonster.com]

*Any* linked table's connection info is listed in the front end if the user
knows where to look. The only way to prevent that is to not use linked
tables, but use unbound forms and reports with the connection info in the
recordsource property and convert to mde so users don't see the code.

Better yet, link to a secure server as the back end, set up security properly,
use stored procedures, and it won't matter that the users can see where the
back end is. They can only execute the stored procedures from your front end
app to get at the data.

Chris