473,406 Members | 2,894 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

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

167 100+
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
1 2786
puppydogbuddy
1,923 Expert 1GB
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

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

Similar topics

8
by: Tom wilson | last post by:
This is driving me nuts. I'm trying to update an Excel spreadsheet using ADO.Net and Oledb in VB.Net. The connection is open, the adapter is connected and the dataset is loaded. Here's the code...
10
by: B Moor | last post by:
Host PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM SQL Server 2000 sp3 (or latest).MS Office 2k3 I have the access 2k3 front end running on server (this may get changed) and all was well...
2
by: John Baker | last post by:
Hi: I have two systems, one a W98 and the other XP Home. I have Access 2000 installed on both, and have run into a difference in the way the two behave. I have a table on which I wish to reset...
4
by: cw | last post by:
(new to access / databases) I have just installed MS Access 2000 on an XP Sp2 based PC. Each time I try to create a new database or project I get a series of error messages. The main one is...
13
by: bjhartin | last post by:
All, I was working at a client's site when I installed Visual Basic 6 on a machine at their request. Existing applications on this machine had specified version 4.0 of the Jet OLEDB provider in...
8
by: Alpha | last post by:
Hi, I want to concatenate a string variable (containing file path and name) to a sqlcommnad text string but I'm getting error about "+" can't be used with string operand. It's very odd. What am I...
3
by: Brian Foree | last post by:
I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I...
7
by: Mathew Butler | last post by:
I'm investigating an issue I have when pulling data back from MS access I'm retrieving all rows from a column in a table of 5000 rows - accessing a column of type "memo" ( can be 65353 character...
2
by: slinky | last post by:
I'm getting a error when I open my . aspx in my browser... line 34: da.Fill(ds, "Assets") Here's the error and my entire code for this .aspx.vb is below that ... I need some clues as to what is...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.