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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How Do I Connect to a lotus Approach File
- Thread starter dwilko
- Start date
Approach doesn't have its own proprietory database format. It can connect to most backends but dBase IV is the default. The .apr file contains connections, views, scripts etc. If using dBase format there should be separate .dbf, .dbf and .adx files containing data, memo fields and indexes respectively.
If using dBase IV you can connect to the tables using the MS ODBC driver. Only problem is that Approach uses a proprietory index format (.adx files) so you may only be able to open the table exclusively for write access or maybe read-only if the driver requires the table to have a primary key. The ODBC driver will expect to find a dBase index (.mdx or .ndx). Write operations from VB are always problematical because they don't update the adx files and screw things up for Approach users.
Approach is also an ActiveX server and it may be better to automate it and access the data through the Approach object model.
Please explain exactly what you want to do and I'll advise the best strategy.
Paul Bent
Northwind IT Systems
If using dBase IV you can connect to the tables using the MS ODBC driver. Only problem is that Approach uses a proprietory index format (.adx files) so you may only be able to open the table exclusively for write access or maybe read-only if the driver requires the table to have a primary key. The ODBC driver will expect to find a dBase index (.mdx or .ndx). Write operations from VB are always problematical because they don't update the adx files and screw things up for Approach users.
Approach is also an ActiveX server and it may be better to automate it and access the data through the Approach object model.
Please explain exactly what you want to do and I'll advise the best strategy.
Paul Bent
Northwind IT Systems
- Status
Similar threads
- Locked
- Question
