Home > Archive > MS Access database support > July 2005 > Access Wizards don't see table









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Access Wizards don't see table
Tanya S via AccessMonster.com

2005-07-27, 9:25 am


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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...access/200507/1
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com