Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

If I already have an application written for the Jet engine, what would I need to do to replace the Jet databases with an Oterro database? What about the bound controls?

April 26, 2017application bound controls database databases engine jet oterro replace written

0

Posted

If I already have an application written for the Jet engine, what would I need to do to replace the Jet databases with an Oterro database? What about the bound controls?

1 Answer

0

Posted

All you should need to do if you are accessing a database through an ODBC connection is to replace the database name in the connect string. When using DAO or RDO controls, you would replace the database name with an ODBC connection to the Oterro database. So long as the table and field names remain the same, you should not need to change any of the properties of the bound controls. There may be other code changes if you are using DAO functions that are specific to an Access/Jet database.