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.

--
Tim Wilson
..Net Compact Framework MVP

"JRB" <(E-Mail Removed)> wrote in message
news:B35105DC-D3E4-405D-9F0F-(E-Mail Removed)...
> 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.
>

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.

"JRB" <(E-Mail Removed)> wrote in message
news:B35105DC-D3E4-405D-9F0F-(E-Mail Removed)...
> 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.
>

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.

--
....Carl Frisk
Anger is a brief madness.
- Horace, 20 B.C.
http://www.carlfrisk.com


"Michael C#" <(E-Mail Removed)> wrote in message news:k10%d.9700$(E-Mail Removed)...
> 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.
>
> "JRB" <(E-Mail Removed)> wrote in message
> news:B35105DC-D3E4-405D-9F0F-(E-Mail Removed)...
>> 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.
>>
>
>

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).

"Carl Frisk" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>
> --
> ...Carl Frisk
> Anger is a brief madness.
> - Horace, 20 B.C.
> http://www.carlfrisk.com
>
>
> "Michael C#" <(E-Mail Removed)> wrote in message
> news:k10%d.9700$(E-Mail Removed)...
>> 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.
>>
>> "JRB" <(E-Mail Removed)> wrote in message
>> news:B35105DC-D3E4-405D-9F0F-(E-Mail Removed)...
>>> 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.
>>>
>>

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?

--
....Carl Frisk
Anger is a brief madness.
- Horace, 20 B.C.
http://www.carlfrisk.com


"Michael C#" <(E-Mail Removed)> wrote in message news07%d.11145$(E-Mail Removed)...
> 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).
>
> "Carl Frisk" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
>> 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.
>>
>> --
>> ...Carl Frisk
>> Anger is a brief madness.
>> - Horace, 20 B.C.
>> http://www.carlfrisk.com
>>
>>
>> "Michael C#" <(E-Mail Removed)> wrote in message news:k10%d.9700$(E-Mail Removed)...
>>> 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.
>>>
>>> "JRB" <(E-Mail Removed)> wrote in message news:B35105DC-D3E4-405D-9F0F-(E-Mail Removed)...
>>>> 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.
>>>>
>>>
>