Hi,
I'm using a access DB (v 2003) which has a front end driven by forms. The application takes an excel sheet to import data into the tables and does some processing to generate various reports. Application uses a form which calls a browse dialog for the user to choose his excel sheet to load data.
Problem is, the users at onsite cannot have msaccess installed in their locations as they are client machines.
Suggestion is to use the msaccess runtime. I'm having couple of questions here :
. I tried installing a runtime that was avlbl in a blog. I was able to open my mdb successfully but when i try to click on "browse" button to select the excel sheet for my application, i get a runtime error and application abruptly shuts down. I'm using Application.FileDialog code for the browse window to open.
. Is msaccess 2003 runtime avlbl free download? if so pls provide link
. Will my access db created in 2003 work with msaccess 2007 runtime?
Any help here is appreciated
Thanx in advance