Post reply

ADP File - Change SQL Connection string

  • January 21, 2010 at 9:58 am

    #215938

    I have inherited an old MS Access ADP file and need to change the connection string from an old SQL 2000 box to a new SQL 2005 Instance. The ADP file was written in Access 2000 and we are now using Access 2007

    Have spent ages looking around the ADP file but am unable to find the connection string. Argh!!!

    Could some kind soul point me in the right direction before I do something silly!!!!

    Many thanks

    Colin

  • January 27, 2010 at 10:17 am

    #1109415

    In an Access 2000 ADP I have you can go to File>Connections.

  • January 28, 2010 at 1:54 am

    #1109796

    Thanks, found it. Must have had the wrong glasses on that day!

    Colin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply