|
| Hi Jon,
Speed of the computer will just mean things will go slower until you
start reaching timeouts.
What are you using on the front-end for reporting if you are using
access type reports they will function as normal, just import them over
to the ADP project, you can use the same type of system as access in
linking the direct tables to reports, but for performance reasons move
your data processing off the workstations and onto the server.
Personally I don't use SQL views as I always opt for stored procedures
as they give me more functionality in the long run.
To get you started, get your data over to SQL then create an ADP
project linking to that SQL server database, then import your
forms,reports and modules into the new ADP from you old MDB, just to
see how it works. It is a good move to learn something about how to use
SQL in relation to stored procedures and triggers up front as to learn
these afterwards could mean undoing a lot of work.
Just to give you some advice tiggers are the system that keep your
business rules running on SQL, e.g. update the contacts table, write an
audit log in another table, easy business for SQL etc. MOVE YOUR
PROCESSING TO THE SERVER.
Hope that helps a bit, for references http://msdn.microsoft.com for
documentation on stored procedures and triggers.
Regards
Alex
|
|