I'm a noob when it comes to programming but i need to finish my double module final year project. What code can I use to link an MS Access database (named db1) to my VB 6.0 system? Its a standalone system...

And besides that, is there any how I can create a database with Access to store pictures of designs that will have properties in terms of price and size? I need this so the DSS (decision support system) part can do its search and load all designs within the criteria set.

Expert programmers, please help and thanks for any information.

Don't know what to say bout ur condition..but u need to brush up ur skill....

There are several way to connect vb6 to MSAccess...the simplest way is use data control which available at the tool bar. Just specify the path of ur database location and it can connect.

Else use ADODC and follow the wizard. If wan more powerful use SQL connection.

For storing pictures using database is advisable to store the picture path only. It can store the picture in the database but not very practical. So just store ur picture elsewhere and store the path to ur database. THen u use the path to retrieve the picture using ur program. Hope this can help a bit.

Acey,


I won't say much, since the samples code can be found in Free VB Code.


Happy Coding

wow how many times this question has been repeated

Haha, i've done a quite similar program for my assignment....about the pictures storing...i can't figure out how to store in MS Access database so i just store the path of the picture and load in during runtime....

ooo thanks guys

huiyoooooorrrrrr basket VB... i try to link the database but tell me my Access database got .mdb extension is not recognized... wtf is that????? KNNCCB FCK PROGRAMMING BASKET VB CCB I DO UNTIL WANNA THROW MY CHAIR SON OF A b**** VB

This post has been edited by Acey: Jan 19 2006, 12:53 PM

Do you have MS Office Access installed? If not it will not work...

angry never solved problem

@Aaronze... yes, else why would I get so pissed?

i also have this problem b4...
even foxpro or other db also not recognized...but i end up not using a database lol. If you still HAVE TO USE DB --->

I recommend you ask in www.vbforums.com
seriously a lot of pro's there. Most Q's answered in a day (if you provide all the necessary info).
linking your prog with database is answered in FAQ's

Huh impossible not recognised


use the connection string
http://www.connectionstrings.com/

adui... dono what to do d... cos my database covers 70% of my system's operation cos i got appointments, customer info, sales, payments, DSS based on designs... die lar die lar... went to library n borrow 2 thick ass books on VB.. if still cannot tmr burn 1 cd ask my class punya monsters to help

i thought super easy to connec to access
dunno what is ur problem

Mind posting a screenshot when the problem occurs? Sometimes it's because that the program can't find your database because u moved the program and database file to other directory or drive and the program can't find the database file...in this case must use the connection string code.

^ i'll post later... now very tired, just finished cutting acrylic... cant be the prob u mentioned cos i'm always concious about where each important file is and where I saved them.

make sure u connect 2 the PROVIDER and DATA SOURCE correctly...
in ur case, i suggest u use the PROVIDER=Microsoft.Jet.OLEDB.4.0
ur DATA SOURCE should refer to the specified folder dat keep ur .mdb file

^ will try it.. I suspect either sth wrong with the VB or Access so I redo the whole system on a new project.. will try to post what happens later with the database... thx

now... someone tell me wtf does this mean?

There is no such function as "Opendatabase" in VB, i think, correct me if am wrong, forgot some stuffs of VB already....