Results 1 to 2 of 2

Thread: [Access] Ado - refresh my memory

  1. Nov 7th, 2008, 06:28 AM #1
    Ecniv
    Ecniv is offline

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    [Access] Ado - refresh my memory

    Hi,

    Connecting to an Acces mdb via ado. If I want to open a query, do I use adcmdStoredProc or adCmdTable...

    I just tried it and table works, stored proc didn't. But just to refresh my memory on why.

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  2. Nov 7th, 2008, 08:04 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: [Access] Ado - refresh my memory

    Is it necessary to use either? Wouldn't just using DoCmd.RunSQL strSQL work?
    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