?
Solved

finding version of access mdb that is given to you.. (older file)

Posted on 2015-01-29
8
Medium Priority
?
286 Views
Last Modified: 2015-01-31
This access file is probably 2000 or 2002 or 2003.. is there a way to confirm what exactly is the version of the access file (mdb).

thanks.
0
Comment
Question by:25112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 288 total points
ID: 40579093
Set db = CurrentDb()
Me.txtAccessVersion = db.Properties("AccessVersion")
Me.txtJetVersion = db.Version

This is code behind a form hence the "Me." references.
0
 
LVL 29

Assisted Solution

by:IrogSinta
IrogSinta earned 288 total points
ID: 40579103
Well one way would be to open the database and type CTRL-G, then in the Immediate Window, enter the following:
?SysCmd(acSysCmdAccessVer)

If the result you get is 9.0, you have Access 2000.
8.0 - Access 97
9.0 - Access 2000
10.0 - Access 2002
11.0 - Access 2003

Ron
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1136 total points
ID: 40579108
That tells you the version of Microsoft Access you are in ... not the version of the actual MDB format.

I have an A2000 mdb  open in A2013 ...
?SysCmd(acSysCmdAccessVer)
15.0
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1136 total points
ID: 40579113
And .Version just gives you a number like 4.0 ... which is not to useful
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1136 total points
ID: 40579145
OK I found this ... and it seems to be accurate ... will need to add Cases for later versions
Basically it's using CurrentProject.FileFormat

Dim objAccess As Object
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\Access2003Clients\BLM\Data\AMAPSData.mdb"

intFormat = objAccess.CurrentProject.FileFormat

Select Case intFormat
    Case 2: Debug.Print "Microsoft Access 2"
    Case 7: Debug.Print "Microsoft Access 95"
    Case 8: Debug.Print "Microsoft Access 97"
    Case 9: Debug.Print "Microsoft Access 2000"
    Case 10: Debug.Print "Microsoft Access 2003"

End Select
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1136 total points
ID: 40579152
Seems for an A2013 ACCDB  the number is 12, which means that ...so ???

So I'm guessing from this  we cannot definitely tell exactly WHICH version of Access it really is.
Not sure what 11 - if it even exists - would be.  Might be A2007 ... IF ... there was any change between an A2007, A2010 and A2013 ACCDBs ...

And since 9 is 2000 and 10 is 2003 (I tested both of these) ... then A2002 is also 9 ... and I don't think there was any file format change between A2000 and A2002 ( aka XP).
0
 
LVL 4

Accepted Solution

by:
Monika Bharti earned 288 total points
ID: 40579192
Hi,

I think i got a relevant article written by David Klein to determine the version of (.mdb) Access file. The following article helps you to resolve your query of finding version of access mdb, he tried to accomplish that without opening the Access mdb database.

http://www.ssw.com.au/ssw/kb/KB.aspx?KBID=Q989827
0
 
LVL 5

Author Comment

by:25112
ID: 40582091
helped.thanks.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question