Hi again.
I have a really big database. There are about 20 tables that are combined in a query to make one table. I use this query as a datasource in a form so their are well over 255 fields in the form all seperated by tabs. in the form there are also subforms. the database work fine. the only issue i have is that it is slow. I read somewhere on the internet that there is a piece of VB code that will set the database to read from a different memory source so that it will perform faster.
I'v been looking for this piece of code but haven't had any luck.
If you could help me with this I would really appreciate it.
thanks
trevor
I have a really big database. There are about 20 tables that are combined in a query to make one table. I use this query as a datasource in a form so their are well over 255 fields in the form all seperated by tabs. in the form there are also subforms. the database work fine. the only issue i have is that it is slow. I read somewhere on the internet that there is a piece of VB code that will set the database to read from a different memory source so that it will perform faster.
I'v been looking for this piece of code but haven't had any luck.
If you could help me with this I would really appreciate it.
thanks
trevor