access with .asp form

Hello,
I am having an a problem that I can seem to solve. Any help would be
appreciated.

I have a basic web form, (Created in frontpage 2003) with 4 drop down fields
each field is populated from it's own table, (rep,caller,call type, brand),
in an access 2003 database,
these 4 fields then post to another table (results) in the same database .
The issue I am having is when I try to run reports against the database.
I have created new databases and linked all the tables back to it. I have
then created forms and reports in this new database. Everything works fine
there. The issue is when I am doing this, the drop down menus are no longer
populated on the webpages so the users can not post any data.
I am not sure if this is an asp, frontpage or access issue.
Does anyone have any ideas what may cause this and how to resolve it.
Currently, I have ask the managers not to run reports until after they are
sure no one needs to enter data in the web form.
Thank you in advance for any assistance.