Prevent import from MDE

[Kevin]

Hi all,

I'm creating a database to put out on the production
floor. I will be creating an MDE to protect my code but,
as you know, that will not prevent users from importing
the tables into another database. I want to lock this
down completely so the ONLY way to get to the data is
through the forms in the MDE.

An even better solution would be to password protect this
ability so that only I can get to the data, but I'll
settle for the former if that's all I can do.

Thanks in advance!
Kevin

 

[Tony C]

Is the MDE you are going to use on the Shop Floor on a
Server? If it is then you can do the following: -

Set up a Password Protected "Development Version" of the
Database.

Copy This version, remove the Password, then delete the
Tables.

Link the Tables from the Development Version to the copied
Database.

Generate your MDE from the copied Database.

Extra note: -

If your MS Access version is 2000 or later, then set up a
seperate password protected Database, use this Database to
store your Database Tables, then link these Tables into
the Development Version and the copied Database. Failure
to do this will hinder future attempts at development.

HTH.


Tony C.

 

[Kevin]

Tony,

Thank you, but unfortunately this is on a stand alone
machine.

Thanks again,
Kevin