Monday 15 September 2014

sql - Retrieving table names from Access, can't open microsoft jet engine workgroup information file -



sql - Retrieving table names from Access, can't open microsoft jet engine workgroup information file -

i'm attempting read table names access database file using code found stack overflow question doing that. code below:

select msysobjects.name table_name msysobjects (((left([name], 1)) <> "~") ' , ((left([name], 4)) <> "msys") , ((msysobjects.type) in (1, 4, 6))) order msysobjects.name

however when run error record(s) cannot read; no read permissions on 'msysobjects'and after research found way grant read access needed.

i added 'grant select on msysobjects admin' , error: cannot open microsoft jet engine workgroup info file. , every article i've seen error refers either issue kaspersky (which computer isn't running) or issue system.mdw file, doesn't seem problem because running other command works fine.

how can around issue can read in table names?

have done sp6 update vb6 install? necessary vb6 open ms access 2000 or later mdb's

sql ms-access

No comments:

Post a Comment