SQL SERVER vs MS ACCESS

Question

Hi there!

I have several databases where the user places new files in folders and clicks buttons (VBA), and Access automatically adds new information and updates the older one. I would like to do the same now that I'm considering upgrading to SQL Server. For example, the frontend can still be Access (or another more modern solution), and it can perform the file upgrades and updates in the background. Is it done through triggers? Or is there any script in Visual Basic that can do this? I apologize for my English, I'm new to this. Thank you.

Answer 1

If Access is still your front end then you can keep using VBA and buttons. The only difference is when previously you were updating information in Access tables, you will be updating information in SQL tables. There are a couple of ways to connect to SQL. One of the simplest is through linked tables into Access. Your interface may not need to change, just the old tables replaced by the new links.