>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Try to open multiple tables
>Date: Sun, 14 Apr 2002 20:02:20
>
>Hello
>I've a DB made with Access with many tables... I have to open 3 tables in
>a page and if on my pc everything goes well, on server it gives me this
>error:
>
>An error occurred on the server when processing the URL. Please contact
>the system administrator.
>
>
>this is my code to opening many tables. I've no DSN.
>
>Try this
>Dim rs, rs1, rs2, foundit,
>Set rs = Server.CreateObject("ADODB.Recordset")
>rs.Open "Tbl_1k", connStr,1,1, 1
>
>Set rs1 = Server.CreateObject("ADODB.Recordset")
>rs1.Open "Tb2_1k", connStr, 1,1,1
>
>Set rs2 = Server.CreateObject("ADODB.Recordset")
>rs2.Open "Tb2_1k", connStr, 1,1,1
>
>what's the error?
>
>Nick


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx