Front end / Backend

[SteveE]

I have now finished my database and have split the tables etc, converted the front to an MDE file.

When connected everything is fine for all the users. My question is about the logging on time it take to connect to the backend. It seems to take ages but in reality probabaly about a minute. The size of the front end is approx 2.5 meg and the back approx 4 meg. Is there somway I can speed up the connection?.

It is not the network, as if I split it on my own hard drive the time is almost the same. Is this something you just have to live with or am I missing something?

Steve

 

[Vassago]

I don't have that problem across my network at all. I use front-end/back-end databases for a lot of mine.

 

[SteveE]

I think I may have found my problem, the main form I open has a lot of fields from one table and a couple of releated feilds from another. Each field is specified with a select statement and then a join for the other table and select again for each field. I think it is this that slows down the opening, as I have removed the couple of fields and just used the source at the main table which now seems to work ok. I do miss not having the other fields though.

Steve