Access Data Collection Replies stopped working.

T

Tim Carroll

All:

I have searched this list and the General Questions list and did not find an
answer to my question. I created an Access 2007 database and email
collection form (XML -InfoPath) to collect inventory data for room here at
our institution. The database is linked to a SharePoint form which I have
been updating each time I receive data.

Problem: Everything worked great until about a week ago. Now when I receive
an email with the InfoPath forms I receive the following message when I
attempt to process the forms:

[Failure: Cannot update. Database or object is read only.]

I have also attempted to collect the data using the External Data import
feature. I get the following error when I attempt that:

[Method 'Value' of object 'Field2' failed.]

I have about 90% of the data and do not want to manually enter the data.
Has anyone experienced a similiar problem and fixed it?
 
T

Tim Carroll

Jerry,

I will take a look at both suggestions and let you know what I find.
--
Tim Carroll


Jerry Whittle said:
First check that the database, and the folder it's in, aren't read only.
Actually make sure that any users of the database have read, write, create,
delete, and modify privs for the folder and database file(s).

As for the second error, I found this using Google:
http://forums.techguy.org/business-applications/699695-problem-access-2007-a.html
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Tim Carroll said:
All:

I have searched this list and the General Questions list and did not find an
answer to my question. I created an Access 2007 database and email
collection form (XML -InfoPath) to collect inventory data for room here at
our institution. The database is linked to a SharePoint form which I have
been updating each time I receive data.

Problem: Everything worked great until about a week ago. Now when I receive
an email with the InfoPath forms I receive the following message when I
attempt to process the forms:

[Failure: Cannot update. Database or object is read only.]

I have also attempted to collect the data using the External Data import
feature. I get the following error when I attempt that:

[Method 'Value' of object 'Field2' failed.]

I have about 90% of the data and do not want to manually enter the data.
Has anyone experienced a similiar problem and fixed it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top