Access using VB.NET code

[DonS100]

Hello, I currently have an Access 97 application. As I further build it, I'm wondering what people's thoughts are on continuing to write the code using VBA. Can or should you try to start writing code as VB.NET and then reference it from inside Access? What if you upgrade to Access 2003, can you then write the code inside the application as VB.NET?

Thanks

Don

 

[lupins46]

Access knows nothing about VB.Net.

You can write VB.Net applications that use a Jet ("Access") database but you cannot use VB.Net in Access.

 

[DonS100]

If you wanted to couldn't you write VB.NET, then compile it as a dll, then you could reference the dll from within Access. I'm not saying I'm going to do this but someone was asking me if this was possible.

Also, I remember somewhere reading that you could write VB.NET code in Access 2003, but I think that individual was mistaken.

Thanks

Don

 

[lupins46]

You can create dlls in whatever way you like, but that hardly constitutes 'using vb.net in Access' in my book even though you would need the framework to run it. You're not able to write any vb.net code in Access.