Re: database method?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Butler (tiredofit_at_nospam.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 06:45:16 -0800

"Dylan" <anonymous@discussions.microsoft.com> wrote in message
news:2E6B3312-27DB-46BA-BF83-C2263948ACCF@microsoft.com
> I'm writing a stand-alone application to connect to a database
> created with Access 97.
>
> The application is going to need to do the usual actions such as
> view, edit, add, delete and search. I'm going to want this
> application to run on a system that does not have Access installed
> (is this possible?).

Yes; you will need the Jet engine installed but the user does not need
Access to work with the MDB from VB.

> The mdb file will reside on the system that the
> app is running.

Good; MDB files over a network are *slow*

> What is the best database access method to use OBDC, DAO, RDO,
> OBDCDirect, OLE DB, ADO?

If it will *always* be and MDB then DAO is the best choice for performance;
if it is potentially going to migrate to SQL or Oracle or anything else then
ADO would be more flexible.

> Let's say that in the future I decide to set up a central database to
> which client software can connect, what will be the best access
> method then?

Move it to MSDE or SQL or some other real client/server database engine and
use ADO. If it *must* stay as an MDB then I'd look at creating an ActiveX
EXE or some other server process that runs on the system hosting the MDB and
make your calls through that. Jet is a poor choice for client/server
operations.

Whatever you do, wrap all your database access methods into a class that
handles all operations including formatting dates properly in queries so
that if you do need to change from DAO to ADO or whatever you can just
rewrite that one class and, at least for the most part, leave the rest of
your app alone. 

-- 
Reply to the group so all can participate
VB.Net... just say "No"

Relevant Pages

  • Re: Suggestoins for Local DB to use with Shareware
    ... It was with D3 - I was using the BDE at the time. ... As for my own experience I begin to evalute ADO with Access ... MDB files in D4 just before D5 appeared with built in ADO support what has ... local database engines and I will continue to use it in the future. ...
    (borland.public.delphi.non-technical)
  • Re: Use ADO in Access 2000?
    ... What permissions do you have on the folder in which the MDB exists? ... And why are you trying to avoid DAO? ... > I want to connect to the database and append to a table using ADO. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Making mdb read-only after appending tables
    ... Temp objects are deleted when the database is ... But VB programmers were confused by the name of the ... There may be a way to set this property using ADO. ... The mdb has to be deleted after processing is finished. ...
    (microsoft.public.access.security)
  • Re: DLookup function
    ... > linked) or saved query in your current database. ... >> I have an MDB with my tables and then a seperate MDB with the forms, ... I am using ADO for my database connections etc. ...
    (microsoft.public.access.gettingstarted)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)