SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2004
    Location
    Singapore
    Posts
    67
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connect to database that is secure

    Currently i making a database oriented website, but need to protect my client information from being leak so i used the access security password to lock the database. So what must i add in the script to unlock the database on connection by the client.

    Connect = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath(".\Info.mdb")

  2. #2
    SitePoint Member
    Join Date
    Dec 2004
    Location
    Canada
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you can try:

    Connect="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\databases\yourdb.mdb" & ";Jet OLEDB:Database Password=1234"

    If you want to secure things, I would not have the MDB files www accessible. Have them in a directory parallel to the web directory. Ie.

    c:\inetpub\databases
    c:\inetpub\wwwroot

    just my $.02.


Bookmarks

Posting Permissions

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