Securing MDE Files

[Tony C]

Hello Everybody

I have been using mde files for Database deployment for a
few years now, unfortunately I have just discovered that
mde files do not prevent the importing/exporting of
Tables, Queries and Macros. This is of particular concern
as we are using Database Applications to interrogate
commercial and bespoke SQL Server Databases.

Is there a method of preventing the importing/exporting of
all objects within an mde file WITHOUT USING WORKGROUP
FILES? (Users are logged into the Databases using Network
Security). I am currently using MS Access 2000.

Many Thanks


Tony C

 

[Rick Brandt]

Hello Everybody

I have been using mde files for Database deployment for a
few years now, unfortunately I have just discovered that
mde files do not prevent the importing/exporting of
Tables, Queries and Macros. This is of particular concern
as we are using Database Applications to interrogate
commercial and bespoke SQL Server Databases.

Is there a method of preventing the importing/exporting of
all objects within an mde file WITHOUT USING WORKGROUP
FILES? (Users are logged into the Databases using Network
Security). I am currently using MS Access 2000.

No. You can obfuscate with dozens of methods, but you cannot prevent (even
with a workgroup file).