Hardest question ever, Access->Sharepoint

[JohnKubik]

Hey everyone, been looking around all day and made minimal progress.

I have an Access 2007 database and a Sharepoint 2003 server/site. I have managed to export the tables to Sharepoint, but how on EARTH do I get the forms I have made to work on sharepoint. Basically, I want to be able to the user got an "advanced search" form and type in what they are looking for, and then have the results displayed, have them dbl click the results and it open a different form with txt boxes and such with the information pertaining to the item they double clicked. It is driving me batty!

I have search around for a while, if there is a form post that I some how missed please link it for me.

Thanks in advance!!

(PS. I am aware sharepoint 2010 has WAY better access integration, and web services, but I am unable to get the to upgrade to 2010 )

[ajetrumpet]

maybe try MARS instead?? EARTH does not house the hardest questions ever.

I do not know John, but good luck here. I'm sure someone else will step in with help. There are some sharepoint folks lingering here...

[JohnKubik]

Haha, yeah. Yeah, it is definitely out of this world when it comes to difficulty.

If you know any of the sharepoint people let them know I need help!

Thanks!