1. did that. so path is
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\SmallBusinessMedia\Websites\everythingforthechef\htdocs\database
now it errors
Data Source name too long
2. Tho this would solve the local issue, my connection for the remote server is good for a new test page but doesnt run my previously built pages that were connected via the DSN. my index2.asp page for instance wont run, tho it is using the include file eftc.asp which has the new info in and which is fine for the newly createde test2.asp page (which has no recordsets)