The best way to go is to break out a large SQL server table into smaller Access databases based off values in the SQL server table.

I can understand that...however, there is a push and pull involved.

The Access databases are pushed to a shared folder and then the user's pull them from that folder.

In all seriousness...

I'll definitely keep that in mind and try to pursue that avenue.

But if it did have to be Access, how would you go about doing it?

Therein lies the problem, Access is standard on the profiles of my users. SQL express is not. I have to operate within the existing framework of my users' computers. Otherwise...

It would require the software to be installed on the user's computer correct?

Hi Jeffrey,

Thank you for the suggestion, unfortunately at this time it is not an option.

Think of it as an exercise...

How to break a table up into smaller tables in Access...

I could give it a try in SSIS if you have an idea. I have not used it at all, but I am willing to try anything at this point...

Thank you for your response, those are great questions.

The simple answer is because I need the information downloaded to the Manager's laptops in the mornings. They go on the road...