How to display the link tables on ms access
Posted: Thu Nov 23, 2023 1:45 pm
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.
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