Jump to content

Using MS Access file as database for each user


KingOrmon

Recommended Posts

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

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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...