I have to refresh link tables in a MDB file. However MS Access in not installed in the server where the MDB file resides.
I have copied the same MDB file into the local machine and try to refresh the link tables.
Now it is asking for DSN name.
Now I created a new DSN, in the same name what is there in the link table descriptions.
But when I again try to refresh link tables it says:
Microsoft jet database engine could not find the object dbo_tablename. Make
sure that object exists and that you spell its name and path name correctly