Access Replacement

Thank you everyone, yes I do exported data from Netsuite into Access and created reports. I also exported data from Quality Management System (QMS) called QT9, then scrubbed the data so that I could import into this high end QMS called Master Control . This 6 figure per year lease was horrible, couldn’t search the data and the analytics they demo’d hadn’t been released. The Access Database I created way out performed this system. That motivated me to redevelop the QMS database I created in 1995, that was in Foxpro. I will be looking for contract help with this new system I am developing with Access and Power Apps.

we imported data from an Oracle database and summarized it in Access, then pushed it back out into Excel for reporting.

That's true.

I used to download data from

SAP and data clean in Access,then generate Excel report -:)

There is probably a subset of "users" who use Access as a data-cleansing and migration tool in some part of their job.

For example, in one corporate job I had, we imported data from an Oracle database and summarized it in Access, then pushed it back out into Excel for reporting. However, that's the rare situation, not a common one. It happens, sure.

Would that justify replacing Access' ACE tables with something like SQLite? Quite the opposite, it worked for us precisely because the Access interface and tools made it possible, not because of the ACE tables.

re:such as forms, reports,

sure,I agree with you and GroverParkGeorge at this point.

You are exactly right.

On the other hand.

Quite a lot of access users just run sql statement without forms and reports as far as I know.

Now sqlite studio or other clients (e.g, Ms Access too a good cleint with link table to sqlite) which can run sql to acheive result table.

Say again,I just provide an option as brain storm rather than others.

so far,sqlite support window function really amazing and not limit to 2 g capacity.

Access is unique in that one package contains all of the tools needed to

1. create an interface with forms and reports
2. implement logic with VBA and macros
3. manage data in tables and with queries

All in one single magnificent application.

SQLLite is a database tool. In other words, it qualifies under point 3.

SQL Server, Oracle, et al are also able to provide tools for the 3rd point, and to a greater or lesser extent, the second.

Nothing replaces Access on the desktop successfully.

BTW: This blog post was published just this morning. How to Counter Rumors of Access' Demise.