database connection

[cbeganesh]

hello
Im new to access. We have one existing access application. recently we moved the sql server database to another server. when i open the app now its giving error " unable to connect to spserver\spserver"
IM not sure where i have to change the servername in access. any help is appreciated.

[boblarson]

It depends on how it is accessing the SQL Server. If it is just through linked tables then you would need to go to Linked Table Manager and then select the checkbox Always Prompt for New Location and then select all of the SQL Server tables in the list that go with that instance and then relink (you would have had to modify the DSN first to point to the right spot). If it is within code then the code would need to be changed and if it is within a table then that would need to be changed.

So there isn't just a single answer for this as it all depends on what you have and how it is being done.