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

*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


fish***@hotmail.com wrote:

BE/ FE Question
2007 access to a 2003 database
Linking to a password protected BE from FE
vba opendatabase readonly
record level lock access 2002
Security Problem When Linking Tables
Secure part of a db?
recordset not updatabale
Database 30 Day Password
User Level Security on Replicated