Access 2003 Runtime or Full version?

[callmebruce]

Is there any way to determine a machine is installed with Access 2003 runtime or full version. My enironment is all machines have runtime, but some with full version.
I am trying to find all full version and upgrade to 2007 full.
Thanks for your help.
CMB

 

[lameid]

I would think the following code would error if it is the runtime....

DoCmd.SelectObject acTable, , True

I'm curious to see if that works, since I don't have the runtime.

 

[callmebruce]

lameid,
I post this question on the SMS forum instaed since I am looking for a way to query the SMS inventory.
Thank you very much for your comment.
CMD

 

[lameid]

I bet if you read the version of MSAccess.exe you would get enough information to figure it out... you could even check via the OS before going down that path.

 

[callmebruce]

Yeap, tried that.
Can't tell the diff from msaccess.exe & version.
Thanks

 

[payback]

Have a look at -

http://www.allenbrowne.com/ser-53.html

Lots of good utilities and assistance available on his site.