Hi ,

I have been trying to get my head around a database issue for an application
that I am planning. The biggest problem I am faced with is a lack of clear
information and knowledge of certain issues. The scenario is this:
I have a primary accounting application that runs msde, certain tables in
msde holds vital data that I need to access for the application that I am
planning. I can simply open an ODBC connection to msde and link tables via
ODBC. My concern is that this method is sluggish and performance will be
hampered when I distribute the application over the network. There will be
about 7 heavy uses of the app that I am planning and about 5 light users. I
expect about 5 concurrent sessions at any time. The data that will be
provided by msde will not be amended in any way for the most part, but it
will be contorted in various ways through queries etc so that the data is
presented logically and pragmatically to my end users in my app.
Is using a jet database the best approach here? I am familiar with jet and I
especially like the tight integration of jet with access. I would prefer to
use this approach, provided that it does not leave me with users tapping on
the desk and giving me glares because of the lack of performance.

Is it possible to connect to msde using ADO , and then writing to a jet back
end? Will this be faster than simply linking tables via ODBC? Is it possible
to have a mixed approach like this?

Any help here would be greatly appreciated. Please feel free to knock me
over the head if I have not made myself clear, I will try and answer any
queries.

Regards

Andy