Access 2007 and C#

Stelly · 13 Apr 2008 at 15:40

Hi All,

I'm traditionally a web programmer, but for some unknown reason my employer wants something written in access, now I can do SQL untill the cows come home, but it would be easier for me if in Access 2007 you can use C# which would make sense since its Microsoft, but as you all know Microsoft dont always make sense...

Stelly

Amleto · 13 Apr 2008 at 15:51

I thought it's only possible to use VB & SQL stuff inside access

Stelly · 13 Apr 2008 at 15:59

I dont know... I was just asking, I might need to have a look first

Stelly

andshrew · 13 Apr 2008 at 16:49

You can't use C# from within Access unfortunately, its VBA only. You can however connect to an Access database through C# if you wanted too, and manipulate the database through your own program.

Haircut · 13 Apr 2008 at 16:56

andshrew said:
You can't use C# from within Access unfortunately, its VBA only. You can however connect to an Access database through C# if you wanted too, and manipulate the database through your own program.

Yep, personally I would avoid doing anything in VBA.
If you treat the Access database as simply an ODBC datasource and code a C# application to connect to it that would be far more preferable.
That way it makes it a lot easier to ever move the application onto a different platform in the future too.

Is there any reason they are using Access over SQL Server Express though?
For most applications that would be the way to go IMO.

Conrad11 · 13 Apr 2008 at 17:24

Take a look here: http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx

...although i don't think it has any stuff on datasets and 9.9/10 (i'd say) its best to use datasets.

Stelly · 14 Apr 2008 at 11:55

Ok well I'm going to use a web front end now... I'm looking at it but I'm getting this error:

Unable to find the requested .Net Framework Data Provider. It may not be installed.

Any ideas?

Stelly