How to find the version of Jet installed?

[Guest]

I have an Access database that was created with Access 2002. One of my users
recently had his Access version upgraded to 2003. Since then, he has been
getting the error message "The search key was not found in any record".

From what I can tell, this could have something to do with the database
being created with a different Jet version than what the user is using.

How do I tell which version the user has installed? I've searched for an
answer and all I can find is how to install the latest version or "if you
have ___ version of Access you should have ___ version of Jet" but that's not
what I want. Before I try getting into intalling versions, I want to see
what his current version is.

Does any one know how I go about doing this?
Thank you.

 

[Guest]

C:\WINDOWS\system32
Find
msjet40.dll
Go to properities and look there
I think I have most current version @ 4.00.8618.0

 

[John W. Vinson]

I have an Access database that was created with Access 2002. One of my users
recently had his Access version upgraded to 2003. Since then, he has been
getting the error message "The search key was not found in any record".

From what I can tell, this could have something to do with the database
being created with a different Jet version than what the user is using.

How do I tell which version the user has installed? I've searched for an
answer and all I can find is how to install the latest version or "if you
have ___ version of Access you should have ___ version of Jet" but that's not
what I want. Before I try getting into intalling versions, I want to see
what his current version is.

Does any one know how I go about doing this?
Thank you.

Find the file named MSJET40.DLL - it should be in \Windows\System32. Right
mouseclick it in Windows Explorer and view its Properties; the version will be
on the Version tab.

John W. Vinson [MVP]

 

[Susie DBA [MSFT]]

JET and DAO haven't been updated or included with Windows, MDAC or
Office for the past decade

move to Access Data Projects, kid

 

[Tony Toews [MVP]]

I have an Access database that was created with Access 2002. One of my users
recently had his Access version upgraded to 2003. Since then, he has been
getting the error message "The search key was not found in any record".

That message is a sign of corruption. Is the MDB in which he is getting this
message unique to him or can other people use the MDB without a smilar message.

From what I can tell, this could have something to do with the database
being created with a different Jet version than what the user is using.

I very much doubt it. Although it is possible that that user might have a
different version of Jet than the others.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

That message is a sign of corruption. Is the MDB in which he is getting this
message unique to him or can other people use the MDB without a smilar message.

The user has a front end & replicated backend on his PC and he synchs the
backend directly with a master backend on a server which several other users
also synch to. He is the only one that has been getting this error message
but then he's also the only one who had his version of Access upgraded to
2003.

He has been able to synch the backend (at least it seems to synch - he gets
a message that it was successful) but when he opens the front end, he gets
the error message.

I am going to have him check his version of Jet when he gets in today and
replace the front end. I've already had him try to compact & repair his
backend but that didn't work. If replacing the front end doesn't do the
trick I guess the next thing to try is having him create a new replica.

Thanks for your help.

 

[Tony Toews [MVP]]

If replacing the front end doesn't do the
trick I guess the next thing to try is having him create a new replica.

In your situation those are the two things I'd do.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm