Recent content by MichaelBurston

Just an update on this for closure, and thanks for all your help! I had some of my analyst colleagues do testing on this DB. They didn't have the same issues that I did -- the DB worked totally fine for them. The variability in performance (i.e. it works better when the network folder is...

I can give that a try. The more I look into it, the less it seems like an issue with a persistent connection. When the DB opens, a list navigation form opens that allows you to open a popup subform for the record chosen in the navigation list. That navigation form stays open throughout the...

Thanks The_Doc_Man. I agree with the UNC thing; I'm sticking with UNC, as you point out, because there will be 7 users of the database, and they could potentially be mapping the same drive but to different letters (N:/ Z:/ etc.); so, the UNC is a safeguard against that, but doesn't really...

Hey Everyone, I deployed a split database, whereby several fact tables are stored in a backend database on a network drive, and there's a client database with the forms/vba/reports that is put on each user's desktop. The client connects to the backend through the normal linked table method, and...