Backend/FrontEnd database question

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

Re: Backend/FrontEnd database question

Greetings,

A jack hammer is to a hand held hammer what Delphi is to Access. Delphi
is an enterprise level OOP platform like Java and .Net. It sounds like
you want to perform enterprise type operations against an Access
backend. You want to store procedures like you would in a Server based
DB. I would just write out the sql strings in the Delphi app and store
them directly in the app. Or if you want to modify the sql string after
the app has been developed, you could store the sql strings in a text
file or yes - you could store the sql strings in a memo field in a table
in an mdb.

One other suggestion, as long as you are using an object oriented
platform, if you can write VBA code and can also write OOP code, I would
use .Net -- much easier than delphi with the same OOP. The .Net
dataAdper object (ADO.Net) makes it easy to connect to anything that is
either Microsoft based or Server based. You would use the OleDB
dataAdapter to connect to an Access MDB.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

Re: Backend/FrontEnd database question

Tim Ricard wrote:

>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'm no expert on Delphi but I would think that you'd want to run your queries
directly against the BE MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/