SQL Server DB moved

I'm just starting to try SQL SERVER as a backend to my front end.

With my current Access FE and Jet BE, I give the user the opportunity to try
and relink to the backend if for some reason it got moved. A dialog box comes
up and the user selects the back end file to link to and linking proceeds.

With SQL Server I'm using ODBC to connect my Access .mdb front end using
trusted connection.

So, I wondered what would happen if I moved the SQL Server database. Well the
linking failed and the SQL Server logon screen appeared. There doesn't seem
to be a means on that screen for selecting the location of the database. It
shows the correct database initially but if you select it, the hourglass
appears and then after a little while the box is empty and the database for
the app is no longer a possible selection (because it has been moved). Any
other databases that were in that location are available for selection, but I
didn't try to see what might happen. OK, so why don't they give one the
opportunity to find the database so that linking can proceed.

Although you wouldn't expect to do this often, it could happen if for some
reason the Server administrators decide to move files around or move
databases to a new server. How does one go about resolving this problem?

I've been testing out Doug Steele's "How to Create a DSN-less Connection to
SQL Server...." The server name and database name are variables to be input,
but if I open a dialog box to find the database file and do locate it, I
wouldn't know how to get the server name.

Thanks for any help.


--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Replication Suggestions
    ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
    (microsoft.public.sqlserver.replication)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)