A Really Secure Database

[Judgey]

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.

[dfwade]

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.