Automatic Acceptance of Make Table Data Paste

[xdanxbrash]

Thank you for viewing this...I hope you can help me.

I am accessing a remote database via ODBC and therefore prefer to use make table queries so I can easily export or reference my results.

The problem I have is that when the query is done I only have a short time to accept the dialog box that says how many records are about to be pasted to my local Access instance in the new table. Unfortunately if I miss that window of time I am presented an error saying the data is no longer available. For a query that takes a long time to process it is difficult to accept the data..very unpredictable.

Is there something I can do so the data is automatically pasted and I don't have to accept it in the dialog? I would prefer that when the make table query is done that it just makes the table and does not ask me to accept the paste.

Any help is really appreciated.

Thanks

 

[ranman256]

there should be no limit of time. The dialog box should wait until the user clicks it.
but
before you run the Make query, turn off Setwarnings and it wont ask you for anything.

docmd.setwarnings false
docmd.openQuery "qmMakeTable"

 

[xdanxbrash]

Do I enter that text into my SQL? or into a module or a macro? I am sorry, just coming up to speed in access

 

[xenou]

http://www.geeksengine.com/article/disable-access-prompt.html

Although I also don't know what this short window of time thing is about - I have never seen such a confirmation that will not wait for the user to confirm. It may be something custom in your database. Hard to say without more information.