JET Version (?)

C

croy

At a small satellite office of the government of a western
U.S. state, our Windows XP Pro computers are imaged with
Office 2002, and we exchange a number of MDB files with
other offices.

Which version of JET should these machines be running?
 
D

David W. Fenton

At a small satellite office of the government of a western
U.S. state, our Windows XP Pro computers are imaged with
Office 2002, and we exchange a number of MDB files with
other offices.

Which version of JET should these machines be running?

Er, what?

If they have Office XP and Access 2002 (the version that came with
Office XP), they'll be running Jet 4 (as they would be with Access
2000 and Access 2003, as well).

But the Jet version is not the same as the Access version. Remember,
and Access MDB is a modified Jet database, with objects in it that
Access understands and that Jet knows nothing about (except that
they are stored as blobs of data in Jet tables).

If you need to share an Access MDB between multiple versions of
Access, the lowest common denominator is Access 2000 format. You
only need one of the later formats if you're using the features that
were introduced in those later versions. If you're exchanging
nothing but data, then there is no need for the later Access formats
at all, which apply only to application objects
(forms/reports/etc.).
 
C

croy

Er, what?

If they have Office XP and Access 2002 (the version that came with
Office XP), they'll be running Jet 4 (as they would be with Access
2000 and Access 2003, as well).

But the Jet version is not the same as the Access version. Remember,
and Access MDB is a modified Jet database, with objects in it that
Access understands and that Jet knows nothing about (except that
they are stored as blobs of data in Jet tables).

If you need to share an Access MDB between multiple versions of
Access, the lowest common denominator is Access 2000 format. You
only need one of the later formats if you're using the features that
were introduced in those later versions. If you're exchanging
nothing but data, then there is no need for the later Access formats
at all, which apply only to application objects
(forms/reports/etc.).


Thanks for the reply, and sorry for the runaround, David.

I was reading the doc's on Jet 4.0, and searching for the
files mentioned, to see what version was installed and
running, and wasn't coming up with *any* of the files!
That's when I posted my question here.

Then I find that the search function in Windows Explorer
wasn't set to look in subdirectories! I don't ever recall
setting it like that, and it has up until recently always
defaulted to search the subs, and I got so used to it that I
didn't even notice the difference. I'm guessing that MS has
snuck something in with the recent security updates that
changes the default behaviour, because now, whenever I
search, I have to manually set it to search the subs. Guess
I should read the bulletins a little closer... ;-l

Thanks again for your reply.
 
D

David W. Fenton

Then I find that the search function in Windows Explorer
wasn't set to look in subdirectories! I don't ever recall
setting it like that, and it has up until recently always
defaulted to search the subs, and I got so used to it that I
didn't even notice the difference. I'm guessing that MS has
snuck something in with the recent security updates that
changes the default behaviour, because now, whenever I
search, I have to manually set it to search the subs. Guess
I should read the bulletins a little closer...

WinXP's search functionality really sucks. By default it doesn't
return hidden/system files, nor protected OS files. So, if you don't
tell it specifically to do that, it won't show you the MSJET40.DLL
file, which is in %WinDir%\System32.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top