Hi, I tried your code and it works great. Just one problem tho, I can't delete rows from a table. It says its not supported by the ISAM. I find this wierd as I can INSERT, and UPDATE, but not DELETE. THis is very annoying as this is a very important operation. Is there something I am missing?
Do I have to buy some professional edition of the drivers or code for this to work?
I need to optimize an application written in Access v2.0 which accesses data from DBaseIV tables. Currently, I am linking to the tables using DAO OpenDatase. What is the most efficient method for accessing data from external tables using Access v2.0?
I have an excel.xlt file that I use as a report for my
application ( user interfacewriten in VB6)
All I need is to fill the spread with data from within the application(without user interaction ) and show the user a prevuwe before printing.
My problem is that my app. and the database will be distributed among many users and not all of them have MSOffice/Excel installed on the computer.
So when my program runs it can not even create Excel.object
to open the file.
Is it posible to find something like a runtime version of excel similar to runtime Access that will alow me to open
my file on machine level(invisible to user) , fill the ranges with data and print to a printer.
P.S It is not very important for user to see the preview of the report but it is very very important to print it.