Thank you for all your help. Through your comments I was able to get Access and VBA to work again. Seems there were a number of components that weren't properly registered or missing dependency files on the computer. I suspect that two recent Service Pack updates (one for Windows XP and one for Office XP) did not properly install all files in the locations needed.
Solution: I used a tool from 4developers.com called COM Explorer which browses the computer (registry) for registered ActiveX, dll and exe components and reports on "misbehaved" ones. I found that many of my ADO, DAO, OLE and msadc components were missing files. In searching the harddrive, I found most of them in a folder in the
%WINDIR%ServicePackFiles\i386 folder. I copied the files where COM Explorer said they should be (or by default in the %WINDIR%System32 directory).
I may not have everything where it goes properly but it works now! I'm going to contact MS to inquire about the SP problem.
Again, thank you for all your help!