Good afternoon everyone,
I have created a very robust front end for my backend database that is
essentially an all-round office database used for nearly all non-
accounting transactions. I have decided to keep my front end database
as it is and start creating smaller, single-task specific applications
in Borland Delphi (using ADO). Now, to create these Delphi front ends,
I need to utilize many of the MS Access front end queries that I have
created (INSERT, UPDATE and SELECT queries). How does it make the most
sense to get these stored queries: Should I create another .mdb front
end that just holds the required queries that I will use in my Delphi
program, should I migrate these queries to the back end or should I
just make my connection directly to the database front end? I don't
know much about the inner workings of ADO so I am at a bit of a loss
as to which one will be the most efficient and which way is the most
common format for accomplishing this type of task.
Tim