Create a VB database

[Sherly25]

Hello Everyone!!
I have 10 Access Databases and I just realized I will have to convert them to VB. However, doing so could be harder than starting from Scratch...(or so I've heard)...Therefore, I want ot get a general idea as of how do I create a database in VB?

If someone could provide me with source code for a database previously created I would be very very grateful. Thank you Vey much...

gaf

 

[TomKane]

VB wouldn't be a database system in itself but it would be used to connect to access or sql server (or whatever) database systems.

You could use VB to access your existing databases or you may decide to consolidate your databases into one before bringing VB into the mix.

Depending on volume of data and number of users you may find that access might not be the best option.

You can create datbases and tables in access or sql server (or whatever) from VB.

 

[CCLINT]

If you are talking about converting the Forms and Reports, you will have a little work cut out for yourself...at least for the forms.

 

[Sherly25]

Ok, let me clarify my request. What I need help with is:
Writing a program so that people on other computers (without Microsoft Access)can use my forms and databases...is that possible?

 

[CCLINT]

For the database, no problem as TomKane states.
For Reports, you can use the SnaphotViewer.Exe FOC from MS.
Modules can be converted with not too much difficulty.
Forms you will need to create from scratch in VB.

There is another way though. I believe you need the MS Office Developers kit in order to do what you want though ("(without Microsoft Access)can use my forms and databases&quot.