is Possible to use Access 2003 with VB2010?

[lechip]

Hello!
I'm rather new in the developing with VB, i usually use Java. I'm in a project where an Old Database stored in Access 2003 must be used to develop an application. The selected technology is VisualBasic 2010 (particularly with the Express edition IDE). Is such combination possible?

Thanks!

 

[darbid]

Quick answer is yes. You might be in the wrong section of the forum but I am sure a mod will move it.

First you are using VS2010 (FREE VERSION) this means you can make the connection to many databases (an ODBC) connection. The Free version will not show your database structure like the PRO version does. I have seen both and it is really great to have one IDE with everything in it. Certainly ADO/DAO is going to work but I am not sure which of the new .NET connections will work eg ADO.NET and LINQ to SQL. I know that these have problems connecting to SQL Server 2000 so I am going to assume that they also will with MSAccess.

But if you are using VS2010 then SQL Server 2008 is also installed. If you are now going to make a whole new Win Forms or WPF front end why not FIRST move all your data to SQL Server Express?

 

[lechip]

Its a corporate problem, i would rather have SQL obviously, migrate the database from MSAccess2003 to SQL and work with VB2010 on top of SQL2008. Its more of a bureaucratic problem.
Anyways the program is rather simple (controls a physical storage of an archive), yet the number of records is pretty big and the client wants to rather keep the Access DB.

 

[lechip]

Anyways, i have another question. My application is going to be implemented using the 3 level architecture, so i need to know a good way to map from objects to Access in VB2010. In Java i use Hibernate. Any suggestions?

 

[darbid]

My application is going to be implemented using the 3 level architecture, so i need to know a good way to map from objects to Access in VB2010. In Java i use Hibernate. Any suggestions?

I have Zero experience and I must admit your technical words are also a bit beyond me, from a quick search I just found

Hibernate - Not officially supported, but I believe you can try it with their GenericDialect. Use the JDBC-ODBC bridge for the driver, of course.

If I am dealing with MSAcces I have only used MSAccess - it is an all-in-one solution. You might look at TOAD to see if it will connect to access - otherwise just use MSAccess - you can link your local MSAccess to whereever your backend tables are stored. You will then be able to make queries etc just the same.

 

[lechip]

Well by my guess Microsoft must have some kind of technology or way to map an Object Oriented architecture into a RDBMS so I'm guessing I'll find a solution eventually. Thanks for the help a lot mate!
Cheers!

 

[darbid]

Well by my guess Microsoft must have some kind of technology or way to map an Object Oriented architecture into a RDBMS so I'm guessing I'll find a solution eventually. Thanks for the help a lot mate!
Cheers!

But that is the point - MSAccess is not really a RDBMS. You should tell the political people in your company this.