How do you tell which version was used to make an Access database?

[Richard Lawson]

I am working on a project which seems to be made with different versions of
Access. How can I tell which version of Access was used for each database?

Rich

 

[Preet]

hi!

Have you used

dim obj as new access.application
obj.currentdb.properties(13).value
Is it ok let me know.
bye.

 

[Richard Lawson]

I have not tried that. I am working in VB and connecting to a application
which has 200 separate Access databases. Some of these will open in Access
2000 while others are older and have to be converted.


The VB program has a problem with the different versions.

Thanks for the tip. I will not be able to work on it until evening. I will
let you know.

Rich

 

[John Nurick]

One possibility (I haven't used it myself) is LISTMDB at
http://www.aylott.com.au/accver.htm

 

[Richard Lawson]

Thanks. The URL worked great but only delivers 10 database results for the
trial version. Full version costs $20 which seems pricey for such a small
app. Still, it told me what I need to know. I think I will just write VB
code to scan the entire database. I currently have written VB code to
migrate data from the databse but I get problems when the Access version
changes.

Thanks,

Rich

 

[John Nurick]

Full version costs $20 which seems pricey for such a small
app.

Depends on the value you put on your time. If it's going to save you an
hour's coding...