SQL SERVER vs MS ACCESS

Joao Figueiredo 0 Reputation points
2023-05-15T13:46:38.3033333+00:00

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.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
325 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Maria Barnes 11 Reputation points MVP
    2023-06-06T18:31:03.1333333+00:00

    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.

    0 comments No comments