Database Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm going to develop a single user program written in C# that will connect to
a database on the local machine only. I'm thinking about using Microsoft
Access for the database. My question is does each individual machine that I
deploy the program on need to have Micrsoft Access actually installed, or
will the program be able to access, read, write, and query without Access
installed. Or do I need some kind of driver? Thanks for the feedback.
 
You shouldn't need Access installed. Unless you are using something
Access-specific, then you can just ship the appropriate components. For
example, I wrote an app that used an Access 2000 db for storage and I rolled
MDAC 2.8 and JET 4.0 SP8 into the installer. Access wasn't installed but
everything worked as expected. In fact, I'm going off memory here, if XP is
up to date with the latest service pack and windows updates then you
*shouldn't* need anything on that platform.
 
MDAC and Jet drivers. All machines need access to the MDB file however, so
you'll need to put it on a shared network resource if it's a shared
database. Just FYI, you might consider using MSDE instead. It's much
better for shared database applications.
 
He is probably planning on shipping the MDB with it, as it is a standalone project.

Should work fine. It always has in the past. With consideration for JET and MDAC.
 
For standalones, MDBs are one way to go. I wouldn't recommend them for two
or more users; that's why I qualified my statement by saying it's much
better for "shared applications" (i.e., multiple concurrent users).
 
Good point. Unless you have a pretty firm foundation in Access and it's peculiar quirks I wouldn't go beyond 5 users
anyway. Once you understand the tricks and tweaks it does hold up pretty well for under 50 users. Not sure if the NG
is around where I learned most of the tricks but it still may be. However with other better solutions available why
fight it?
 
Back
Top