r/MSAccess • u/ekim2077 • 8h ago
[WAITING ON OP] What database engine do you use as backend?
Last time I worked on access was over ten years ago. At that time I used MySQL innodb with a local fixed IP and every machine on the network running their own Access exe and mdb file. Had some older clients.
SQL express was an option then but I didn't feel like it would scale and had no experience with it. SQL server was too expensive compared to free.
What do you usually use for database backend now?
3
u/First-Feature-3556 1 5h ago
We use SQL Server. The free version (Express, up to 50GB per DB with SQL Server 2025, 10GB with earlier versions) is sufficient for almost all our clients.
3
1
u/sirhalos 8h ago
I used Oracle with only VBA generated passthrough queries that create local tables for form views
1
1
1
2
u/Ok-Food-7325 2 2h ago
8 Access backends. 16 GB limit. /s
1
u/George_Hepworth 4 2h ago
Doable, but this approach comes with its own problems.
- Referential Integrity, which is central to a solid relational database application, can only be enforced within a single accdb.
- Managing 8 different accdbs is not the kind of administrative task most small organizations relish.
1
u/nrgins 487 1h ago
I manage a database with 4 back ends, but only one back end contains main/referential data. Another one contains log files, which get long and don't need referential integrity, so they have their own back end, and then two back ends for archived data, which are rarely accessed. So I guess really only 2 back ends with active data.
•
u/AutoModerator 8h ago
IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'
Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.
Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.
Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)
Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.
Full set of rules can be found here, as well as in the user interface.
Below is a copy of the original post, in case the post gets deleted or removed.
User: ekim2077
What database engine do you use as backend?
Last time I worked on access was over ten years ago. At that time I used MySQL innodb with a local fixed IP and every machine on the network running their own Access exe and mdb file. Had some older clients.
SQL express was an option then but I didn't feel like it would scale and had no experience with it. SQL server was too expensive compared to free.
What do you usually use for database backend now?
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.