Access2000 & COM+

[frank ashley]

Does anybody know if Access2000 supports COM+.
I'm writing a DLL for ASP that must have the option of Access or SQL Server as a datasource.

[crispin]

it shouldn't matter what your data source is, what exactly are you trying to support in COM+ that you are concerned about?

[frank ashley]

I'm worried that I cannot find any documentation in Access re COM+ or MS DTC.

The DLL will eventually be talking to linked servers so thats why I'm worried about Access.

[crispin]

Distributed Transactions across SQL Servers isn't a problem, but when you lob an Access database into the equation my first incling would be to scream and run a mile, i'll do some digging for you, I reckon it might depend a lot on OLEDB, but i'm still not optimistic. You might be better off setting up some surrogate tables in one of your SQL servers and running a DTS package to import the data periodically (how often is up to you), then you can stick with the SQL server. It's not a generic solution, and it's only off the top of my head. Like I said I'll go and have a look around and see what transaction levels (distribution wise) Access supports....