J
Joseph A. Zupko
I want to create a survey using a kiosk. How can I hide the data from the
general public?
general public?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
peter walker
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
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