Set ReadOnly connection between FrontEnd and BackEnd

AlexCS

Board Regular
Joined
Oct 31, 2011
Messages
78
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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,796
Office Version
  1. 2019
Platform
  1. Windows
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,720
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top