Determining user Operting System

[Fly Girl]

Access 2000 or Access 2002 to SQL Server.

This should be an easy one, but I can't figure out how to
find it from Help, etc.

I need to check what OS the app is being used on so I use
the right constants depending on whether it is Win2K or
WinXP or Server2003. Actually, for that matter I just need
to know if it's Access 2K or 2002.

Thanks!

 

[Tim Ferguson]

Actually, for that matter I just need
to know if it's Access 2K or 2002.

Check out help for the Version property of the DBEngine object. If you need
to work in ADO, then there is presumably an equivalent property in ADOX
somewhere.

HTH


Tim F

 

[Douglas J. Steele]

There's sample code to get the OS at
http://www.mvps.org/access/api/api0055.htm at "The Access Web".

You might also check what Randy Birch has at
http://www.mvps.org/vbnet/code/helpers/iswinversion.htm at "VBNet". (You
sometimes need to be careful taking sample code from Randy's site, as it's
aimed at VB programmers, not Access programmers, so the Form instructions
don't always transfer. However, that particular code looks like it should
port to Access without any problems)

 

[Fly Girl]

Thanks guys. I got things working.

-----Original Message-----


Check out help for the Version property of the DBEngine object. If you need
to work in ADO, then there is presumably an equivalent property in ADOX
somewhere.

HTH


Tim F

.