Program protection issue

[xtab]

hi Friends,
Normally I put my database MS Access 2007 file on the server. normally \\server\itp$.But some of the IT guy .easily copy the access file.if I protect with password. there are so many password recovery programs available for free On the google..so if the file can be accessed freely.is there Any way or available any other protection methods.so that nobady can access the MS access file other than me.
Thx for any help in before.

[dglienna]

Why let them even see it? You think you can find my Access (or SQL) Tables?

[xtab]

Why let them even see it? You think you can find my Access (or SQL) Tables?

i am talking about windows 2007 server.not from domain.i don't want to show even another System administrator of my company.i simple want no anyother user other than me.can copy my Ms access 2007 file from the hidden folder of my server.

[dglienna]

Set permission on that folder?

[Dagnarus]

First: What has this Problem to do with VB??? My guess would be: nothing. But ok. Not my problem.

Second: The thing with a System Administrator or Administrator is that he MUST be able to see and do ANYTHING on a server. if you forget you password or delete something who is the one who resets it for you or recovers the lost file? you get the idea?

[xtab]

Set permission on that folder?

but administrator can easily copy my access 2007 file.he can change the permission of folder on to the server.i think you still did not understand .what i am telling ???see even i protect with password.there are so many recovery programs available in web like the following . so i don't want the other person see my access file.even system administrator other than me.in the same office.

[dglienna]

Use SQL Express, then. Put a USER table in there, and encrypt that password

[xtab]

Use SQL Express, then. Put a USER table in there, and encrypt that password

that is ok with sql express.but can we not encrypt to ms access 2007 password.let me know some way.

[WizBang]

If you wrote the program which accesses the database file, perhaps you should be using your own file structure, and encrypt it. Then it won't matter if someone can copy the file, because it will be useless to them. In other words, don't use a standard database file.