dbTalk Databases Forums  

Access2K front end to SQL SVR 2K -- users cannot see forms???

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Access2K front end to SQL SVR 2K -- users cannot see forms??? in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Richard Hollingsworth
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.