Hi,
We have an MS Access 2000 Database front-end to a SQL Server 2000 database. The database was initially developed in MS Access and then upsized to SQL Server 2000.
I am just wondering ....
When I do a query in the MS Access front-end, does the application return all of the data back to the MS Access front-end from the database each time to do the actual query.
I have noticed that the mde file grows until the MS Access front-end is closed and compacted each evening.
If all the data is returned each time from SQL Server and the manipulation done in MS Access - could there be a point when there is too much data in the database? i.e. Access won't be able to handle the manipulation at some stage and would start giving users error messages.
Any opinions on this would be greatly appreciated.
Thanks
We have an MS Access 2000 Database front-end to a SQL Server 2000 database. The database was initially developed in MS Access and then upsized to SQL Server 2000.
I am just wondering ....
When I do a query in the MS Access front-end, does the application return all of the data back to the MS Access front-end from the database each time to do the actual query.
I have noticed that the mde file grows until the MS Access front-end is closed and compacted each evening.
If all the data is returned each time from SQL Server and the manipulation done in MS Access - could there be a point when there is too much data in the database? i.e. Access won't be able to handle the manipulation at some stage and would start giving users error messages.
Any opinions on this would be greatly appreciated.
Thanks
