Results 1 to 6 of 6

Thread: access database

  1. #1
    Join Date
    Dec 2002
    Posts
    12

    Unanswered: access database

    COuld any body send an Access 2002 databse to me or to this site in order to get to know the preliminary features of Access 2002.?

    The one in my hand is corrupted.

    Thanks and regards,
    Den.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032

    Re: access database

    Originally posted by dennisid
    COuld any body send an Access 2002 databse to me or to this site in order to get to know the preliminary features of Access 2002.?

    The one in my hand is corrupted.

    Thanks and regards,
    Den.
    A lot of main features are still the same from Access 97. Thus for compatibility purposes (since not everyone has the latest version of Access on their PC) I've got a free sample Access invoices database that you could download at http://www.bullschmidt.com/access
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Dec 2002
    Posts
    12
    Hi Bullschmidt,

    Thank you for the response..
    That was a great work

    What I want is an Access 2002 mdb file.

    I want to check whether or not MS Jet 4.0 will support Access 2002 database .

    Please give an answer or get me an Access2002 file..

    Thanks,
    Den.

  4. #4
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Originally posted by dennisid
    Hi Bullschmidt,

    Thank you for the response..
    That was a great work

    What I want is an Access 2002 mdb file.

    I want to check whether or not MS Jet 4.0 will support Access 2002 database .

    Please give an answer or get me an Access2002 file..

    Thanks,
    Den.
    The only way you could open an Access 2002 file would be if you have Access 2002 (or higher) on your computer. And if you do, then to convert an Access 97 file to Access 2002, do this:

    Open the file | Then Tools | Database Utilities | Convert Database | To Access 2002 File Format
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  5. #5
    Join Date
    Dec 2002
    Posts
    12
    Hi,

    Can I use the following code to connect to an MS Access 2002 database from VB or ASP?
    (file2002.mdb is an Access 2002 file.)


    Set conn = New ADODB.Connection

    With conn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .Properties("data source") = "c:/file2002.mdb"

    .Properties("password") = "admin"
    .Properties("user id") = ""
    .Open

    End With

    Thanks,
    Den.

  6. #6
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Originally posted by dennisid
    Hi,

    Can I use the following code to connect to an MS Access 2002 database from VB or ASP?
    (file2002.mdb is an Access 2002 file.)


    Set conn = New ADODB.Connection

    With conn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .Properties("data source") = "c:/file2002.mdb"

    .Properties("password") = "admin"
    .Properties("user id") = ""
    .Open

    End With

    Thanks,
    Den.
    Taking a quick look it looks alright although my style is usually more like this:

    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/mydbdir/mydb.asp") & ";Jet OLEDBatabase Password=mypassword;"

    Set objConn = Server.CreateObject("ADODB.Connection")

    objConn.Open mstrConn

    And http://www.asp101.com/samples has some good database examples.

    And here is a good connections strings resource:
    Able Consulting - ADO Connection String Samples
    http://www.able-consulting.com/ADO_Conn.htm
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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