Connection string for MS Access

[rf222]

I want to develop .NEt application reading MS Access Data.

1) What is connection string I can place in web.config?
2) In case if I decide to have linked MS Access tables in SQL Epress 2005, what are the connection settings for it?
3) In Case if I decide to have DTS scheduled job, how do I schedule this with SQL Express 2005? Do I need to have SQL Server 2000 for this?
4)What would be the best aproach from options 1-3? The input data always comes in MS Access... The tables are big...
5) The data will be exported as Web Service. Is there any existing sample how to do this?

 

[ca8msm]

Connection strings: faq855-5780


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.