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 4 of 4
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    The sunny side of the Alps
    Posts
    230
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool Error while opening database

    I have ASP pages for storing information about visitors. I use database in Access.Sometimes, when I try to check a page where I display all information (about 600 records) I get this error message:

    Could not open more tables
    (sorry, I don't know error code)

    Could you tell me how can I correct this?

    Thanks,
    Bostjan

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    can you post your code please?

    Then someone will be able to look at your code and help you... sometimes it may just be one line that's messing it up...

    ~Quack

  • #3
    Regular Coder
    Join Date
    Jul 2002
    Location
    The sunny side of the Alps
    Posts
    230
    Thanks
    0
    Thanked 0 Times in 0 Posts
    strconn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("database.mdb")
    set conn = server.createobject("adodb.connection")
    conn.open strconn

    strSQL = "SELECT TOP 50 * FROM tabe1 ORDER BY ID Desc"
    set rs = conn.Execute(strSQL)

    Do While Not rs.EOF
    ...

  • #4
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok, thanks, hopefully I can help you here... try using this...
    Code:
    set conn = server.createobject("adodb.connection")
    conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=full_path_to_your_database.mdb"
    conn.open
    
    set rs = conn.Execute("SELECT TOP 50 * FROM tabe1 ORDER BY ID Desc")
    	
    rs.MoveFirst
    
    Do While Not rs.EOF
    ...
    ~Quack


  •  

    Posting Permissions

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