I will try to look into those things. Thank you for all of your help.

It's a weird situation and I wish I had someone here at my work that could explain what they coded! Not sure why they did what they did anyway. If you can read from SQL why put it in Access, since there is a limit in access anyway.