1

Topic: select from MSysObjects through ODBC... " resolution on reading...."

The task - to be connected from the outside (not from access) to a file ms access 97 and to receive a path to a file  (in this file) tables of the second file ms access 97.
It will be connected it turns out, to make sampling from MSysObjects is not present :-), ODBC reports that " resolution on reading...."
windows xp sp3, a file of working groups-defoltnyj, mdb files are created  - without restrictions, passwords and ...
The action not single, i.e. hands not .
Property "Description"  tables, I so understand, through ODBC too not to receive (or I am not right?)
I am connected with a local file

dsn wrote:

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir =
DBQ=c:\temp\db5.mdb

The raising variant  not , most ms access 97 is not present.

2

Re: select from MSysObjects through ODBC... " resolution on reading...."

DAO should be. With Windows it is delivered

set dbe=CreateObject ("DAO.DBEngine.35")
set db=dbe. OpenDatabase (path, False)
for each tdf in db.tabledefs
if tdf.connect <> "" then
debug.print tdf.name, tdf.connect
end if
next

3

Re: select from MSysObjects through ODBC... " resolution on reading...."

mds_world wrote:

DAO should be...

Yes, ... But in my collective farm delivered only odbc, is not present not dao, not ado access components to ... Well it is fine, we go some other way.
Good luck and health to you!