Access2K front end to SQL SVR 2K -- users cannot see forms??? -
08-07-2003
, 12:13 PM
Hello:
We've just switched to using Access 2K as the front end to our SQL Server 2K
db. Great. Love it.
However, one small problem. The users can see the SQL Server tables and
veiws but they cannot see the Access Forms or Reports.
Since Forms and Reports are not listed in the SQL Server 2K Objects list,
you can't grant permissions to then on the server side. I therefore assume
that somehow I must do this on the Access side.
Do you agree??
All users are set up with the same permissions and roles. I (the db owner)
can see the forms and reports I create, but the users cannot.
Any ideas??
Thanks,
Richard |