What alternatives are there for not using SQL express in VB app with a small database?

I have a VB 2005 app that utilizes a small database. I don't want to use SQL Express, because I do not want to have to distribute it for such a small database. What options are available?

Thanks,
FDT
Mr_FulanoAsked:
Who is Participating?
 
DhaestConnect With a Mentor Commented:
If you don't mind security, performance, ... there are a few options
1. Use a access-database as background
2. Use xml-files as a database
3. Put everyting into flat-files
0
 
adriankohwsConnect With a Mentor Commented:
Use Access 2003 Database will do. Setup is easy since there's no need for database installation, just compile your application with the Access Database File.
0
 
grayeCommented:
Or another approach...   you can use SQL CE (compact edition).   (The name of this product has changed so many times, it makes your head spin... SQL Everywhere, SQL Mobile Edition, etc)

It doesn't require that you install any run-time parts on the client PC (other than a DLL that gets deployed with your application).

http://www.microsoft.com/sql/editions/sqlmobile/sqlmobileresources.mspx
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Mr_FulanoAuthor Commented:
Hi Graye,

I guess the logical question would be, what's the major difference between SQL CE (compact edition) and the regular SQL Express version? In other words, what can't I do with the "compact edition" that I can with the "express edition".

FDT
0
 
Mr_FulanoAuthor Commented:
Hi Dhaest and Adriankohws,

XML and flat files are not an option.  However, Access 2003 is an option I can try. Why do you say "If you don't mind security"... is Access 2003 not a secure option.  -- I wouldn't want the data to be accessed without my application via the Access application itself, so couldn't I use passwords to protect my data from curious eyes?  

Also, is there an any major downside to using Access 2003 vs SQL Express?

Thanks,
FDT
0
 
DhaestCommented:
For a comparison between access 2003 and sql express, see the following article
SQL Server Express vs. Access for small-business applications
http://resources.zdnet.co.uk/articles/features/0,1000002000,39285074,00.htm

SQL Server Express 2005 vs. JET
http://www.sqlmag.com/Articles/ArticleID/49623/49623.html?Ad=1
0
 
adriankohwsCommented:
Mr. Dhaest mentioned about security. Yes, of course it's not as secured as SQL Express. But if you are talking about stopping a normal layman from accessing, yes, you can input a password with Access 2003. Maybe what Mr. Dhaest was talking about is like "auditing", you can't create database users and know who logged on and what they did whereas SQL Express can achieved.

As compared: generally, you can say Access 2003 must not exceed 2GB of data and even 500MB database in Access will be very slow in performance depending how to retrieve information whereas SQL Express can hold up to 4GB and no performance issue. Generally, without data size issue, SQL Express is also much faster than Access 2003.
0
All Courses

From novice to tech pro — start learning today.