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

Getting Error 3014 - how to tell what vversion of "Jet" I am using?

100+
P: 167
I have a form that has a list of all reports in my application. The user may elect to preview ALL of them and will highlight them (about 35) in the form then click on button 'preview', the reports open up in preview for about 20 or so, then get the 3014 error and stop.
I have read this is not an access error but a 'Jet' error and there is an upgrade I can download "Jet35Upd.exe(SP3) online. The error states that it can't open any more tables as it is only allowed 1024 table references and with this upgrade it will go to 2048. Can you tell me how I can tell which version of the Jet I am currently using and does anyone know if this upgrade will actually help? I work for an agency that I will have to go through our security group just to get the upgrade and don't want to bother if it is not going to help resolve my issue.
Thanks!
May 9 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I have a form that has a list of all reports in my application. The user may elect to preview ALL of them and will highlight them (about 35) in the form then click on button 'preview', the reports open up in preview for about 20 or so, then get the 3014 error and stop.
I have read this is not an access error but a 'Jet' error and there is an upgrade I can download "Jet35Upd.exe(SP3) online. The error states that it can't open any more tables as it is only allowed 1024 table references and with this upgrade it will go to 2048. Can you tell me how I can tell which version of the Jet I am currently using and does anyone know if this upgrade will actually help? I work for an agency that I will have to go through our security group just to get the upgrade and don't want to bother if it is not going to help resolve my issue.
Thanks!
To determine what version of Jet or Access you have, go to the Access command menu and select Help>About Access>System Info>Applications. I do not know if the upgrade will help. I had a similiar problem that I fixed by placing a one second pause (using the sleep function) before looping to the next report. My theory was that the print loop ran in ram and executed faster and eventually outstripped the capacity of the memory buffer used to execute the print preview. I don't know if the theory is correct, but using the pause solved my problem. Hope this helps.
May 11 '08 #2

Post your reply

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