I'm looking for a light-weight database engine I can use for multiple
users accessing the same database over a LAN (and I know that client/
server is recommended, but not an option for me). I want something
from Microsoft. I saw SSCE which looks great, but unlike JET Red it
doesn't appear to handle multiple workstations using a shared drive,
is this correct? I was thinking about JET Red, but I like the small
foot-print of SSCE and that I can include all files in my application
folder -- easy install, and no worry of version conflicts with other
apps. If SSCE won't allow multiple PCs to open the database file
(spf?), can anyone think of something else that would meet my needs
(again, must be from Microsoft -- I love MS).
Sorry for posting a desktop question in a mobile device group, but I
couldn't find any SSCE specific groups besides this one, and this
really is an SSCE question.
ErikEJ - 29 Nov 2007 08:51 GMT
This IS the proper newsgroup for any SSCE questions. For a discussion of why
SSCE does not allow multiple machine LAN access, see:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2476694&SiteID=1
Other than Jet, I can't think of any option (apart from SQL Server Express,
which is recommended).

Signature
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com
> I'm looking for a light-weight database engine I can use for multiple
> users accessing the same database over a LAN (and I know that client/
[quoted text clipped - 11 lines]
> couldn't find any SSCE specific groups besides this one, and this
> really is an SSCE question.
Ginny Caughey [MVP] - 29 Nov 2007 15:39 GMT
As Erik pointed out, SQL Express really is the recommended solution for
multi-user access, and yes it is a lot heavier weight to install than SSCE.
I'd recommend checking with the SQL Server or MSDE newsgroup for suggestions
on how to make this process easier for you and your clients.

Signature
Ginny Caughey
Device Application Development MVP
> I'm looking for a light-weight database engine I can use for multiple
> users accessing the same database over a LAN (and I know that client/
[quoted text clipped - 11 lines]
> couldn't find any SSCE specific groups besides this one, and this
> really is an SSCE question.