Multiple Access versions...ideas on a postcard...

[mattkorguk]

Hi All,
We currently run multiple versions of Access around the building (97, 2000, 2003), due to some departments having 'business critical' (other) Dbs running on the same version. (Mostly 97) I've tried to ask nicely to get them to update, but you know how it is...
So I was wondering, has anyone been able to have a master Db/ shortcut/ link which could look and see which version a user has installed, check their access rights (as some users only have read only access), check the drive mapping (as some depts have different mappings) and then forward that user to the relevant Db? Or a master Db able to handle all?!
I know it sounds straight forward, but I'm pretty sure it's not going to be!

Any ideas welcome.

 

[Uncle Gizmo]

I have definitely seen code for checking the version of access you are using, I'm not sure if it you can check the version of an unopened access file?

But I think there's definitely some code of that nature here, well not definitely, reasonably sure, well not reasonably we sure, I think it's here somewhere.

 

[mattkorguk]

Thanks for that I shall have a look around and see if anything jumps out!

 

[ecawilkinson]

Hi Matt,

I think that you may find the attached file useful. It is a vbscript which you can of course put in a central location and create shortcuts to it. Its purpose is to check the Access version and then open the appropriate DB. It is not intended as an exact solution to your problem but more a springboard for ideas, so do not expect it to work. you can check a PC's drive mappings:

' put the list of drive mappings into the oDrives array
Set WshNetwork = CreateObject("WScript.Network")
Set oDrives = WshNetwork.EnumNetworkDrives()
For ictr = 0 to oDrives.length - 1 step 2
' ictr is the drive letter, ictr+1 is the corresponding mapping
next

Not sure about the access, it depends how you have imposed the rights, but I'm sure it can all be achieved in a single vbscript file which the user either double-clicks or you create a shortcut to it for them.

HTH,
Chris

 

[mattkorguk]

Thank you very much Chris, that's a really good starting point for me.
Thanks again,
Matt