Using VB.Net as a front end to Access?

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?

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.

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.

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.