Results 1 to 4 of 4

Thread: [02/03] MS Access interface: Your Opinion

  1. Nov 3rd, 2006, 12:10 PM #1
    circuits2
    circuits2 is offline

    Thread Starter
    Frenzied Member circuits2's Avatar
    Join Date
    Sep 2006
    Location
    Kansas City, MO
    Posts
    1,027

    [02/03] MS Access interface: Your Opinion

    I know this isn't the Database forum, but this form provides better answers and exposure. What is best (pros and cons) to use when interfacing with an MS Access database: ADO or OleDb?
    Last edited by RobDog888; Nov 3rd, 2006 at 01:08 PM.
    Show the love! Click (rate this post) under my name if I was helpful.

    My CodeBank Submissions: How to create a User Control | Move a form between Multiple Monitors (Screens) | Remove the MDI Client Border | Using Report Viewer with Visual Studio 2012 Express
    Reply With Quote Reply With Quote
  2. Nov 3rd, 2006, 12:21 PM #2
    kaffenils
    kaffenils is offline
    Fanatic Member kaffenils's Avatar
    Join Date
    Apr 2004
    Location
    Norway
    Posts
    946

    Re: MS Access: Your Opinion

    Quote Originally Posted by circuits2
    I am developing an application that uses an Access database. What is the best (pros and cons) to use as the interface: ADO or OleDb?
    ADO and OLE DB are the same thing. ADO is a more user friendly API for OLE DB.


    Tutorial: SQL Server recursion
    Small ADO demo
    Reply With Quote Reply With Quote
  3. Nov 3rd, 2006, 01:01 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: MS Access: Your Opinion

    Depends on what your using for your front end? VB 6 or .NET etc.

    .NET has optimized providers for Accecss - OleDbConnection, OleDbDataAdapter, etc.
    Last edited by RobDog888; Nov 3rd, 2006 at 01:08 PM.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Nov 3rd, 2006, 01:04 PM #4
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: [02/03] MS Access interface: Your Opinion

    Please dont cross forum post.

    I will merge the other thread with this one.


    Done.


    Edit: Since this is now deemed as VB.NET you should be using ADO.NET vs ADO or anything else.
    Last edited by RobDog888; Nov 3rd, 2006 at 01:09 PM.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    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