front end

  1. O

    Questions about usage of SQL Server as Back end and MS Access as Front End

    Dear Friends, I am now so close to finish my Access database (2016) which include both Front end and back end. This will be used by around 200 users. I have 13 table and 13 forms. Current size of the access is 30 MB. I think it will be 1 GB after a year. So I have a plan to use SQL Server as...
  2. A

    Access altered front end

    Hello I have a theoretical question here. So say I have a split database and I distribute the front end to users (an actual copy of the frontend not a shortcut) now if they altered their copy and messed with the forms things like added minimize maximize buttons, created new queries, created an...
  3. G

    I want to write a comprehensive program... I think

    Hi all! I have a question that is somewhat general, I'm really looking for a starting point, or a thread that can help in more depth. I do consulting work for golf courses - my background is in turf - and as part of my consulting, I often "build" chemical and fertilizer programs for use by...
  4. A

    Set ReadOnly connection between FrontEnd and BackEnd

    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...
  5. A

    Excel front end Access back end

    Hi, I have recently started documenting our network and server racks. I have decided to try and manage the document by using an Excel front end and Access back end. Not sure if this a great idea as I have no experience accessing data held in Access via Excel. Anyway... I have created a visual...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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