It could be done that way. One could also use a stored procedure for inserts. Are you planning to keep an Access database as a front end?