Using VB.Net as a front end to Access?

[BukHix]

Has anybody started programming VB.Net as a front end for Access? I have an application where I am currently doing just that.

I have some code in a current Access form that I would like to make work in my VB form but I am not sure how to do it. For instance running a query or transferring a spreadsheet.

I am guessing that I am going to have to give up all built in Access functions and rewrite them in SQL statements. Is that the case?

[Edneeis]

Yes.

You could open Access and perform function using it as a referenced COM object, but to some degree it defeats the purpose of then having a seperate front end.

[BukHix]

Thanks Edneeis. I am trying to get up to speed on ADO.Net (w/Access) but am not going to get a full grasp in time for the due date on the project.

I think I am going to have use a mixed solution of VBA functions and VB.Net code in the short term and start working toward a full VB.Net version for a later date.

Thanks for the reply.

[Edneeis]

Sounds like a plan. Its pretty easy once you get to know the Access objects a little. I had to do this for some quick fixes using VB6 so if you get stuck just post again.