Use two databases. (both MDE files)
One database is the front end and the other the back end.
Forms / reports use inline SQL and use the IN keyword to specify the
database containing the tables. This backend file can be called
'wsurvey.dll' in the system folder because the path of the database is
specified in the SQL. (it need not say xxx.mdb)
Querie(def)s can be created on the fly and deleted after use.
Since the front end is an mde, users can't read the inline SQL and the
databases appears to have no tables or queries.
--
peter walker MVP
Please post replies to the news group so everyone can benefit. www.papwalker.com
