VB6 / Access2003 Application 1

[woodglass]

Hi,
I wish to create an Access 2003 application with a VB6 front end, to run on a Windows XP system.
Does the target system have to have Access 2003 installed on it ?.
Thanks in advance,
woodglass

 

[johnwm]

Access is the front end for Jet DB, and is not redistributable without license.
If your application uses bits of Access (like forms or reports), then yes you need Access installed.
If your application only uses the Jet DB engine with all forms and reports in VB6, then no
The safer way is to use ADO from VB to access the Jet DB, or better yet use ADO interface to MSDE (SQL lite)

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[bjd4jc]

>>If your application uses bits of Access (like forms or reports), then yes you need Access installed.

I believe that you used to also be able to download and install something called Runtime Access. I know there are licensing restrictions with it but I am not sure what they are... it might be worth looking into if this fits your scenario.

 

[woodglass]

Thanks for your response guys !.
I think I'll go down the route of using ADO from VB to interface to MSDE.

Is there a good book you can recommend me on acccessing databases using this approach ?
woodglass...