Access Query - Change of Server

[paulS30berks]

I wondered if someone could advise?

We have recently changed our SQL Server and I am now trying to point an access database to this new server using ODBC connections.

I have updated my ODBC settings and altered the name to the new object. It stills seems as though the database is pointing to the old tables though as receiving an error message:

"The microsoft jet database engine could not find object....."

Does anyone have any suggestions?

Thanks

 

[KenHigg]

I just do a new connection, then attach to the new table(s). The just rename the old table something like 'tblMyTableName_old'. Then rename the new attached table with the old original table name; 'tblMyTableName'.

Make sense???

 

[paulS30berks]

Many Thanks for your reply.

I have deleted tables from the database and relinked this seems to have worked.

I am now updating queries and updated to new tables within the new server, but receive an error:

The Microsoft Jet Dtabase engine could not find the object",

Thanks