OLE DB or ODBC real time connection

[Guest]

I have been reading and reading about A Fast Path to AS/400 Client/Server
Using AS/400 OLE DB Support. In all my research I have not been able to
answer my question. Is it possible to create a link to an AS/400 from an SQL
or Microsoft Access application that is real time? For example, like
spliting a Microsoft Access front end, back end linked table environment. In
my research I have learned all 4 ways to connect to the AS/400, ODBC, OLE DB,
API's, and stored procedures, but it looks to me like everything works at run
time and creates new tables. My goal is to link an SQL or Microsoft Access
front end to an and be able to read/write in real time to the AS/400 back
end. Is this possible?

Thanks in advance to anyone that can help.

 

[Douglas J. Steele]

You may have misunderstood what you read.

If you link to the table on the AS/400, no new table is created: you're
reading from the AS/400. Same with a pass-through query. The only time a new
table would be created is if you imported the data as opposed to linked to
it.

 

[Guest]

So this kind of connection works just like a microsoft access front and back
end? It is a real time exchange of data?

 

[Douglas J. Steele]

Yup.