Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002

    Unanswered: Pointing my new .ADP file to my new SQL Server DB

    I hope this question belongs in this forum.

    I have a .ADP application (access 2000 front end, SQL Server 2000 back end)
    I basically want to create a new .ADP file and point it to a different SQL Server 2000 Database.

    I've copied the current SQL Server DB and recreated it. Same for the .ADP file, but it is currently pointing to the old Db, where do I go to have it point to the new SQL Server DB?


  2. #2
    Join Date
    Mar 2002
    i figured this out thanks.

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    You know, you don't need to create a copy of the ADP file. You can easily change the datasource as long as the schemas in both databases are the same.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts