Results 1 to 3 of 3

Thread: Access to Vb

  1. #1
    Join Date
    Sep 2004
    Posts
    112

    Unanswered: Access to Vb

    Hi,
    I am converting an Accounts program which I have wrote in Access 2000. I have managed to convert all the forms ok but I am struggling connecting to the data. I am connecting to the access database using a connection string which works fine. On my main accounts form in access I used a query named 'ao4' which had 5 tables linked. The form works if I use the access query in vb but it takes 5 minutes to load!. Does anyone know of a better way to get at the data. ( I have tried saving the query as sql and pasting it in to the record source but I get an error).
    Can any one help?????????

    Saltman

  2. #2
    Join Date
    Nov 2004
    Posts
    108
    try creating a view or query in Access with parameters and invoke it from VB
    to err is human ; to really mess things up requires a computer

  3. #3
    Join Date
    Nov 2004
    Posts
    1
    For some reason, MS overlooked database connectivity from within Visual Basic when they made Access 2000. To use the databases in VB, you need to convert them to Access 97 from the Tools menu in Access. Either that or use the latest version which works too.

Posting Permissions

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