Table viewable from one db, but not another?

[liquidzoo]

I have 2 separate databases built in Access, both of which have an ODBC link to a table on a SQL server.

In the first db, everything is fine. All of the information that my users need pops up, and when I open it (at their desks) holding shift, all of the tables are accessible.

In my second db, I have connections to 4 tables that are also connected in the first, everything works fine at my desk, the desks around me, and the desk of the person helping me build this db; but when we go to the users desks, they get an error and are unable to view the tables at all.

What would cause this? I'm stumped as to why the same table won't pull up in both db's. Both are in Access 2002-2003 format, but we have also tried in 07 format. Again, either way works fine for me, but not for the people that need to access it.

 

[Guus2005]

Seems to me that there is a security issue here. You have permission to view the SQL database but the other users don't.

Perhaps you are a developer and it often occures that developers have less restrictions on the database.

Enjoy!