Set ReadOnly connection between FrontEnd and BackEnd

[AlexCS]

Hi everyone,

I have a database that is currently split and I would like to prevent my users from editing data in the BackEnd database via the FrontEnd database. Unfortunately password protection is hardly an option since the BackEnd database is populated with information from an Excel file and I cannot get my VBA connection strings to open a password protected database from Excel. Could you please help me find out if there is any way to for the FrontEnd to only be given ReadOnly access to the BackEnd? I would be very grateful since my users are corrupting my BackEnd data via the FrontEnd .

Kind regards,

Alex

 

[xenou]

The simplest way to do this is to provide forms for data access to your users. Forms can easily be set as read-only. I would additionally compile the database into an exe if it is stable (not needing design changes very often) - this locks out many of the development features that you would need to get to tables and to make changes to the database and removes menus that would be used to access tables (always save a backup of the database in mdb or accdb format first - if you yourself want to make changes you'll need that original version).