Linked table manager error

[jim_jim]

I have created a system DSN using the Data sources in control panel to use the data source in my access database.The data source is Sql server



When I refresh all the tables using linked table manager I get the following error

The Microsoft Jet database engine could not find the object dbO_xxxxx
Make sure the Object exists and that you spellits name and the path name correctly

what am i dong wrong here

[pkstormy]

You have a table mispelled. Make sure the dbo isn't db0 (0 versus o)/

[pkstormy]

Try deleting the linked tables and relinking them again.

[jim_jim]

how do i know a particular table is misspelled in a sql server database

also
can you please advise how to delete the linked tables and relinking them again

Thanks

[jim_jim]

Should I be checking for the misspelled table in the access database or the SQL server

Please advise

[pkstormy]

If the tables are indeed SQL Server linked tables, then you can highlight a table and simply delete it (it's still on the SQL Server).

Then under Tools -> Get External Data, select SQL Server as the driver and the ODBC Administrator will open where you can select the ODBC DSN Name you've alrready established. Enter the username and password (or check "Use trusted connection"), and should then see the dropdown listing of your databases. Select the appropriate database (make sure to check the box "Save Password" and then the tables and follow the Next prompts until Finish. Click Finish and you are done.

You will notice when linking SQL Server tables, these tables will begin with dbo_mytablename. This is normal.