Only owner can access data after tables were converted into SQL Se

A

A. Pach

Hi,
I've converted all my tables into SQL server, but only I can see them. My
database has a user-level security with 20 users only 3 are part of the
Admins group, but I'm the owner. The 3 Admins are also owners in the new SQL
database where the tables reside now. I did all the tests and everything
looks good, but when one of the Admins try to access the tables the ODBC
connection fails and they do not have access thru them. We already check the
connection & their access to SQL and everything is fine. It seems to be
something with my workgroup security that maybe is overlapping SQL
permissions.

Please any help will be appreciated.

Thanks!
A.Pach
 
Top