Helga Schulz
2008-05-19 18:21:53 UTC
Hello everybody,
I hope I don't ask things that are somewhere in the FAQ; if so,
please name me the link. In case you know some basic resources
and examples for creating views and procedures, please read on
and I would be very happy if you could name me some.
I created a database application with Access2003, which has
become bigger than expected now and doesn't perform completely
satisfyingly. It consists of about 70 tables which are connected
by n:m relations and a UI with many forms containing various
subforms. The main "brake" seems to be one form which has to show
pictures and many related tables (off course this is the one the
users need most of the time). Searches - there's plenty of
searching possibilities, realized with VBA-Strings - take rather
long, when it comes to this point. As long as the frontend runs
on one computer and the backend on an external harddrive, it
works sufficient, but in "real life", with the backend on a
Windows server connected by LAN, its performance is too slow.
Probably it would work better when the tables would be migrated
to SQL Server and the pounds of queries saved in the frontend and
created with VBA would be stored as views in SQL Server, so that
necessary network traffic would be less (I hope).
I don't want to work with projects (.adb) and SSMA (except for
the basic rough stuff), since moving the application to Access
2007 in future shouldn't cause much development cost and I want
the making of the views and transformation done once only.
I'm quite at the beginning to have a look at SQL Server and want
to start to try things out as soon as I have a copy of a SQL 2005
Developer edition, which will probably take some days. Meanwhile
I would like to read about connection, views and procedures. Can
you give me some links with examples?
Thanx in advance and greetings
Helga
I hope I don't ask things that are somewhere in the FAQ; if so,
please name me the link. In case you know some basic resources
and examples for creating views and procedures, please read on
and I would be very happy if you could name me some.
I created a database application with Access2003, which has
become bigger than expected now and doesn't perform completely
satisfyingly. It consists of about 70 tables which are connected
by n:m relations and a UI with many forms containing various
subforms. The main "brake" seems to be one form which has to show
pictures and many related tables (off course this is the one the
users need most of the time). Searches - there's plenty of
searching possibilities, realized with VBA-Strings - take rather
long, when it comes to this point. As long as the frontend runs
on one computer and the backend on an external harddrive, it
works sufficient, but in "real life", with the backend on a
Windows server connected by LAN, its performance is too slow.
Probably it would work better when the tables would be migrated
to SQL Server and the pounds of queries saved in the frontend and
created with VBA would be stored as views in SQL Server, so that
necessary network traffic would be less (I hope).
I don't want to work with projects (.adb) and SSMA (except for
the basic rough stuff), since moving the application to Access
2007 in future shouldn't cause much development cost and I want
the making of the views and transformation done once only.
I'm quite at the beginning to have a look at SQL Server and want
to start to try things out as soon as I have a copy of a SQL 2005
Developer edition, which will probably take some days. Meanwhile
I would like to read about connection, views and procedures. Can
you give me some links with examples?
Thanx in advance and greetings
Helga