Exporting Database to Autorun CD

  • Thread starter Thread starter Daniel Lord via AccessMonster.com
  • Start date Start date
D

Daniel Lord via AccessMonster.com

Hi

We would like to export an Access 2000 database to an Autorun CD so that it loads straight to a basic query form. Is there a straight forward way of doing this?.

Also the database contains some data that ideally we do not want end users to have access to. Is there a way of locking down the data/database such that users only have access to the query form and resulting report outputs?

Thanks
 
Hi Daniel,

Will the users have Access 2000 or later on their computers? If not,
there's no simple way, in fact as far as I know no way at all short of
including an Access run-time package on the CD and demanding that users
install it.

Assuming Access will always be present and properly installed, set the
form you want as the startup form in the database, and use the
Autorun.inf stuff on the CD to launch it.

As for security, the best rule is that if you don't want people to have
the data, don't distribute it. Remove any confidential data that's not
essential for the queries you want the users to perform. If these
queries aggregate or adjust confidential data to produce
non-confidential output, consider storing the aggregated/adjusted data
in the tables so the confidential stuff simply isn't in the database.

Having gone as far as you can that way, the next step would normally be
to apply user-level security to the database, giving the default Admin
user minimal permissions to use the relevant forms and reports and
queries, but no permission to view the tables. THe only access to the
tabls would be via "run with owner's permissions" queries.

You'd have to distribute the .mdw file along with the database file, of
course. One thing I don't know is whether it's possible to open a
secured Access app when the .mdw is on a CD and hence read-only.

HTH


Hi

We would like to export an Access 2000 database to an Autorun CD so that it loads straight to a basic query form. Is there a straight forward way of doing this?.

Also the database contains some data that ideally we do not want
end users to have access to. Is there a way of locking down the
data/database such that users only have access to the query form and
resulting report outputs?
 
Back
Top