data show up on my machine but not on others

[Tim]

I recently moved a local table to SQL server 2005. I re-linked the table
(now on the server) and refreshed it. I don't know why when I run the
program, it shows up data on a report, but it comes up a blank report when
running on another computer. I gave permissions to users to use this
specifice table.

In addition, for the security reason, the user's side always opens with the
bar, "Read Only" on the top of the switchboard.

Do you know what has caused this issue? Thank you.

 

[Arvin Meyer [MVP]]

Every user needs a DSN or a DSNless connection string. On each computer, go
to:

Control Panel >>> Administration Tools >>> ODBC

and set up a DSN so that each machine can connect.

 

[Tim]

Thanks for response. Well, I did set up the ODBC for the other computer. It
does not pop up any error message. Do you think it's about the permission? If
I give the user permission to insert/delete this table on SQL Server and it
still does not work, then what has happened here?

 

[Arvin Meyer [MVP]]

Permissions are not only in the database, but also on the folders that the
database resides in. If I were you, I'd consult with the system
administrators or whomever set up your network before willy-nilly fiddling
around.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com