"We have been very pleased with the competent, prompt and courteous service they have provided to us."Stu Perlman
ADO (ActiveX Data Objects) is a language-neutral object model that expose data raised by an underlying OLE DB Provider. The most commonly used OLE DB Provider is the OLE DB Provider for ODBC Drivers, which exposes ODBC Data sources to ADO. In other words, ADO is a programming interface that allows you to communicate with data objects in your database using VBA code. This type of interaction can be very powerful and provide you some great flexibility in your Access Database. In order to use ADO, you must set a reference to it in your Access Application. The screen show below shows a project that has a properly setup reference to ADO:
After setting the reference, you can than use the ADO objects to interact with Data in your database and other databases depending on your connection setting. Note, the sample code below is just a sample and will not work in your Application unless certain changes are made to work specifically with your data objects.
The Microsoft Access ADO Database is a sample database that shows you a number of ways to use the the above function.
Please note that this is a template database. If it doesn't meet your needs 100% and you're unable to customize it yourself, let us know and we'll provide a quote to develop the customizations you need to get you exactly what you want in your ADO System.
The full version of the database is a standard Access Database file. You will have full access to the database window, all design objects, the visual basic project code and you will be able to modify or add to the design in any way that you wish. If you lack the time to integrate this database into your system, please Contact Us and we'll be glad to help. If you like the basics of what you see, but need enhancements to make the system functional for you, please Contact Us and we'll develop a quote for you to implement the additional features and enhancements that you need.
Once your purchase is complete - you will receive an email with a link to download the full version of the database.
If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft Access Development needs.
Click Here to learn more about the WSI quoting process.