Linking SharePoint data to Access - Access File become corrupted.

D

Dai

I have my database link to Sharepoint Listitem with the 'Window Sharepoint
Service'. If one use try open the database and accessing anything that deal
with Sharepoint, the database would hang for moment to check for authication
for Sharepoint. At this point, if someone else try to do anything with the
database, the database would be corrupted and it would give me a message
'Your database is corrupted or damage due to unexpected shutdown of the
application......'

I know that when the database trying to access Sharepoint Listitem and doing
all the type conversion and verify authicatioin, it become very unstable
stage. How can I prevent this from happening. Currently, I have to make a
copy of the datebase and repair the database. Once it repair, copy it back
to the place put the database. I do this because of file locking issue of ms
access file.
 

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