Friday, March 23, 2012

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?

Thanksi figured this out thanks.|||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.

No comments:

Post a Comment