By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,544 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Access Wizards don't see table

P: n/a

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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.