KingOrmon Posted May 11, 2022 Share Posted May 11, 2022 Hi I have a separate MS Access file for each user (when login) Example: User1: 0001.mdb User2: 0002.mdb User3: 0002.mdb I have these files separated in other system folder (not in unigui isapi folder) like C:\MyUserData\ All seems works an concurrent, any suggestion ? Any security problems ? Link to comment Share on other sites More sharing options...
rencarnacion Posted May 11, 2022 Share Posted May 11, 2022 Hi, I Suggest you to use a RDBMS because is more secure and fast and work faster than Access Database. Yo can check PostGreSQL, MySQL, MariaDB, FireBird and other free database, even Microsoft SQL Server Express is free too. Link to comment Share on other sites More sharing options...
KingOrmon Posted May 11, 2022 Author Share Posted May 11, 2022 Hi I would like to avoid use RDBMS for this project, Thank you Link to comment Share on other sites More sharing options...
Wilton Ergon Posted May 11, 2022 Share Posted May 11, 2022 problem only in relation to the limitations of the access itself.. if your system will store little data, with few users.. it works smoothly.. Link to comment Share on other sites More sharing options...
VojkoCendak Posted May 17, 2022 Share Posted May 17, 2022 Access is fast enough (can be lightning fast with oledb), stable and quite usable except for 2G size limit. Concurrency: works ok. The major difficulty for us is if you have several connections to access db, the changes made in one connection don't reflect immediately in other connections or apps. It could take couple of seconds. Anyway concurrency it's not deterministic (atomic operations) if you need that. It's even more stable then SQlite from our experiences. regards, Vojko Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now