473,881 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Variations in "Jet" DB engines etc and "Unknown" error!

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 an "auto number" field so the counter goes back to
zero. The procedure I have used is to copy the contents of the table to a temp table,
empty the table and then compress the files. After that I copy back the data to the table
without the original "auto number". All this works fine on the XP machine BUT on the W98
machine exactly the same process produces " unknown" errors when I try and run the
application. That is to say, the error message is that Access has encountered an unknown
error". When I hit help, it refers me to the jet engine but thats about all.

I am wondering if there is a difference in the "jet" engine between the two systems, how I
find out, whether both systems can be given the same version (the one in the XP machine
since that does the job for me), and if so how I would set them up with the same engine.

Advice would be appreciated.

John Baker
Nov 13 '05 #1
2 1978
If there is a difference in how JET behaves, check if msjet40.dll is the
same version on both.

It's typically in windows\system3 2.
Right-click the file, and choose Version.
You should see 4.0.8xxx.0

If you don't see the 8, go to support.microso ft.com, the Downloads section,
and get SP8 for JET 4. From memory, you cannot just copy from one to the
other, as the SP is different for different versions of Windows.

Once you have JET 4 SP8, you should be able to delete from the table, and
the compact to reset the autonumber.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John Baker" <Ba******@Veriz on.net> wrote in message
news:s9******** *************** *********@4ax.c om...

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 an "auto number" field so the
counter goes back to
zero. The procedure I have used is to copy the contents of the table to a
temp table,
empty the table and then compress the files. After that I copy back the
data to the table
without the original "auto number". All this works fine on the XP machine
BUT on the W98
machine exactly the same process produces " unknown" errors when I try and
run the
application. That is to say, the error message is that Access has
encountered an unknown
error". When I hit help, it refers me to the jet engine but thats about
all.

I am wondering if there is a difference in the "jet" engine between the
two systems, how I
find out, whether both systems can be given the same version (the one in
the XP machine
since that does the job for me), and if so how I would set them up with
the same engine.

Advice would be appreciated.

John Baker

Nov 13 '05 #2
Hi again:

Some of you may be interested in the cause of my problem, and the solution.

My son in law was over this afternoon, and I mentioned the issue to him. It appears he has
run into it too, and the cause is compressing the back end of a Access system alone,
without compressing the front end as well. The front end appears to carry some of the
pointers to the back end, and occasionally when the back end is compressed that changes
the position of the objects pointed to. Compressing the front as well realigns things and
everything working properly.

While the theory about the reason for the problems may or may not be right, I do know that
compressing the front end solved the problems and the odd errors no longer happen!!

Best

John Baker
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
10414
by: Lyn | last post by:
I am trying to get my head around the concept of default, special or empty values that appear in Access VBA, depending on data type. The Access Help is not much (help), and the manual that I have is not much help here either. Googling has given me a little help. This is my current understanding -- I would appreciate any comments or corrections... "" -- this means an empty string when applied to String data type, and also to Variant...
0
1247
by: ratsekil via AccessMonster.com | last post by:
Pls Help ! "Unspecified error" ------------------------------------------------------------------------------ -- I'm using Windows Server 2003, making the webpages with ASP+Access(2000) When I load some of the pages, it warns me like that: -----------------------------------------------
0
915
by: Tony K | last post by:
My inventory app has an Access database that will need to reside on a Mapped Network Drive. It is unknown where the path will be until the application is installed. I was thinking I could make a Tools form to allow the user to select where the DB resides then I wouldn't have to recompile the program if the DB ever moves to a different location. I am using VB.NET 2005. I used the Add Data Source Wizard which created my ConnectionString...
9
1644
by: aaaaaaaadftdfgdfgdfgdfgdgdf | last post by:
Before the official story of Islamic hijackers was fed to the press, witnesses on the day in New York describe what they saw on 9/11: "That was no American Airlines jet" "It was a military plane" "It was definitely no airliner" Watch:
26
3641
by: Don Calloway | last post by:
I have created a <filename>.db1 (where <filenameis the name given to the database) Access database that is being used in multi-user mode. When the <filename>.db1 file is opened by a user, the corresponding locking file appears in the Windows Explorer view pane as well as expected. Occasionally, a "bare" db1 file (extension only without a filename) appears in the Windows Explorer window. Can anyone tell me what that file is and what it...
0
9926
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9776
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11095
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10716
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10812
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7952
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5780
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4597
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4194
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.