By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

visual studio.net 2003 and Access 2007 database

P: n/a
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

Aug 22 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Cindy,

This site has the components you need:

http://www.microsoft.com/downloads/d...displaylang=en

You will also need to change your connection string:

http://connectionstrings.com/

Kerry Moorman

"Cindy H" wrote:
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

Aug 22 '07 #2

P: n/a
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

"Kerry Moorman" <Ke**********@discussions.microsoft.comwrote in message
news:8C**********************************@microsof t.com...
Cindy,

This site has the components you need:

http://www.microsoft.com/downloads/d...displaylang=en

You will also need to change your connection string:

http://connectionstrings.com/

Kerry Moorman

"Cindy H" wrote:
>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


Aug 22 '07 #3

P: n/a
CindyH,

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

Kerry Moorman
"Cindy H" wrote:
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

"Kerry Moorman" <Ke**********@discussions.microsoft.comwrote in message
news:8C**********************************@microsof t.com...
Cindy,

This site has the components you need:

http://www.microsoft.com/downloads/d...displaylang=en

You will also need to change your connection string:

http://connectionstrings.com/

Kerry Moorman

"Cindy H" wrote:
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



Aug 22 '07 #4

P: n/a
Ok, great - thanks for your help.

"Kerry Moorman" <Ke**********@discussions.microsoft.comwrote in message
news:3A**********************************@microsof t.com...
CindyH,

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

Kerry Moorman
"Cindy H" wrote:
>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

"Kerry Moorman" <Ke**********@discussions.microsoft.comwrote in message
news:8C**********************************@microso ft.com...
Cindy,

This site has the components you need:

http://www.microsoft.com/downloads/d...displaylang=en

You will also need to change your connection string:

http://connectionstrings.com/

Kerry Moorman

"Cindy H" wrote:

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




Aug 22 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.