Forms take to long to open

M

Marco

Hi. I've been notest the my forms take a while to open. Most of them as only
a small table in control cource.

why this is happen?

I'm creating a form from the beggining and I check the is very fast
comparing with the existing one.

sometimes I copy forms, clean the code and start from there.

Is wrong to copy forms? or when a form is too much used starts to be show?

Regards,
Marco
 
L

Linq Adams via AccessMonster.com

I assume when you say "Most of them as only a small table in control cource"
you actually mean Record Source, since form's don't have Control Sources.
Oddly enough, only Controls have Control Sources!

With so little information to go on, anyone offering advice here will only be
guessing. Perhaps you could give us a little more information:

What version/service pack of Access are you running?

Is this a single user database or is it a multi-user db that has it been
split into front end/back ends?

If Single user, where does it reside, on a PC's hard drive or on a
network/server?

If a multi-user db, where do the front ends and where does the back end
reside?

Do you have multiple combobxes on your forms?

Do you have subforms on your forms?

The more data you give us the better we can help you resolve this matter.
 
L

Linq Adams via AccessMonster.com

Forgot to add, there should be no problem with copying forms and redoing them,
if by that you mean copying them for interface design and then assing
different Record Sources, etc.

A form being used multiple times shouldn't slow things done, but obviously a
huge increase in the underlying data might, especially if you're connecting
the table to the form by way of a query that does a lot of data manipulation.
 
M

Marco

Hello.

I'm sorry for the little information.

I have in a server a back-end database to share the data and several users
with front-end (all front-end are equal)

The back end is in a server and in the clients are running XP/Windows 2003
server and Vista.

Access front-end and back-end are in access 2003.

The strange thing is that I have a form that takes a while to open and the
"record source" is only a table with a few record and a few fields, no big
deal.

The strange thing is that now I create a new form with the same Record
source and is very fast and the other, the old form is very slow.


PS: I'm very bad with words, probably also with code words :)
 
Top