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

Did you add sql logins as db user in your db?

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