Form won't run in Access 2010 with many linked tables in the database.

[Vivian Ruggles]

It appears the form won't run when I have "too many" linked tables. When I make some of them static and some linked, it runs. I am stumped because there are only <20 linked tables from two 2003 Access databases when it doesn't run. When there are only 7 or so linked, it runs. Is there a limit to the number of linked tables?

[Xipooo]

There is no limit to linked tables.

What type of error messages are you getting? What kind of database is your backend data on (MSSQL, MySQL, Oracle, Access, etc..)?

[Vivian Ruggles]

Thanks for that info. I went back and relinked table by table. Each time I linked a table the amount of time it took for the form to open was longer, but it did open. So, apparently my issue is with time loading the tables because they are linked.

[Xipooo]

Then I would perhaps reconsider the strategy of loading so many tables each time a form opens.

Why do you have so many tables being opened by one form? Are you using tabs, or multiple subforms?

[ItsMe]

My experience with linked tables over a network is slower performance. I would say only create queries that retrieve the necessary fields but, it sounds like just the act of linking is creating an issue.

Maybe you can link using UNC and instead of using the server name use the server's IP. \\192.168.1.110\Folder\DB.accdb
Also, maybe not have your DB file 20 levels deep from the root.