Hi All - first post...
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.
Director Arts Alive and Flicks in the Sticks.