Results 1 to 2 of 2

Thread: Open

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Open

    I have a question.
    I want to open the MS Access file with user-level Security.

    I know that if I do NOT setup user-level Security in the MS Access file, and create the table for login in the MS Access file, then it works. I did that.
    But, I want to know whether or not we can use ASP code to open the MS Access (MS Access user-level Security setting).

    Can we do it in ASP?

    The following code cannot support it:
    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/try.mdb"
    %>

    Please let me know, thanks.

  2. #2
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53
    Code:
    dim routefile, conn
    
    routefile = "c:\somepath\db.mdb"
    
    conn.open "DRIVER={Microsoft Access Driver (*.mdb)};" &_ 
                  "DBQ=" & RouteFile & ";DefaultDir=;UID=;PWD=;"
    add uid and pwd.
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

Posting Permissions

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