VB and Access 97 Query

[nmretd]

I have created an application in VB. One of the options that is included within this App is to run an Access 97 Macro. If I put my .mdb file on a network drive and use this VB application on a pc which is networked but does not have Access 97 installed locally, will it function properly, i.e will VB run the macro ?

[Clunietp]

probably not, becuase if you use

set axs = new access.application

it creates the MS Access object on the client PC. If access is not installed, then you won't be able to create the object. You can only manipulate queries and tables via VB of an access database w/o having MS Access installed.

HTH

Tom