ADP question

Posted on 2004-11-14
Last Modified: 2013-12-05
I have an ADP file that is connected to an MSSQL server. I want to move this ADP file to a different pc where this same MSSQL exist with the same files, etc. but the Name of the MSSQL server is different. Is there away I can easly just change the name of the MSSQL server so that this ADP will work there?
Question by:Lisa0812
    LVL 8

    Expert Comment

    This is probably not a good answer ( requires excessive maintence in future) but yo could as a quick fix install sql client tools and in the SQl server client network utility add an alias, use the old server name and point it at the new server.

    To do it more professionally have a look at
    LVL 36

    Accepted Solution

    adp server can be changed easily...just goto file/connection and repoint to the new server...

    note that this doesn't have any effect on any hard coded dsn's (ie: you are using dsn-less connections and connection strings at runtime) can do a project wide search and replace for these...

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now