security tables

[Guest]

I have small system in Microsoft Access and i want to secure my tables by
stoping two functions.
1. linking table.
2. get external date.

I do not want the user see my table just run the application


note: if the user create access file and press Get external date and make
import or linking table he will see all the tables so i want to stop this
functions.

 

[Joseph Meehan]

I have small system in Microsoft Access and i want to secure my
tables by stoping two functions.
1. linking table.
2. get external date.

I do not want the user see my table just run the application


note: if the user create access file and press Get external date and
make import or linking table he will see all the tables so i want to
stop this functions.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.