data show up on my machine but not on others

  • Thread starter Thread starter Tim
  • Start date Start date
T

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.
 
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.
 
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?
 
Back
Top