Re: Single user PC database might be OK
Step 1: Excel
Step 2: Discover existence of VBS, ODBC and PostgreSQL
Step 3: Read a book on VBS (cost: 1 day) write a VBS script that reads Excel data and spits out an SQL file you just have to run in psql to create and populate tables (cost: 1 day)
Step 3: hook up excel to PostgreSQL via ODBC (cost: 30 to 35 seconds)
Step 4: schedule a script that retrieves latest data from production database to update data in PostgreSQL. (cost: 1/2 day - we are talking production db, so extensive testing is required)
Access is pretty good with forms, as a database, though, it is utter crap.
I did this for a customer some years ago before powershell was available, today I would probably do it in powershell. Solution is still running to this day ... and I knew VBS/PostgreSQL/ODBC already before I started on the project. Did that as an ad hoc project, since project manager had overestimated implementation time of the actual project I was hired-in for - I simply asked, since we are done with this, what else is causing pain around here? The answer was a massive Excel file with data out of SAP ...