No informaiton shown. Do I need to switch to sql?

[James]

Every once in a while my database's main form, the form that the user enters the information, will not show the four fields with calulations. If you restart the program the fields are displayed. It only happens every once in a while. I am only wanting to know if this is a problem with access or the way I have the calculated fields. The fields sum(a-b), basically, from another table by using all of the information with the same number as the main form.

How many records will access hold before I need to transfer the information to a sql server? How many linked records should be under a main record? I am wandering if there are to many record to sum, and if so how should I go about lowering the number of records attached to the main record

The main form is the customers information. The subform is a place where the employee from our company enters there user number and the number to subtract or add to the persons account

If you need more informaiton please let me know. Thanks

 

[John Vinson]

How many records will access hold before I need to transfer the information to a sql server?

The largest Access application I've heard of has 30 GBytes of
information in some 80 .mdb files, with some 4 million records in the
largest table. Another app has a 20,000,000 record table.

How many linked records should be under a main record?

There is no limit.

I am wandering if there are to many record to sum, and if so how should I go about lowering the number of records attached to the main record.

There is SOME OTHER problem with your database. It's not the size
that's causing this! It might be database corruption - have you
Compacted and Repaired the database?