Anyone know of any code to find the version of a file?
Here is the senario, I manage about 130 MS Access databases. The majority of them are access 97, but I have been busy upgrading to 2000. Since most of my users access several databases throughout the day, I created a "Database Center" that is simply another database from which to launch all other databases. To open a database, the current version (version used to access the db center) is used to launch the selected db.
So, here is my problem: the dbcenter is unable to launch anything other than access 97 databases. I could create another front end (2000 version) to open 2000 dbs, but don't want to deal with an additional front end.
To fix this, I thought I could simply look at a few locations until I found the correct version of MSAccess.exe and run the correct one.
I know this is a bit wordy, but if anyone could offer some suggestions I'd appreciate it.
Here is the senario, I manage about 130 MS Access databases. The majority of them are access 97, but I have been busy upgrading to 2000. Since most of my users access several databases throughout the day, I created a "Database Center" that is simply another database from which to launch all other databases. To open a database, the current version (version used to access the db center) is used to launch the selected db.
So, here is my problem: the dbcenter is unable to launch anything other than access 97 databases. I could create another front end (2000 version) to open 2000 dbs, but don't want to deal with an additional front end.
To fix this, I thought I could simply look at a few locations until I found the correct version of MSAccess.exe and run the correct one.
I know this is a bit wordy, but if anyone could offer some suggestions I'd appreciate it.
