Views don't necessarily have to be used with forms. Just issue:

OPEN DATABASE MYDATABASE SHARED
USE MYVIEW SHARED
INSERT INTO MYVIEW (field1, field2) VALUES ('TEST', 'TEST')
TABLEUPDATE()
USE


Also...
Have you looked at SQLCONNECT() and SQLEXEC()?

SQLCONNECT will make the connection and return the connection handle, then you can use SQLEXEC to make SQL calls to the extent that the ODBC driver for access supports them:

lnHandle=SQLCONNECT(ODBC connection, username, password)
SQLEXEC(lnHandle, 'SELECT * FROM PUBS', 'csrTemp')
or
SQLEXEC(lnHandle, "UPDATE PUBS SET AUTHOR='Hans' WHERE ...", 'csrTemp')

You can also use ADO recordsets as a go between, but in this case it sounds like more work than it's worth.

Mike