Background - we are a charity organising 1200 events a year - for the past 20 years, and our Access front end holds much of the data for all these events linked to an SQL server
Last year we moved our SQL sever from the office into the cloud, and since then the performance of my forms and queries have been rubbish! probably due to my poor programming and sql skills. But more on that another time - this question is more basic.
I have one table for instance, it has about 100 fields and 13000 records.
If I try to open that table in access - it literally take 4-5 minutes or more to show up.
I just get 'calculating' in the bottom left corner.
Would that be normal kind of speed for that amount of data? I have good broadband speed. The table has a Primary Key.
Are all 100 columns huge (i.e. varchar(max))? Can you provide the table structure and some sample data? When you say open the table, are you performing a select * from the table and selecting all the rows? what happens if you select top (100) * from the table or Select top (100) Col1, Col2, etcc. from the table and limit the number of columns? It should not take 4-5 minutes, but i've seen some log tables developed by .Net developers that are all varchar(max) columns and is dog-slow. Sounds like an opportunity for a redesign
