473,328 Members | 1,405 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,328 software developers and data experts.

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 1951
If there is a difference in how JET behaves, check if msjet40.dll is the
same version on both.

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

If you don't see the 8, go to support.microsoft.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******@Verizon.net> wrote in message
news:s9********************************@4ax.com...

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
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...
0
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) ...
0
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...
9
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...
26
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.