MS Office Web Components (1 Viewer)

[Hozer]

i am trying to view/edit an Access 2003 DB over the internet, i have my own webserver setup with server 2003 and IIS 6. when i try connecting to the DB over the internet i get an err stating 'Miocrosoft Office Web Components sould not open the database c:\db.mdb'

how can i get it to look at the server rather than the local sysem for the mdb?

 

[Lawrenceiow]

Hozer,

I've created a 'website' that runs off a CD. When I set it up it was pulling data from Access tables on one of our network drives so the path OWC had was y:\mis\db.mdb

To get it to pull the data from the CD instead I just edited the HTML using Notepad and searched for db.mdb and then removed the 'y:\' part and put of copy of db.mdb into a folder called 'mis' on the CD. and this worked.

Try removing your C:\ and see if it works - I think you should use a text editor like Notepad to do this though.

 

[Hozer]

Lawrenceiow,
i have tryed that and still it does not work.
i have tryed many changing all sorts of stuff with my connection string and i have checked over the ODBC setting and IIS settings on my server many times. but now all i am getting is an error stating 'Internet server error'

Thank you.