I published four forms to the our development sharepoint site. The db is an access 2007 db. The db is hosted on a shared network drive. On my development machine everything works fine. I go to the development site, go to the form library, click on create new, the form pops up, i click retrieve data and the data is retrieved.
I go to my team leads desk, map the shared drive, create the ODBC connection on her machine,, open sharepoint, go to form library, click create new, the form pops up, I CLICK RETRIEVE data and now i have an access error to the Main Connection, Access Denied, Access Denied.
When I publish do i have to do anything special when i have a data connection? Is there some type of permission i am not setting when i publish. I am publishing as a document library as DOMAIN( the form can access content from the domain in which it is located).
I have to demo this at 2:00 pm today.
You help would be greatly appreciated.