Hi Everyone:
I have a table in the (regular) database that was created by custom add-in
with this line of code:
DoCmd.TransferDatabase acImport, "Microsoft Access", CodeDb.Name, acTable,
"Temp", TblName
where "Temp" is a query that is created every time add-in is run.
I can see table, I can browse data, I can use this table in the select
queries, but when I tried to do Unmatched query wizard on this table - It
does not see it. Created select * query based on that table: same wizard
sees only some columns from the query. Other wizards don't see table as well.
In msysobjects table the only difference between this table and others is
flags column - 112 vs 0.
I have never seen anything like that.
Please advice on how to deal with that problem.
Thank you,
Tanya
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200507/1