visual studio.net 2003 and Access 2007 database

[Cindy H]

Hi

I am currently using Visual Studio.Net 2003 running on Windows Server 2000
operating system.
I have used Visual Studio.net 2003 connecting to Access 2002 databases in
the pass with great success.
Now, I have a need to go to Access 2007 which produces database.accdb file
instead of database.mdb.
I've used ole db Jet 4.0 to connect to Access 2002 in Visual Studio.Net
2003, now I guess you need to use Microsoft Ace 12.0 to make a connection.
I don't know a lot about how these ole db drivers work - where does VS.Net
get it's list of drivers from?
I'm trying to avoid having to purschase Visual Studio.Net 2005 - if
possible.
Access 2007 wouldn't work on Windows Server 2000 operating system, so I was
planning on installing it on XP and then installing Visual Studio.Net 2003
on XP.
I'm wondering if this will solve my problem with Visual Studio.Net 2003 not
understanding what an accdb file is and being able to use the Microsoft Ace
12.0 ole db to connect to an Access 2007 database.
Does any one know about this?

Thanks,
CindyH

 

[Guest]

Cindy,

This site has the components you need:

http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en

You will also need to change your connection string:

http://connectionstrings.com/

Kerry Moorman

 

[Cindy H]

Hey - thanks Kerry.

I think the AccessDatabaseEngine.exe will only work on XP (not windows
server 2000), so I will have to install vs.net 2003 there - is that right?

CindyH

 

[Guest]

CindyH,

I think your OS options are Server 2003, XP and Vista.

Kerry Moorman

 

[Cindy H]

Ok, great - thanks for your help.

CindyH,

I think your OS options are Server 2003, XP and Vista.

Kerry Moorman