Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5
This is the forum to discuss the Wrox book Beginning Visual Basic 2005 Databases by Thearon Willis; ISBN: 9780764588945
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 10th, 2007, 01:17 PM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to use access 2007 databases in vb 2005?

I can connect to access databases using the old mdb format. How can I connect to access databases using the new access 2007 format which is accdb?

Thanks for any help.

Reply With Quote
  #2 (permalink)  
Old July 10th, 2007, 05:23 PM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Location: Fuquay Varina, NC, USA.
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

The ProjectTimeTracker Access database was created using Access 2003 and automatically saved in the Access 2000 format. You can open the database using Access 2007 with no problems.

Thearon
Reply With Quote
  #3 (permalink)  
Old June 16th, 2008, 11:48 AM
Authorized User
Points: 47, Level: 1
Points: 47, Level: 1 Points: 47, Level: 1 Points: 47, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2008
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Along the same lines for this question:

I have VS2005 Developer and have purchased Office 2007 Professional and have installed that. I downloaded the Northwind template from Microsoft's Website and created a database with it (I guess that's what I did, anyway) named Northwind 2007.accdb. When I try to do the Try It Out involving the DataGridView Control in Chapter 3 at step 9, I get an error message that the file is not in a recognized format. Is there an add-on or something that will allow VB2005 to link to .accdb files, should I download the 2003 version of Northwind, can I convert the .accdb file to an .mdb?

Thank you very much for your assistance.

Eric



UPDATE: I went searching on MSDN and found the answer to my question. Here are step-by-step instructions as displayed in the forum post at http://forums.microsoft.com/MSDN/Sho...94617&SiteID=1

Step by step instructions. From the Add Connection dialog:



1) Click the Change button for the Data Source

2) From the Change Data Source dialog select <other> in the Data source list

3) Click the OK button

4) Back to the Add Connection dialog select Microsoft Offfice 12.0 Access Database Engine OLE DB Provider from the OLE DB Provider drop down

5) In the Server or file name text box enter the path to your Access 2007 database file

6) Click the Test Connection button to make certain that you can connect to the database

7) Click on the OK button to finish creating the data source.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Integrating Excel 2007 into VB 2005 express jffrs_20 Visual Studio 2005 0 October 12th, 2008 10:49 PM
Vb.net 2005 using MS Access johnnys14 SQL Language 0 July 10th, 2008 01:14 PM
Updating databases with VB 2005 Express PatCiferri VB How-To 3 December 3rd, 2007 07:31 AM
VB, Access and ACT Databases dbrook007 Pro VB Databases 0 July 6th, 2007 05:32 AM
VB.NET 2005 to MS Access h@ckerz VB Databases Basics 5 March 6th, 2007 10:22 AM



All times are GMT -4. The time now is 07:40 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.