Database Missing in ODBC Connection

[mungmanjed]

My access database has been tied into a specific ODBC connection for the past few years. The table links read "ODBC;DSN=***DAT;Description=****;Trusted_Connection=yes;APP=2007 Microsoft Office System; Database=***DAT;;table=dbo.APOBL"

We have added a new line of business and have to connect all our tables to a new ODBC connection. I imported the external data and it now reads "ODBC;DSN=***Consolidated;Description=****;Trusted_Connection=yes;APP=2007 Microsoft Office System;;table=dbo.APOBL"

It is missing the section with the Database to our consolidated ODBC and the data is still pulling up old numbers. What do I ned to do in order to make sure I am pulling the correct data?

 

[WayneRyan]

m,

When you set up the new DSN did you make sure to check the "Default Database" on the third panel?

It sounds like the user's are defaulting to the old database location in the absence of a specification.

Try reconfiguring the DSN.

Wayne