dcsimg
Results 1 to 3 of 3

Thread: Public Database Permissions

  1. #1
    Join Date
    May 2007
    Posts
    2

    Public Database Permissions

    I have a db that I use as the backend to an Access application. The application looks at 2 databases that are on the clinet machine. A db from a vendor and my new database. I can read the vendor db (with the proper dns), but I can only read my db when the user has admin privileges. I have granted the public all permissions for the table on my db. What am I missing?

    Also, this is a db on a Small business Server 2003 so all of the SQL tools do not appear to be there.

    TIA

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you add sql logins as db user in your db?

  3. #3
    Join Date
    May 2007
    Posts
    2

    Thanks

    Thank you for the insight. I added the SQL logins and added a role and that worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •