Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > Visual Basic 2005 Basics
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics 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
Thread Tools Display Modes
  #1 (permalink)  
Old July 27th, 2006, 01:29 PM
Registered User
Join Date: Jul 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default VB2005 + Ms Access

I rather say I'm Access Developer more than VB programmer.
Quite rely on Access Query By Example....
Now I try to develop a access database system which open with VB (VB2005).

By using ADO to make connect to my access database but VB 2005 give me several error message,this happened to OBLEDB as well....

What is the different between them ?? ( I read MSDE document but ...)
Can someone teach me how to use code to establish connect to MS Access ? I need to do log in username and password checking...

Any example or reference website which build MS Access Application with VB 2005 ?

Your reply will be appreciated.Thank You.

Reply With Quote
  #2 (permalink)  
Old July 31st, 2006, 12:26 PM
Friend of Wrox
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

As I understand it, ADO is a wrapper for OLEDB.

Could you be more explicit about what steps you are taking, and what the result is (including the text of any errors)?
Reply With Quote
  #3 (permalink)  
Old August 20th, 2006, 12:34 PM
Authorized User
Join Date: Aug 2006
Location: Charlotte, NC, USA.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anubisascends

You can go into the Tools menu and click on the Connect to database option to connect to your Access database that you have created. The you just have to create a datasource to tell VB what tables, view, and queries that you want to use from this database.

Just follow the wizard.

Hope this helps.

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.
Albert Einstein
US (German-born) physicist (1879 - 1955)
Reply With Quote
  #4 (permalink)  
Old August 23rd, 2006, 07:39 AM
Authorized User
Join Date: Jul 2006
Location: Festac Town, Lagos, Nigeria.
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to dilionyi

if you really want help it would be necessary for you to give us the code u are currently using and the errors u are getting as Brian has said and we could just help u modify it to suit ur needs.
But it would also be great if u learn how to use the wizard since u are a beginner

Reply With Quote

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
Change the format of MS Excel Cells from MS Access hewstone999 Access VBA 0 March 7th, 2008 07:19 AM
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 12:38 PM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 01:48 AM
MS Data Grid control in ms access application roshla_p Access VBA 5 October 16th, 2006 03:37 AM
export data from Access to XML file with VB2005 larspersoon Visual Basic 2005 Basics 2 November 25th, 2005 09:41 AM

All times are GMT -4. The time now is 03:20 PM.

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