Creating my first table and databases and more.
Hi,
I am a VBA pragrammer with some VB experience. I have never made a table before using VB (made a few with Access) and I am trying to learn how.
The help files are terrible for someone new to VB. They were made for someone with plenty of experience already. They didn't even tell me I needed to add any libraries to make an Access table, just supplied the code and that was it. Boy if that didn't take a while to figure out.
So now I am here complaining about the help files and asking for some help. It would take me weeks to find out from the help files what someone out there can tell me in a little while.
I am using VB6 (My first except for VB for Dos and VBA).
1. What are the different kinds databases and tables that VB can create.
2. What are the differences and what situations are best for each.
3. What would be the best one for a single computer ie..my home computer and which would be best for a network.
4. Can VB make its own tables that are native to VB itself and are included
in the project files or only other kind like Access tables and if so
offer some directions or code on how.
5. Anything else at all that you can exlpain to me about tables like I've never
heard of one before.
I am offering all the points I have and will give more later if necessary for someone who can thoroughly explain this to desperate me.
Please try and use plain English. If what I am asking is to broad, then just do the best you can that is worth these points.
Sorry for being so ignorant an the subject, but I just can't find out what I need to know from the help files. My main goal is to learn how to create a database and table from scratch (preferably one that is included in the project files if it works that way). Maybe that's to much to ask on a forum because I really don't know what all is involved.
I know I sound really stupid on the subject, but that's because I am.
I am familiar with programming and writing code.
Thank you for whoever can help me get started.
ahammar
Ps I've already checked out question EQ.10124078 but it doesn't tell me how to make a database or a table.
I am a VBA pragrammer with some VB experience. I have never made a table before using VB (made a few with Access) and I am trying to learn how.
The help files are terrible for someone new to VB. They were made for someone with plenty of experience already. They didn't even tell me I needed to add any libraries to make an Access table, just supplied the code and that was it. Boy if that didn't take a while to figure out.
So now I am here complaining about the help files and asking for some help. It would take me weeks to find out from the help files what someone out there can tell me in a little while.
I am using VB6 (My first except for VB for Dos and VBA).
1. What are the different kinds databases and tables that VB can create.
2. What are the differences and what situations are best for each.
3. What would be the best one for a single computer ie..my home computer and which would be best for a network.
4. Can VB make its own tables that are native to VB itself and are included
in the project files or only other kind like Access tables and if so
offer some directions or code on how.
5. Anything else at all that you can exlpain to me about tables like I've never
heard of one before.
I am offering all the points I have and will give more later if necessary for someone who can thoroughly explain this to desperate me.
Please try and use plain English. If what I am asking is to broad, then just do the best you can that is worth these points.
Sorry for being so ignorant an the subject, but I just can't find out what I need to know from the help files. My main goal is to learn how to create a database and table from scratch (preferably one that is included in the project files if it works that way). Maybe that's to much to ask on a forum because I really don't know what all is involved.
I know I sound really stupid on the subject, but that's because I am.
I am familiar with programming and writing code.
Thank you for whoever can help me get started.
ahammar
Ps I've already checked out question EQ.10124078 but it doesn't tell me how to make a database or a table.
ASKER
Hi arcusd,
Yes, that definately helps alot. Thank you!
I would like to ask you or someone else a couple things then about some code I took from the help files later on so I can get my points worth. I can use the example from the help file to create an Access db, but down at the bottom where it loops with the properties, I'm not sure what it is doing, but I get an error and I don't know why.
I will explain more later when I'm not at work and will give you or whoever most deserves them the points.
Thanks again,
ahammar
Yes, that definately helps alot. Thank you!
I would like to ask you or someone else a couple things then about some code I took from the help files later on so I can get my points worth. I can use the example from the help file to create an Access db, but down at the bottom where it loops with the properties, I'm not sure what it is doing, but I get an error and I don't know why.
I will explain more later when I'm not at work and will give you or whoever most deserves them the points.
Thanks again,
ahammar
ASKER
Hi again arcusd,
Well, I tried it again and it seems to work fine now. I don't know why it didn't before. Last time I tried it I added a lot more libraries then the ones you mentioned because I wasn't sure which ones to use. This time I just added the Microsoft DAO or ADO Library ( I don't remember which now) like you mentioned and it worked fine. Maybe I had to many before. Is that possible? So I guess I'm beginning to get this now. Believe it or not arcusd, you have been a great help. If you want the points I promised, come back with an answer and I will give them to you. I appreciate your time.
ahammar
Well, I tried it again and it seems to work fine now. I don't know why it didn't before. Last time I tried it I added a lot more libraries then the ones you mentioned because I wasn't sure which ones to use. This time I just added the Microsoft DAO or ADO Library ( I don't remember which now) like you mentioned and it worked fine. Maybe I had to many before. Is that possible? So I guess I'm beginning to get this now. Believe it or not arcusd, you have been a great help. If you want the points I promised, come back with an answer and I will give them to you. I appreciate your time.
ahammar
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again!
ahammar
ahammar
a sense that you create database objects in there as well as the user interface. Treat VB
as a tool that lets you design user interfaces and access an existing database and leave the creation of the database to your database software.
1. VB can create any database as long as the drivers that comes with it (the database)
permits it.
2. In my opinion, the best is that let your database tools do the database creation,table creation. Then design and develop the UI in VB.
3. Access will be the best if your are using a Stand Alone PC. Create your database
in Access and VB can read and write to that database. When it comes to network,
the best database engine will depend on the number of users and the the kind of data
that will be stored in the db.
4. VB does not have a native db but Access is considered as its native db. As I stated in
1 VB can create databases and its objects as long the drivers that comes with it permits its. TO try creating an Access DB in VB code. From your Project menu choose References and look for the Microsoft DAO library or ADO Library then all the available
commands for database creation is now available to your project.
Hope this things shed some light...