Split Form Slows Database

[buienxg]

I have Split form with a searchbox on it. I can filter the records based on what is typed in the searchbox. However this is a multi user database. When someone has open that form and it is filtered, everyone else using the database comes to a slow crawl. Most of my forms are unbound, however I don't know how to create a datasheet with thousands of records unbound so that it doesn't slow down the database. When someone is viewing entire tables. No changes are made on this form.



Any links or arrows or examples would be greatly appreciated. I am not looking for someone to do it for me, just a place to start looking.

Thanks in advance,

[June7]

Is this a split (frontend/backend) database?

You say most forms are UNbound?

[Toyman]

I have Split form with a searchbox on it. I can filter the records based on what is typed in the searchbox. However this is a multi user database. When someone has open that form and it is filtered, everyone else using the database comes to a slow crawl. Most of my forms are unbound, however I don't know how to create a datasheet with thousands of records unbound so that it doesn't slow down the database. When someone is viewing entire tables. No changes are made on this form.

Any links or arrows or examples would be greatly appreciated. I am not looking for someone to do it for me, just a place to start looking.

Thanks in advance,

When someone is logged on to the db from the frontend, is the lock file (.ldb) to the backend displayed in the folder where the backend resides?