Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Store a data table

Status
Not open for further replies.

easycode

Programmer
Jan 28, 2005
195
US
i am newbie in vb, i have experience with ms access vba

i wonder if i can store a data table in vb as i do in ms access, in other words can vb work as a front and back end, or do i have to use another database engine as a back end.

Thank you
 
No, you'd use ADO to latch onto a data source, such as Access. ADO and data sources id a whole topic in itself; you might want to check out ADO on MSDN.

You can also read/write flat files natively or with FSO (file systems object.)

There are many ways to go, but no built-in db.
 
You create front-ends with VB and connect to whatever database you choose to use, which among other things could be an MDB file.

Although you can use data controls for data-binding similar to what you find in Access forms, most professional programmers tend not to use them due to their inherent inflexibility and inefficiency.


 
>can vb work as a front and back end

Well, sort of. Yes and no. You can use xml files for the back end. You might want to look into disconnected recordsets and the .Save method.

HTH

Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top