Asking advice regarding Upsize

[roypython]

Hi.
Your help is very appreciated.
I want to upsize large MS ACCESS(2002) app to MS SQL SERVER 2000.
[ By "large", I mean 250 queries, 78 tables, 110 forms].
The app will be used by 25 concurrent users.(therefore the need to upsize).

I have time constraints of 2 weeks to deliver.

My questions:

1. In order to finish it asap, upsizing ONLY the tables - might be a good solution. However, will it work with a workload of 25 concurrent users?(read/write).

2. If upsizing all the tables, would it be possible to upsize SOME of the queries and leave the rest untouched?
If yes, what is the process to do it?
That will save me lots of QA time (there are 250 queries).
Mind you it's not simple, since the forms need to reference Stored Procs as well as ACCESS' SQL queries.

3. In the upsizing documentation, it says that there might be situation that the query will be upsized , no errors will appear in the log BUT it won't work anymore .
Do you have any methodology for QA the upszied queries in order to ensure the system's robustness?

Thanks a lot
Roy

 

[roypython]

Thanks for your quick reply Pat.
In the application, filtering is done on the queries, not on the forms, and the performance is poor.

I think that Hybrid solution might be good:
I mean:
1. Upsizing all the tables.
2. Create linked tables in ACCESS
3. Create Stored Procs only for the queries that are used by many concurrent users (regular users) and leave the queries that are not used by many concurrent users (admin users) as they are

Do you have any expirience in creating hybrid app?

 

[roypython]

The performance issue is only part of the problem.
The more significant part of the problem is number of concurrent users.
It supposed to support 20-25 concurrent users!!!

[currently after 10 concurrent users (r/w) the system dies (it hangs , or closes unexpectedly).]

Your solution doesn't address the issue of many concurrent users.

any thoughts?

 

[roypython]

Thanks a lot for the advices.
You helped me with a very valuable info.
I will upsize only the tables.
Performance issue can be addressed later through optimisation , with the process you suggested.