How can I write C# code that can pick up the custom events that occur in it's Access server?

[keithgell]

I needed to import large CSV files into Access, when requested by a
command in a .Net interface.

Because Access does not have a bulk insert command, and I already have
vba macros in Access that do the import, I simply called the vba macro
from .Net using COM.

Each time a csv file is successfully imported, I would like to raise a
custom event in Access that the .Net interface can handle.

The situation is complicated, by the Access database that the csv files
are imported to is a copy of a stadard template Access file, this
cahnges the GUID Id of the Access server everytime the program runs.

How can I write C# code that can pick up the custom events that occur
in it's Access server?

Thanks in advance if anyone can help.

[Terry Kreft]

Why not just do it properly.

Use ADO.Net from your C# program to do the import.

At the moment you're just digging yourself a deeper whole.

If you really insist on doing this wrong then you'll need to look up how to
create public classes in Access so that you can then create publicly
available events for you to sink in C#.

--

Terry Kreft
<ke*******@yahoo.com> wrote in message
news:11**********************@r44g2000cwb.googlegr oups.com...

I needed to import large CSV files into Access, when requested by a
command in a .Net interface.

Because Access does not have a bulk insert command, and I already have
vba macros in Access that do the import, I simply called the vba macro
from .Net using COM.

Each time a csv file is successfully imported, I would like to raise a
custom event in Access that the .Net interface can handle.

The situation is complicated, by the Access database that the csv files
are imported to is a copy of a stadard template Access file, this
cahnges the GUID Id of the Access server everytime the program runs.

How can I write C# code that can pick up the custom events that occur
in it's Access server?

Thanks in advance if anyone can help.

[Rich P]

To handle events from Access you will have to use delegates in your C#
program.

Rich

*** Sent via Developersdex http://www.developersdex.com ***