Database Access Version

  • Thread starter Thread starter shaggie
  • Start date Start date
S

shaggie

Does anyone know how to get the Access Database version from the database,
without opening it in Access.

I have no problem opening it in code from VB using DAO or ADO, or as pure
binary (read mode).

The problem is that we have multiple versions of Microsoft Access installed
on each machine.
I want to be able to automate opening it up in the correct version of Access

I can already get the Jet version using ADO.
Unfortunately, that is not good enough, because our clients are now getting
into using Access 2002 & 2003 databases.

Any & all help is greatly appreciated.

Mark
 
This is what you really need to use

FMS Total Access Startup
http://www.fmsinc.com/Products/startup/index.asp

Here is some brief information about it:

* Start the Access version you specify
For example, your users will always run Access 97 with your Access 97
databases, regardless of the Access versions installed on their machine or
what Windows considers the default for MDB files. Eliminate the need to
convert your existing Access applications to later versions, while safely
migrating to the newest version of Office.

* Detect and run the latest version of your Access database
If desired, Total Access Startup automatically installs and updates your
user’s local copy when you release a new version.

Please let me know if you have any questions.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
What I should have said is that I have no qualms opening it in code from VB
using DAO or ADO, or as pure binary (read mode).
 
I don't believe that will be helpful as truthfully I need the ability to
open the correct version of MSAccess from our own VB app.
I am hoping for any ideas that can point me in the right direction.

Mark
 
One of the end results is a short-cut that is created. If you can determine
how to execute a short-cut via code, then TA Startup will still be something
useful for you. You won't have the headache of writing and maintaining code
for each launch.



--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
The problem is that we use CreateObject to be able to control the access
application.

Shelling Access will take that capability away from us.
 
This is not an answer, but a question, for Mark. I was
wondering if you could post the code that allows you to
tell what version of Jet is being used? And also, do you
know if one version of Jet could be used on one
workstation, say Windows 95, and another on a different
workstation, say Windows XP Pro for the SAME database? I
have a client with data corruption problems and suspect
this as a problem. They are still on Access 2 but I plan
to upgrade them to XP soon and so thought I could use
your code (ADO) then!

Thanks in advance if you do get the chance to reply.

Shelley
 
AFAIK, Access 2 only uses JET version 2 (16-bit database engine) and no
others regardless of the OS.

If they are pure Access / JET database, there is no advantage in converting
the code to use ADO. Stick with DAO as DAO is especially built for JET.
 
How do you know this? I am having a difficult time
finding documentation about Jet and versions. If you have
recommendations, I would greatly appreciate them.

I see that Jet is on the Windows Update site, not the
Office Update site which is what made me think it is
dependant on the version of Windows they are using.

Thank you,
Shelley
 
Experience.

Access version JET version
Access 1 JET 1
Access 1.1 JET 1.1
Access 2 JET 2
Access 95 JET 3.0
Access 97 JET 3.5
Access 2K + JET 4

I doubt whether any updated version of JET 2 is still available on Microsoft
Web site since Microsoft support for Access 2 ended quite a few years back.

Windows Update probably provides update of JET 4 (it is now up to version 8)
but definitely not JET 2.
 
Thank you very much Van.

-----Original Message-----
Experience.

Access version JET version
Access 1 JET 1
Access 1.1 JET 1.1
Access 2 JET 2
Access 95 JET 3.0
Access 97 JET 3.5
Access 2K + JET 4

I doubt whether any updated version of JET 2 is still available on Microsoft
Web site since Microsoft support for Access 2 ended quite a few years back.

Windows Update probably provides update of JET 4 (it is now up to version 8)
but definitely not JET 2.

--
HTH
Van T. Dinh
MVP (Access)






.
Click to expand...
 
Back
Top