How to display the link tables on ms access

[lemodizon]

Hello everyone,

Good day,

I have a ms access database that links to the table of paradox database.

I'm trying to connect to ms access using obdc it works in connecting to the database.

unfortunately it doesn't display in query or link tables. can you teach me how to display the link table on ms access.

it only display ms access tables but from the link table it has error

thank you.

Code: Select all

on mouseUp
   
   local tDatabaseID
   
   --This will open up connection for the MS Access Database using a ODBC connection
   put revOpenDatabase("ODBC", "Wbox", "TempDB", , ) into tDatabaseID
      
   if tDatabaseID is null then
      answer "Not connected"
   else
      answer "connected"    
      
      --This query will select all the data from the table Test 
      put "SELECT * FROM orders" into tQuery      
      
      --This will query the Database Table
      put revDataFromQuery(tab, cr, tDatabaseID, tQuery) into tData
      
      --This will display all the data from the Database
      put tData into field 1
      
      --This closes the Database connection
      revCloseDatabase tDatabaseID
   end if  
   
   
end mouseUp