Very Computer

1. Converting Access forms to VB forms

Questions about Visual Basic forms versus MS Access forms

We have developed an application in MS Access 2.0 with about
50+ forms and 70+ tables.  Some of our users are complaining
now about performance.  They are using this product during meetings
and they want to be able to jump around from form to form very
quickly in a 5,000+ record database.

One solution we looked at was to load up a bunch of forms at
once, and then navigate around the database, leaving the forms
open.   The problem with this is Windows only allows 8-9 forms
to be opened at once, and then you get memory/resource utilization
problems and the damn thing croaks.

So we are wondering about replacing our MS Access forms with
a Visual Basic front end that would use our MS Access database
but (hopefully) present the data on the screen a lot faster.

Here's my questions:
1) Compared to MS Access forms, are Visual Basic forms faster to
load and/or faster to populate with data?  How much faster on a
large database?
2) Does Visual Basic use as much system resources as MS Access (and,
therefore, will I still be restricted to only opening 8-9 forms
at one time?)
3) What kind of effort can I expect for re-writing MS Access
forms in Visual Basic?  e.g. how many hours/days/weeks per form
to convert from Access to Visual Basic?
4) Are there any other hints or gotchas I should be concerned about?

Thanks in advance for your help

Rich Haerr
HRSoft, Inc.

2. How to move jobs to the other server

3. Convert from Access forms to VB forms.

4. Speeding up Query

5. Converting MS Access forms to VB forms

6. Query not Working. Need Help!

7. Convert an Microsoft Access Form to a VB Form

8. Performing a find with an "or" statement

9. converting access forms to vb5 forms

10. Converting Access forms to Visual Basic forms

11. Converting Access Form to VB

12. How to convert Access forms to VB#3

13. Turning Access forms into VB forms--HELP!!