ATTENTION

#1 12-05-2011

Hi,

first time trying to read/write data to tables on an Access database and i'm not having much luck... what are the steps to do this?.

regards

Pablo Concha

#2 12-05-2011

Basically the steps are:

1. Create an ODBC Connection (eg MyDB )to your database, selecting the right driver.
2. Create that ODBC name in your dbopen statement (eg. dbopen( MyDB, "SELECT * FROM MYTABLE", 0, 0) )
3. Then use the dbgettablenum and dbgettablestr commands to retrieve your data
4. Use dbsql to make new or update queries

Maybe you can describe the steps you have tried?

#3 12-06-2011

Thanks Steven... i was missing something when creating the connection... now is working.

regards

Pablo Concha

Thread	Thread Starter	Forum	Replies	Last Post
Access to PC-Speaker from Flexsim	Eike Schulz	Q&A	3	06-15-2011 12:51 PM
Modifying Access MDB files… without Access (and free)	Jorge Toucet	Tips and Tricks	1	11-21-2008 05:13 AM
Sample Access Database	Brandon Peterson	Tips and Tricks	1	07-09-2008 12:15 PM
Problem with Flexsim 4.1 and Access DB	Martin Saler	Q&A	0	04-03-2008 05:16 AM
Access to the tree variables	Iulian Marin Ion	Q&A	2	02-06-2008 09:15 AM

The Following User Says Thank You to Steven Hamoen For This Useful Post:
Pablo Concha (12-06-2011)