microsoft access 97 protection

[mitras]

(sorry if my english is not the better)

i need to know if is possible make an executable (like visual basic) in ms access 97 dbases. if i distribute my dbase to another person, my interest are protect them and hide all the workable area. how i can do it with a macro, with a module or with a specific tool or program. pls help me tksss

 

[gwinn7]

Yes and No,

Access 97 has the ability to compile an MDE that you can distribute, but not an EXE. The MDE you create requires that you have Access 97 installed on each client using the MDE.

To make an MDE:

1. Launch Access 97
2. Select 'Tools'.
3. Select 'Database Utilities'
4. Click 'Make MDE...'
5. Done. You will be prompted to locate the new MDE.

Gary
gwinn7

 

[jgoodman00]

A possible way of copy protecting it, is to use a CheckFileExists function, & as part of your program place a hidden system file in the windows\system folder. Then on startup of your database, you run the function searching for this file. If it exists, the program continues, else it gives an error & exits. Assuming you make it into an MDE, the code is protected, so nobody will be able to work out what file it is..... James Goodman
j.goodman00@btinternet.com

 

[rohalyla]

You can also hide the database window - if they don't need it to run queries, open reports, etc. Go to tools/startup and uncheck display database window.