Is there a version of Microsoft Office Access uses C# instead of VB6 for native automation? If so how do I go about using it - is there some way to switch it or activate it?
-
Just to be clear, do you mean Access, the rapid application database development tool, or Jet/ACE, the default database use by Access?Fionnuala– Fionnuala2011-01-14 18:56:50 +00:00Commented Jan 14, 2011 at 18:56
-
Yep that's the one - Microsoft Access.Praesagus– Praesagus2011-01-14 19:11:17 +00:00Commented Jan 14, 2011 at 19:11
-
No. Why would you do that ? Triple the development duration ? 8-/Patrick Honorez– Patrick Honorez2011-01-14 22:24:11 +00:00Commented Jan 14, 2011 at 22:24
Add a comment
|
3 Answers
Not natively, no. But here is an article on how to do some basic automation functions externally using C#:
http://support.microsoft.com/kb/317114
It's not integration in the sense that you can write macros in it, but it will give you a reasonable level of control.
1 Comment
Praesagus
I was afraid of that. I did see that article, but was hoping that MS had integrated .net by now. I seem to remember checking a box when installing that said something about using .net for automation. sigh.
Yes you can but it's not like flipping a switch on and off. Automating Access with C#
1 Comment
David-W-Fenton
If you're using COM automation, you're not really using C# for your code, no? Or, put another way, you're writing Access code (i.e., VBA, executed via COM) inside C#, and at a couple levels removed.
May be this will help:
Another article for MS Access and C# connection:
