ORACLE linked tables to ACCESS through ODBC connection shows #DELETED

Gouri Dutta

Registered User.
Local time
Today, 01:14
Joined
May 20, 2011
Messages
10
I have an application where ORACLE tables are linked (connected) to ACCESS 2003 application through ODBC connection. They are not ACCESS relational linked tables.

I tried to delete the old link for one table and re-link the ORACLE tables. It started showing #(#DELETED) through all the records and all the fields.

After that more bad things happened. All the linked tables started showing #DELETED. Even the linked tables in other folders have started to do the same thing. It happens when I open them in 2003 ACCESS with Windows XP.

But the same tables look all right in ACCESS 2007 with Windows 7.
I really need to see the tables fixed in an ACCESS application. Any suggestion how to resolve the problem? Many thanks in advance.

Gouri​
 

Users who are viewing this thread

Back
Top Bottom