Den 2011-05-30 21:39 skrev heineferreira såhär:

> The most common way to do database development with Access is via dao or
> ado. ADO is usually recommended for client/server development but you
> can use DAO although it is a bit slower. If you want to use bound forms
> and reports then you should use either of these 2 libraries.
> The easiest way to program Firebird via Access is via odbc linked tables
> and you can use either of these 2 libraries. Do you know if it's
> possible to use the MGA with ADO or DAO? Both of these libraries are
> heavily dependant on locking. I think I can bypass the locking in a read
> only environment with passthru queries and by adding a "no lock" into
> the select statement. I don't know what to do with insert, update and
> delete statements however. Do you know of a way to achieve this?
> I know there are commercial ado providers out there but that requires
> purchasing a licence for every user and I don't even know if they
> support that functionality. I remember vaguely that Firebird 1.0 had a
> gds.dll library but I don't know if that's still used.

Is it a requirement to work in Access and access FB data from there?

What is your development environment and platform? Windows? Linux? Mac?
Java? .Net? Win32?

What kind of app are you working on? Number of users? Any BLOBs? Number
of concurrent users? Database size (number of tables and number of
records in the largest tables)?

You can choose between several different component sets and so forth
depending on the answers to those questions.

Your discussion about "locking" seems to suggest you don't really know
how "real" databases work (as opposed to simple local file DB:s like
Access and paradox). But you said you come from a SQL Server background,
so... what are you after here? FB has transactions and readers never
block readers due to MGA and I even think readers never block writers
(excepting DML, e.g. dropping or altering tables). Writers may block
other writers, but the locks are very fine grained: record by record, so
they only block each other if they really compete for update on the same
record.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64