Form Problem???

[becbec]

The shared folder is on another computer. When I open a particular form in a database from the shared folder the form seems to load fine, but when I access a particular record in the table through a combo box there is a long pause and at the bottom left hand corner of the screen a message comes up stating "running query". With 60,000 records this takes a long time.
Now when I access other tables through forms setup with the same type combo box there is no problem..... the form loads... I key in the info in the combo box and it finds the record immediately. (This is a table with 92,000 records in it.)
I have accessed the same folder from other machines, and then accessed the same table through the same form and there is no problem..... the form loads.... I key in the info.... and the record pops up.
It is a "peer to peer" network. I have changed the folder, checked my indexes, rechecked my form, rechecked my permissions, etc,etc.
Another thing I have noticed..... when I close the database, the .ldb file will not release. That's a question also.
It seems to be only on this one unit.

I will appreciate any suggestions.

Thanks!

Ed Bartholet
bec@lcc.net

s

 

[EstuardoSierra]

becbec:
Repair->compact yor db. If this does not solve your problem your db may be corrupeted. If so you have not a lot of options, but you can:
1. Look for a third party tool to repair your db
2. build another db and import the objects.

I guess it should solve. If doesn't the problem maight be in the MS Office suite, or in the system.
To check that, copy that db-problem to other machine and see how it behavies. So you will find out what is wrong.

Good luck

Estuardo