VB School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become a VB Expert!

Join 300,456 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,643 people online right now. Registration is fast and FREE... Join Now!




VB6 with Access 2007

 

VB6 with Access 2007

Elly

17 Jun, 2009 - 11:11 PM
Post #1

New D.I.C Head
*

Joined: 6 Apr, 2009
Posts: 5


My Contributions
Hello guys,

I got problem to connect my Access to 2007 with vb6..
Can i know why?vb6 didnt support access 2007?

what the best way i can use to create a large database using visual basic?

kindly advice me.

tq.

User is offlineProfile CardPM
+Quote Post


noorahmad

RE: VB6 With Access 2007

17 Jun, 2009 - 11:20 PM
Post #2

Webmaster
Group Icon

Joined: 12 Mar, 2009
Posts: 2,018



Thanked: 125 times
Dream Kudos: 1350
My Contributions
Basically Access is RDMBS Relational Data Base Management System it good for small databases, but if you want to create Large Database then you need a Database Server such (Oracal, MS SQL Server, MySQL etc...) as your database back-end and you can use VB6 as your database front-end.
User is offlineProfile CardPM
+Quote Post

Elly

RE: VB6 With Access 2007

21 Jun, 2009 - 07:14 AM
Post #3

New D.I.C Head
*

Joined: 6 Apr, 2009
Posts: 5


My Contributions
QUOTE(noorahmad @ 17 Jun, 2009 - 11:20 PM) *

Basically Access is RDMBS Relational Data Base Management System it good for small databases, but if you want to create Large Database then you need a Database Server such (Oracal, MS SQL Server, MySQL etc...) as your database back-end and you can use VB6 as your database front-end.

can u show me how i can use My sql in VB6?
tq
User is offlineProfile CardPM
+Quote Post

vb5prgrmr

RE: VB6 With Access 2007

21 Jun, 2009 - 10:02 PM
Post #4

D.I.C Regular
***

Joined: 21 Mar, 2009
Posts: 459



Thanked: 30 times
My Contributions
Download MySQL, install, http://www.connectionstrings.com

Good Luck


User is offlineProfile CardPM
+Quote Post

leang86

RE: VB6 With Access 2007

29 Jun, 2009 - 01:24 AM
Post #5

New D.I.C Head
*

Joined: 25 May, 2009
Posts: 26

Hi, Why Microsoft Access is for small database, how many it can save?
User is offlineProfile CardPM
+Quote Post

noorahmad

RE: VB6 With Access 2007

29 Jun, 2009 - 01:44 AM
Post #6

Webmaster
Group Icon

Joined: 12 Mar, 2009
Posts: 2,018



Thanked: 125 times
Dream Kudos: 1350
My Contributions
Microsoft Access is not as Small Databases as You are Talking it can save unlimited records But as Records are Increasing it will not Work Fast.

This post has been edited by noorahmad: 29 Jun, 2009 - 01:46 AM
User is offlineProfile CardPM
+Quote Post

vb5prgrmr

RE: VB6 With Access 2007

29 Jun, 2009 - 05:48 AM
Post #7

D.I.C Regular
***

Joined: 21 Mar, 2009
Posts: 459



Thanked: 30 times
My Contributions
Ahhh...

noorahmad,

You statement...

>Microsoft Access is not as Small Databases as You are Talking it can save unlimited records But as Records are Increasing it will not Work Fast.


is only partially true thus making it a false statement...

As with any DBMS it is limited by disk space and thus therefore not unlimited. Furthermore, Access has a 2 GB limit...

see....

http://office.microsoft.com/en-us/access/H...=CH100621861033

for the latest access limitations which from my last glance has not changed for the last couple of version (since 2k I think).

and as for VB connecting to access 2k7 see http://www.connectionstrings.com and you may have to download the latest MDAC for you system.


Good Luck


User is offlineProfile CardPM
+Quote Post

leang86

RE: VB6 With Access 2007

29 Jun, 2009 - 10:23 PM
Post #8

New D.I.C Head
*

Joined: 25 May, 2009
Posts: 26

Hi, i'm using vb6, and i decide to change my database to mySQL, but why my vb6 cannot recognized the mySQL database, it say my database are unrecognized database format. What can i do?

Please help me...
Thanks...

This post has been edited by leang86: 29 Jun, 2009 - 10:26 PM
User is offlineProfile CardPM
+Quote Post

vb5prgrmr

RE: VB6 With Access 2007

30 Jun, 2009 - 04:46 AM
Post #9

D.I.C Regular
***

Joined: 21 Mar, 2009
Posts: 459



Thanked: 30 times
My Contributions
First, create an ODBC DSN to you MySQL instance (found under administrative tools, Data Sources ODBC).

Then use the Data Form Wizard with the ODBC option...

Start a new standard exe project and goto VB's IDE menu Add-Ins>Add-In Manager.

Scroll down until you see VB 6 Data Form Wizard. Select it.

Then in lower right hand corner of dialog where the frame is with the caption of Load Behavior, put a check in the box next to where it says Loaded/Unloaded. Click OK.

VB's IDE Menu>Add-Ins>Data Form Wizard.
Select ODBC and follow the wizard as many times as necessary to give you examples of each type of display form with each type of code/class/control.
Save this project for future reference.
Then to get rid of the ODBC DSN goto http://www.connectionstrings.com and see their examples on how to use and DSN Less ADO connection.


Good Luck



User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/8/09 02:05AM

Live VB Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month