Re: Access 2003
As an intermediate step, try moving the data tables to SQL Server and creating Linked Tables in the Access database. This way the queries, VBA etc in the Access file will still work, but it will stop expanding in size when you add records. You can then gradually move the logic to SQL Server views/procs as you learn about it.
|