I moved a sql 2000 database to a sql 2005 server. I have a front end in access 2003. I manually created an ODBC data source system DSN using the ODBC Data Source Administrator just like it was on the other server. I can connect fine but users are saying their getting an odbc call fail. I created the connection and relinked the tables to the new server with the moved database. I completed the same task with another database and the user can connect fine. What could be the problem?
You will have to look at the additional information of the ODBC call / error message. I guess they are not priviledged to access the database or even connct to the server.Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment