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

Retieving Data of MS Access by VB6?

P: 2
I am creating a book store system with VB 6. I have four interfaces and in the database I save information about books and companies in 2 tables. In the book table my fields are - Book Name, Stocks, ISBN & in the other my fields are -Company Name , Address. But I cannot create a primary key. Help me there plase!
And also i want to know the codings to retrieve the saved data of the tables. Anyone of you know? Please reply!
Apr 29 '07 #1
Share this Question
Share on Google+
3 Replies


P: 14
Ms Access provides the facility to form the primary key, there is a key icon in the tool box, and then in the relationships menu, relation between both the tables can be formed.
To retrive data into VB, VB should be connected to Ms access, you can do it by many ways.
Apr 29 '07 #2

Dököll
Expert 100+
P: 2,364
I am creating a book store system with VB 6. I have four interfaces and in the database I save information about books and companies in 2 tables. In the book table my fields are - Book Name, Stocks, ISBN & in the other my fields are -Company Name , Address. But I cannot create a primary key. Help me there plase!
And also i want to know the codings to retrieve the saved data of the tables. Anyone of you know? Please reply!
Hey there vbuser333

I got just the thing, but if this is a school project I need to know where you are, any coding measures already taken in order to attempt coaching.

You can also fetch this forum a bit deeper, a number of tips should and will pop up. I find this to be helpful...

Good luck with the project!

Oh, I would also suggest starting with one table, make it work with VB then move on to the next (cut an paste existing code for other tables)...

Dököll
Apr 29 '07 #3

P: 2
Well, hi. yeah mine is a school project. I need a tutor to teach me how finish this coding. I already did designed all the interfaces. I know how to code exit,clear, save and linking other forms but retrieving data from a MS Access is difficult. Will youhelp me? please.

Hey there vbuser333

I got just the thing, but if this is a school project I need to know where you are, any coding measures already taken in order to attempt coaching.

You can also fetch this forum a bit deeper, a number of tips should and will pop up. I find this to be helpful...

Good luck with the project!

Oh, I would also suggest starting with one table, make it work with VB then move on to the next (cut an paste existing code for other tables)...

Dököll
Apr 29 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.