Database in small network

[JackOfAllTech]

I am planning a rewrite of an old app that was in VB6. The original
app used a Jet Database Engine file(*.mdb) and different code
depending on whether it was at a location with a small peer-to-peer
network with no server or a location with only one PC. The new version
will use an XML configuration file to determine the location
information so I'll only have one codebase. What I am debating about
is the database system to use for it. For small offices am I better
off sticking to mdb files or running SQL server express on the system
hosting the data? Does it really matter which I use?

 

[dotNetDave]

I would never use Access for multi-user database programs. I would suggest
SQL Server Express.

David


======================================
David McCarter [Microsoft MVP]
www.dotNetTips.com
David McCarter''s .NET Coding Standards available at:
http://codingstandards.notlong.com