-
I've set up an Access db on my other machine (networked) in ODBC (with the name AccessDB), and succesfully queried using Query in Excel.
Can I query it in VB using the Data object, and if so can someone sort of explain how I access everything like? (how's that for a broad question?)
Yeralbeautiful
-
database
Ok here is how database works in VB. I am using VB 5.0, so it might be different for u.
u know how u got tables, dynasets, and snapshots right.
well all u need to do is make sure that when u have to data control on your form that u have the access to the needed file on that computer.
click on the data control and go to the properties. u will find a databasename, connect, recordsettype, and recordsource properties. u choose what kind of db u are connecting to, u said access. u select the file in databasename. u tell it whether or not it is a table or dynaset. u tell it what your source of information is using recordsource.
now in VB 6.0 it is different. they actually have a control called DB? can't remember right now. but it will allow u to actually build quieries and even use SQL statements.
Now do u want to just display the information or create a form for people to enter new information and edit records?