Thanks for letting us know you found a workaround. As a rule of thumb we always try to put the data in SQL Server (except in very specific situations), and use Acces as the front-end for users.
Wendell
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!