Quote:
Originally Posted by haydnwalker
MS Access is the bain of any database admins life  No good imho for anything other than creating an address book 
|
I used to use Access databases in some of my WinForms projects, but ONLY for applications that are single user and for non-critical back-end data storage only. But even this is a bind, as there's no 64-bit engine to access the MDB, so I have to force compile to 32-bit.
I've since started looking into the SQL-Lite provider for Visual Studio so I can use SQL Server databases without the server (I know SQL Server Express can be installed locally, but that's too much to ask of users for small applications IMO).
I know of a big company that had their entire employee training records database in an Access database. But, as if that wasn't bad enough, it was shared on a network so everybody could open it in Access and view/edit/delete any information in there!