I have a database in SQL server with multiple tables and 1 VERY large table with over 1 million records. When I try to run a query in Access it gives me a time out error. This only happens with this table. All the rest of them can open fine.
A couple weeks ago I added some indexes to the table and it was working but now it's back to its old self.
The person who created the table set all the data types to float. If I were to change these by created a new table and importing the old records do you think that this would solve my problem?
Thanks,
A couple weeks ago I added some indexes to the table and it was working but now it's back to its old self.
The person who created the table set all the data types to float. If I were to change these by created a new table and importing the old records do you think that this would solve my problem?
Thanks,