Hide Tables in Access 2000 .adp

[edgedes]

I have a .adp attached to SQL 2000 with the DB window hidden. Users are
logging in SQL logins. I want to hide some or all of the tables but if I
deny access in SQL then most forms etc. can't be accessed. I started to
convert the .adp to a .ade but that will take a bit of time b/c of compile
errors and I'd like to solve the table issue now so employee data is not
accessible.

Any help would be fabulous! Thanks. Amy.

 

[Larry Linson]

I have a .adp attached to SQL 2000 with the DB window hidden. Users are
logging in SQL logins. I want to hide some or all of the tables but if I
deny access in SQL then most forms etc. can't be accessed. I started to
convert the .adp to a .ade but that will take a bit of time b/c of compile
errors and I'd like to solve the table issue now so employee data is not
accessible.

First tip: You need to solve your compile errors before you continue, not
just for the purpose of making an .ADE, but for the purpose of having a
clean application.

Larry Linson
Microsoft Access MVP