Hi,<BR><BR>I have an asp page that works fine on every IIS/PWS platform I have tried. However, on one server simple code produces the following error...<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error '8000ffff'<BR><BR>Query cannot be updated because the FROM clause is not a single simple table name.<BR><BR>Its very strange. In a few places things work ok, but not in others. The Access 2000 database has two tables connected in a one to many, but even taking the table relationship out does not fix the problem (even though the update/create recordset only use one table!). Using DSN or DSN-less with the access driver does not make a difference.<BR><BR>Has anyone a thought that may help me? It works fine on all other machines and is simple clean code...but I can't find out why this server is different!<BR><BR>Thanks!