Disable create of override prompts of certain tables.

[kjspear]

Hello everyone;

I have a simple question. I would like to disable the prompts such as 'Create Table or Table Already Exists override?'. What has happened is that in VBA, access will create a query based table. That works fine. However, I don't want ACCESS to prompt the user for specific tables. Is there a way this can be done without it affecting all other tables?

Thanks
KJ

 

[flyover789]

docmd.setwarnings 0

docmd.runsql "youractionquery sql here"
or
docmd.openquery "youractionquery name here"

docmd.setwarnings -1

HTH,
fly


[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]