Using FastLoad in an MS Access connection string

[MuadDubby]

Does anyone know if I can use the FastLoad parameter in a conneciton string to MS Access? I've been hunting this one for days and can't seem to get it to work.

Here's what I'm trying to use:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDB.mdb;FastLoad=True;Persist Security Info=False

The goal is eventually to copy data from SQL Server to Access, but no matter what I try is SSIS it's always slow. I found a few ghost posts on the net referrring to this FastLoad option, but nothing really conclusive. Any info would be very much appreciated.

Thx.

 

[JerryKlmns]

davidk13

From all 96 properties of the connection object, I can't find one including the word "Fast" or "Load".

 

[MuadDubby]

Hmmm ...
Ok, at least that narrows it down a bit. No wonder I couldn't get this to work

Thx for the answer!

 

[JerryKlmns]

David,

Do you have those posts handy?

 

[MuadDubby]

Sure. Here's one:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=708888&SiteID=1

Just go to Google and search for "fastload oledb". The above link is the first hit.

 

[JerryKlmns]

I think it refers to SQL Server, only!