Hiding Data

J

Joseph A. Zupko

I want to create a survey using a kiosk. How can I hide the data from the
general public?
 
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
 

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.

Ask a Question

Similar Threads

Hide textbox on a record - Continuous form 3
Cell data entering slow! 0
Hide data in a field on a form 6
Access 07 and Win 8 Touchscreen 5
Mis-performing MP4 files in Mac PPT 1
VBA - exporting serial letters to single documents 0
Create form with checkbox les that expand and collapse sections of the form? 0
hiding blank rows 3

Top