Linking SharePoint data to Access - Access File become corrupted.

  • Thread starter Thread starter Dai
  • Start date Start date
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.
 
Back
Top