Writing directly to Access DB file with EB 1

[0wned]

Hey, been browsing the forum on and off the last few weeks and I think Im ready to make a post Im kinda new at all this so correct me if I say something stupid

Ive read few post about connecting to Access Databases, and from the sounds of it you have to have Access running, or start it up to do it. What I want to know is if I can write to an Access DB without running Access? If so, can I see some example code?

Thanks,

Jon

 

[calculus]

Check the FAQ: How do I get data to Excel? faq99-4068

You would use this connection string instead of the one listed in the FAQ:
StrConString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & _
DataFile & ";" & adoConn.open strConString

You use an ADO to connect to the Access Database. No, Access doesn't have to be open to read/write to it. Actually if Access is open in Design mode it will cause problems.

calculus

 

[0wned]

calculus, I don't think "you rock" quite says it

thanks man,

Jon

 

[0wned]

oh yea, forgot to mention that I saw your excel faq, yea was thinking it would be similar thanks again,

Jon