Results 1 to 3 of 3

Thread: Replacing a SQL Server DB with an Access DB

  1. May 8th, 2001, 11:50 AM #1
    jdavison
    jdavison is offline

    Thread Starter
    Addicted Member
    Join Date
    Jun 2000
    Location
    Pittsburgh, PA
    Posts
    149
    Did you set the odbc connection up?
    Reply With Quote Reply With Quote
  2. May 8th, 2001, 03:57 PM #2
    Sastraxi
    Sastraxi is offline
    Good Ol' Platypus Sastraxi's Avatar
    Join Date
    Jan 2000
    Location
    Ontario, Canada
    Posts
    5,134
    2 pieces of advice:

    Make sure the connection string uses the right driver. Also, I think you should use both ADODB.Recordset and ADODB.Connection to connect:

    oConn.Open strConnect, "Admin", "YOUR_PWD"
    oRec.Open "TableName", oConn, adOpenStatic, adLockOptimistic, adCmdTable
    All contents of the above post that aren't somebody elses are mine, not the property of some media corporation.
    (Just a heads-up)
    Reply With Quote Reply With Quote
  3. May 9th, 2001, 07:11 AM #3
    MarcelB
    Guest
    jdavison: Yes, I did..

    sastraxi: I'm pretty sure I'm using the right driver, and I always connect to my SQL Server DB in the way I did and it works just fine, so unless there's some difference between SQL Server and Access (in connecting with it, I mean), this should work too..

    Anyone else maybe?
    Thanx!
    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