Copying Sharepoint Database to Local (1 Viewer)

[mateogp]

Hello,

I have a database that the table is located on a sharepoint website. This worked out well in the beginning but now that the database has thousands of records, it has slowed up a bit. What I want to do is at the load of the the database, it will automatically copy Sharepoint table to a local table located on the computer to speed up querys and such.

I was thinking an append query, am I right?


Mateo

 

[Noblesongster01]

Yes, that would work. If you clear the table first or do an outer join query, you could do an append to bring in any new records. If you use ADO for the connection, the tricky part is getting all of the data copied down efficiently. I have code I wrote to do this and I'm rewriting it to make is significantly faster. Just ask me and I'll send you this when I'm done. Good luck, Bruce.