I am going to try using a DSN as I am not getting anywhere.  I'll let you know how/if it works.  Thanks for your input.

When I go into Access I get prompted for the password.  I enter it and I can get right into the database no problem.  The problem is accessing the .mdb that sits...

Thanks to all for helping me out with this simple query.  I don't know why I couldn't get my mind around this.  I took the query from Bharat and modified...

Hi Perry,

I would also like to know how to create a view in SQL to a table in Access.  The ony things I can find to do that would be...