A Really Secure Database

Hello All,

Over the last few weeks I have made a few postings and have been really gratefull for all responses and help, especially our Wimpie !.

I am now finishing my project which is a Test Database for out Technicians here at Sage Uk. Could any of you advise on which is the best way to have my Access 2000 Database on a N/W server where nobody can actually find it or get into it without going through my .EXE file. I have setup a Password on the Database which is included in the Connection String, and have also worked out that If I hard code the path to the Database in the Connection String they wouldn't really be able to find it.

Is it possible to have a file on a server which is not visible using the N/W Neighbourhood or if it is, then Passworded, and then in my VB Project access that Drive and Folder on the Server.

Somebody, Please Help, otherwise a Test Database is quite useless if everybody can read the answers.

Welcome to the real world, if you hardcode the string in your application, it can be read. The best bet is to change your connection to a FILE DSN which contains the database location. I would make the file invisible and put it in a directory that was not shared. This should sufficiently hide your connection information.