General discussion



By vitalhostage ·
I have been tasked by my Highly esteemed manager this weekend to produce a report for the following:

The background:
We are currently using Office 2000 and have been for about a year and half since our implementation of Windows 2000 across the LAN. However we never used Access 2000 because so many people had produced their own databases that it was just not sensible to roll out Access 2000, for fear of the widespread problems it could potentially cause.


We have a project for rationalising these DB's across the LAN.

My Job:

My manager wants a list of all the current Access 97 DB's from all of our Application and File and Print servers this weekend.
Although we do not use Access 2000 in general, there are some DBA's who tinker with it and therefore there will undoubtedly be some Access2000 DB's on the servers in some fashion.
Does anyone have any bright ideas to be able to search for the 97 files and exclude the 2000 ones and then be able to input this data intoa spread to provide a comprehensive list?

Any help would be greatly appreciated

Many thanks

Steve Johnson

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -


by CCJonathan In reply to Access97/2000

Try this:

You may have to modify the VB code for use on whatever medium your users search from (portal/website, etc), but in general, it will help you retrieve the version from the MDB file.

Hope this helps!

Collapse -


by CCJonathan In reply to Access97/2000

the link pasted in improperly with an extra space in the word "library"... be aware of this when you copy/paste the URI into the browser.

Related Discussions

Related Forums