SetOption Method HELPPPPP!!!!!

[Di]

Can anyone help me understand this Method? I have a form
that when I try to print, I get the message "Can't open
any more tables". I can Print Preview the form OK, but
when I try sending it to a printer, I get the "Can't open
any more tables" error message. I want to try to change
the dbMaxBufferSize using the SetOption Method. Can
anyone help me with that in terms of what coding to use?
I appreciate any help!!!!

Thanks!!!!!!
Di

 

[Bruce M. Thompson]

Can anyone help me understand this Method? I have a form

that when I try to print, I get the message "Can't open
any more tables". I can Print Preview the form OK, but
when I try sending it to a printer, I get the "Can't open
any more tables" error message. I want to try to change
the dbMaxBufferSize using the SetOption Method. Can
anyone help me with that in terms of what coding to use?

Take a look at the following MS KB article to see if it might apply to your
situation:

ACC: Error Message: Can't Open Any More Tables
http://support.microsoft.com/default.aspx?kbid=165272

Although this article is targeted for Access 2.0 thru 97, the "Method 2"
resolution contained therein would apply to all versions of Access up to the
present.

 

[Luiz pires]

Can anyone help me understand this Method? I have a form
that when I try to print, I get the message "Can't open
any more tables". I can Print Preview the form OK, but
when I try sending it to a printer, I get the "Can't open
any more tables" error message. I want to try to change
the dbMaxBufferSize using the SetOption Method. Can
anyone help me with that in terms of what coding to use?
I appreciate any help!!!!

Thanks!!!!!!
Di