Can not post to access database from a .asp page

[sircooljoe]

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

I have a basic form with 4 drop down fields each field is populated from a
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.

 

[Ronx]

It's an Access problem. If the database is in use via Access, it cannot be
used by the website. The solution is to copy the website database to
another location, then run the reports on the copy.

--
Ron Symonds
Microsoft MVP (Expression)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.