Importing and Linking access tables

[stricknyn]

Hi, all,

Is there an option I can turn on and off in an access database that prevents users from importing and linking my tables? I don't want to use a password to do this. I'm using Access 97

Thanks in advance.

Strick

[dannymking]

Short Answer... It's not that easy..

If you are trying to prevent prying eyes from your database then I suggest you upgrade to SQL Server.

Almost every option to you with Access will be by-passable by the determined hacker.

[techgnome]

"...then I suggest you upgrade to SQL Server."

And even that is no guarantee..... One of the things they drilled into us in the military os that nothing is hack-proof... the best recourse it to make it as tough as possible to the point that 1) it's not worth the time, effort or expence of trying to get in, or 2) if they do start to get in, slow them down enough that you can catch them.

-tg

[Ecniv]

Read up on workgroups
- create a copy of the default workgroup
- you need to create one, make a new group and user with all the rights.
- join access to the workgroup and open access
- open your database/create a new one.
- change permissions so admin and user (groups and accounts) cannot do anything
- import in the tables/forms change owner to the new account you created

Rejoin back to the normal one (the copy of the default one)
try to open the database you just created/opened

If done right all you get is a message saying "you do not have permission to read/open this database" or similar