Using Access and Sharepoint online

[baldybouncer]

I am hoping someone can help me. I have a split db with about 3300 records.
I moved it to sharepoint that is part of BPOS since then if someone uses the
database locally it is slow as death. it takes about 50 secs just to carry
out a simple search. Does anyone know if there is some sort of limit on the
number of records? Or if there is a solution to this problem. Thanks

 

[Klatuu]

Moving to Sharepoint will not speed it up, it will slow it down because
Sharepoint Lists don't have the indexing power of Access.

3300 records is a very small set of data. There are no limits on the number
of records, but using the Jet or Ace database engine, the mdb or accdb size
limit is 2 GB.

You slow response can be cause by a number of issues:
Searching on non indexed fields.
Searching on compound indexed fields where the index has multiple data types.
A slow network.
The back end is in a folder that is several levels away from the root.