Hide Tables in Access 2000 .adp

  • Thread starter Thread starter edgedes
  • Start date Start date
E

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.
 
edgedes said:
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.
Click to expand...

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
 
Back
Top