database question

[Guest]

If I have a database in Access and am writing a .net program but I want to
use link to that Access database, question: when it is installed on other
PC's do they have to have Access loaded in order for my program to run

 

[Lynn Trapp]

My understand is that, if you simply want to link to the tables in a .mdb
file, the users would not need to have an Access license. Others may be able
to give better information on that.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

I was wanting to know if it would work at all, some of co-workers said it
wouldn't work if Access was not loaded. Thanks,

 

[aaron.kempf]

MDB is a disease use MSDE

 

[Lynn Trapp]

You're welcome. Just to clarify, if you want to open the .mdb file using
Access, then you need to have some version of Access installed. However,
the Jet database that is stored in a .mdb file may be put on any computer
and linked to from another application without a license.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[George Nicholson]

I can't speak to .net, but vb 6 can build apps that connect to .mdb (Jet
database files) *data and queries*. These apps do not require Access.

Reports (and forms, but why would you want to..?) in that .mdb file would
require Access, so you have to roll-your-own reports in VB.

Lots of programs can read & write data to .mdb files (for instance, Excel)
and they don't require Access for that to happen. You do need an Access
license if you want to use Access Forms, Reports, etc.

HTH,