Unanswered: Re: adp file size reduced drastically when Access 2000 FE base on SQL Serve 2000 is c
I need to know why did my adp file size reduced drastically when I created Access 2000 FE base on SQL Server 2000 BE? I have an adp file using SQL Server 7.0 and is 16590 KB but the Access 2000 w/ SQL Server 2000 has only 3505 KB. These adp files are both using the same database. The same database is copied from SQL Server 7.0 to SQL Server and I'm just recreating the FE for SQL Server 2000 BE.