Results 1 to 2 of 2

Thread: VB and Access 97 Query

  1. Oct 21st, 1999, 02:20 PM #1
    nmretd
    nmretd is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 1999
    Location
    London, England
    Posts
    213

    Post

    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 ?
    Reply With Quote Reply With Quote
  2. Oct 21st, 1999, 09:05 PM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width