Re: Queries VS VBA Design

Tech-Archive recommends: Fix windows errors by optimizing your registry



"David W. Fenton" wrote:

=?Utf-8?B?U2NvdHQgQnVya2U=?= <ScottBurke@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in news:F3856B13-4375-4B8C-8E29-EAB5E18ED268@xxxxxxxxxxxxx:

I develeoped a system here where there are 73 backends and 30
front ends. I use both VBA and Queries. It has been running
extreamly well for 9 years now.
Its all in the design.

You are insane.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/


It was fun and I learned a lot.
I will NOT do that again!

I hear that SQL is eayier.
Scott Burke
.

Relevant Pages

  • Re: Queries VS VBA Design
    ... I use both VBA and Queries. ... Its all in the design. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Open source alternative for MsAccess?
    ... These are not RAD database application development systems that can ... The design reflects the purpose of the product. ... VB is not VBA and VBA is not VBA as used in Access. ...
    (comp.os.linux.development.apps)
  • RE: "Module" option does not show up when setting permissions.
    ... It's by design. ... Access 2000 introduced the separate VBA ... Project for handling the code (notice the separate code window (VB Editor) ... an MDE database file out of it if you want to hide the source code from ...
    (microsoft.public.access.security)
  • Re: Inserting data from 2 tables into 1
    ... been busy with Access and VBA for about 6 ... I would make all the queries and then use a set of macros to ... > Do you perhaps mean look for duplicates in tbResultsTemp? ... > The first is easier and lets you use all the nice interfaces like query ...
    (microsoft.public.access.modulesdaovba)
  • Re: Relational database & OO
    ... all the business systems I've participated coding or designing spent little production time changing data. ... In the online systems I'm familiar with, update and change transactions were preceded and followed with queries. ... suppose one has a single factory object to instantiate objects of each class and each factory has a unique query it uses to acquire the initialization data from the DB. ... I guess the point was relational DBs have at least relational calculus behind them, and we can always ask a design a) is all the necessary data saved and b) are all the relationships represented? ...
    (comp.object)