Forms with data sources

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

Guest

Hello Newsgroup

I'm a new Access 2000 developer and I'm now looking at ADO to take more control of m
data manipulation

I was wondering if I can create a data-entry form that is not based on any data source and
do all of my processing (ie. lookup, update, edit, etc...) through the ADO

Are there any known issues with this approach ? Any suggestions or recommendation
are greatly appreciated

Thank you in advance.
 
Hi,


That is generally not done because you loose a lot of the functionalities
and power of a relational database in general and from Access itself (the
application, not Jet, the database). ADO is mainly an interface between you,
the developer, and your data storage, it rarely replaces the data storage
itself, even in its disconnected states, since you have to persist the data,
in case of a power failure, if not for other conditions. Furthermore, ADO is
built in the memory of your PC, and memory, by opposition to data on a file
medium, is not immediately SHARABLE between multiple users.

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top