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

MS Access

P: 1
I have an access application that links to an oracle database through ODBC. I need to construct a view from several tables. So I have created several queries that download data nad create tables and then I join these tables to create the view. Now how can I prevent access from asking me to confirm whether I want to create the new tables ?
Oct 11 '06 #1
Share this Question
Share on Google+
1 Reply

P: 5
If you put your queries in a macro you can "Set Warnings" to No when you start, then at the end of all the queries, "Set Warnings" to Yes.
Oct 11 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.