Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Sep 2004
    Posts
    713
    Thanks
    6
    Thanked 2 Times in 2 Posts

    problem with connection string

    Hi

    i created one access database and assigned a password to it, however when i try to connnect the following connnection string, i failed, anybody can help me?
    Code:
    objconn.Open "provider=microsoft.jet.oledb.4.0;user id=Admin;password=testtest;" & "data source = " & server.mappath("moads.mdb")& ";Persist Security Info=true"
    flying dagger

  • #2
    Regular Coder Baleric's Avatar
    Join Date
    Feb 2005
    Location
    Australia
    Posts
    332
    Thanks
    0
    Thanked 0 Times in 0 Posts
    http://www.connectionstrings.com/?carrier=access

    i also think that you have to do data source before the user name and password,
    but check out the above link and apply the best method for what you are doing.


  •  

    Posting Permissions

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