FORMS OPEN SLOWLY

[Hannu]

Hi.

I have in my database linked tables from other access database and i
have local tables. My form is linked into local table, but when i open
it, it seems to check every table in my database and it opens very
very slowly. Why does it do it? How can i prevent it checking every
single table in my database before opening? I am confused.

Hannu

[Allen Browne]

Re: FORMS OPEN SLOWLY

If the form is slow to open, work through the items in the Access
Performance FAQ at:

http://www.granite.ab.ca/access/performancefaq.htm

Particularly, the SubdatasheetNam e issue may cause it to refer to
unnecessary tables, and the Name AutoCorrect feature may cause it to jump
through unnecessary hoops.

The length of the path of the linked tables is also important: keep it less
than 128 characters.

Beyond that, is there any code in the Open or Load events of your form?
If the form is based on a query, does the query itself load fast?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Hannu" <hannu.lappalai nen@niiralankul ma.fi> wrote in message
news:e671227a.0 410062305.1fcd7 16c@posting.goo gle.com...[color=blue]
>
> I have in my database linked tables from other access database and i
> have local tables. My form is linked into local table, but when i open
> it, it seems to check every table in my database and it opens very
> very slowly. Why does it do it? How can i prevent it checking every
> single table in my database before opening? I am confused.
>
> Hannu[/color]