Data Access Page error in data entry

[Guest]

I just created a data access page to perform data entry via an HTM pagein IE
(Access 2002). The database is stored on one of our servers where everyone
has permission to access. The thought is to create a DAP so users without MS
Access can enter data in to our database. The page works great on my machine
and my co-worker's (we both have Access installed). Testing the page on a
different machine (one without Access) the page loads perfectly fine and
displays data from the database, including linked drop down menus. Once a
the form is populated and the "Saved" button clicked I get following error:

"Data Provider or other service returned an E_FAIL status."

The data is not written to the tables. I have recreated this error on three
machines throughout the office, even on one that has Access installed. For
form works on a separate machine that does not have the Access.

My network admin and I are unsure where to start to troubleshoot this error.
Can you please provide some insight? Thanks.

Here is my connection string:
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=\\smi_water\marketing\MarCom\Lead Database\Database of MarCom
Leads.mdb;Mode=ReadWrite;Extended Properties="";Persist Security
Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet
OLEDBatabase Password="";Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking
Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global

Jake

 

[Ken Snell [MVP]]

Do those other PCs/users have full rights to the folder where the database
is located? Meaning "edit/read/create/delete"? Those PCs/users must have
those rights in order for data to be edited/written to the database.

 

[Guest]

Those users do have full rights "edit/read/create/delete" to the folder where
the database is located. It doesn't appear to be associated with any one
user, as if I log into one of the machines that is having this problem I too
get the error message. It looks like the problem is associated with the box,
not the user.

Anything else I could try?

Jake

 

[Ken Snell [MVP]]

Check that you have the most recent Office Web Components update on those
PCs that are not working. It can be obtained from Microsoft's web site.

I assume that the page is located on the server where the database is
located?

 

[Guest]

Yes the page is located in the same folder as the database.

 

[Guest]

I just downloaded "Office XP Tool: Web Components" onto the machines that are
having problems and I still receive the same error message when trying to
write to the database. We all run Office 2002 in house. This includes my
machine as well.

Jake

 

[Ken Snell [MVP]]

I do not have other suggestions, sorry.

See if any of the articles returned by the following URL might be helpful
for your setup (URL will wrap, so you may need to copy/paste into your
browser):

http://support.microsoft.com/search...mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a&x=9&y=2


--

Ken Snell
<MS ACCESS MVP>