Results 1 to 3 of 3

Thread: Slow ado opening with large Access Database

  1. Jun 6th, 2000, 07:21 PM #1
    Paul D
    Paul D is offline

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Posts
    8

    Angry

    Why does my ado connection to my access database
    open so slowly (approx 1min). The database is large
    (14Mbytes) however using the DAO data control loads it
    under 5 seconds ???? I am using Jet 3.51 in my connection
    string.....
    Reply With Quote Reply With Quote
  2. Jun 6th, 2000, 08:16 PM #2
    Negative0
    Negative0 is offline
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367
    What exactly are you using for your connection string,

    I use this command and it opens quick

    code:

    DB.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & App.Path & "\DB.mdb"
    DB.Open
    Negative 0

    Blog | RegEx | Encrypting UN/PW in Web.Config | Enabling ASP.Net on IIS 6 | Port Numbers | Creating GUIDs | Start->Run | Modifying the default class



    Reply With Quote Reply With Quote
  3. Jun 7th, 2000, 10:49 AM #3
    Paul D
    Paul D is offline

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Posts
    8

    Question Connection String

    My connection string is...

    Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\mydb.mdb

    ???
    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