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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.