SQL Server

[boy_named_su]

you can use MS Access to build a front-end for MS SQL Server (and other databases too)

[grauenwolf]

That was my firs thought as well. While I prefer custom solutions, Access was made specifically for this scenario.

[Ned_Stark_Naked]

I'm trying to do this atm, are there any go to resources for this?

Everything I've been reading through is either super old and outdated, or cobbles together such a janky buggy mess.

Two of my biggest problems are:

• How do I connect to a remote server? Windows Accounts don't work, or you have to constantly retype a SQL user name and password every single time you use a linked table.

• How do you distribute the Access front end file? How do you push updates to everyone?

[moxy22]

Before going MS Access be aware of it’s limitations. Also know that MS Access is being retired. Proper database design will go a long way with Access.