Uh oh...
You use MS Access as a multi user DB? Have much trouble with
data loss? It's a cool program for single user DB's, but
I wouldn't trust it multiuser... Actually, it's possible
that if you only use ODBC to access it things will be okay,
but I've seen people share the MDB on a network drive and
have multiple people opening the file. This is a good
way to corrupt your database.
Cheers! | [reply] |
Note that I don't care for MS Access either (most of my work is done with Oracle on Unix), but we have a relatively medium (20-30MB, which is nothing compared to what we do under Oracle) Access database shared that 30-50 people routinely enter, update and pull reports from. I don't think we've ever had an issue with data corruption... Maybe we were using a more stable version of the software or something, or maybe network problems corrupted your database... strange.
| [reply] |
Wow... Groovey...
I've just checked the MS Knowledge base and you can have
data loss, silent design changes to orms, reports, macros,
modules, or commandbars, may be discarded without warning.
Check out article
Q237938
for more details.
But I have heard of other problems as well, although this
was a couple of years ago with Access 95 which have probably
been cleaned up by now. Or at least, I'd hope so!
| [reply] |