Stopping database being copied

[borgia]

I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?

Regards

 

[GUIDO22]

You will not be able to physically prevent the file from being copied - but to prevent it being useful to the copier - the way I would do it would be to ensure only PCs with a known registry key can access the database.

This could be a simple routine on startup that checks for the apropriate key in the registry - if it cant find it - Access closes.

NB. Of course, if users and passwords are not an option the only other thing you will have to do is to convert the database to an MDE database file so that all code/forms/reports etc. are no longer available to view in Design mode.

Hope this helps.

 

[neileg]

I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?

Are you saying that your customer doesn't want to use the built in Access security? Why not? It's a bit like buying a car and refusing to lock the doors but expecting another device to prevent theft.

You need to upgrade your Customer, version 1.09 is known to have this bug but Customer 2.0 has it fixed.

 

[skea]

On the same page...shadow has dealt with it like this