thanks jason.
regards my other point about the DSN-less connection that you replied to yesterday, would you be kind enough to quickly just comment on the following and then i promise to leave you alone as i appreciate this is wide of webassist's remit - i'm just a bit confused.
i m,anged to get a new ASP page to connect using:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "E:\Domains\e\everythingforthechef.com-19969252\user\database\chef.mdb"
%>
it works fine for a new test page that has had no recordsets already created, but if i apply this to a page that already exists with recordsets, it doesnt work. If i open the Add Recordset DIalog box in DW, it says "Unable to retrieve tables from this connection, click on the Define button and test connection"
When I look at the code for a recordset they all refer to the previous conn_chef DSN connection, i.e ;
<%
Dim rsMfrMenu
Dim rsMfrMenu_cmd
Dim rsMfrMenu_numRows
Set rsMfrMenu_cmd = Server.CreateObject ("ADODB.Command")
rsMfrMenu_cmd.ActiveConnection = MM_eftc_STRING
rsMfrMenu_cmd.CommandText = "SELECT * FROM tbl_mfr ORDER BY item_mfr ASC"
rsMfrMenu_cmd.Prepared = true
Set rsMfrMenu = rsMfrMenu_cmd.Execute
rsMfrMenu_numRows = 0
%>
Is there a way around this or will my new DSN-less connection mean my pages won't work?
If you could point me in the right direction I'd be grateful as ever.
thanks