Accessing an Access MDB file via ADO without Access installed
-
Hi, I am trying to put together what needs to be distributed as part of the install software. I am wondering if customers who use our program that accesses MDB files via ADO needs to have MS Access purchased installed on their machine or not? If they do need to have MS Access installed to use our program, then that would severely limit the customers that we could sell the software to since many of them don't have MS Access. Also, what happens if the user does have MS Access but has a different version from the one that we distribute (e.g. they have MS Access 97 and we distribute a MS Access 2000 MDB). Is the only sol'n to that is to either distribute different versions of MS Access depending on what they have installed, or have ADO recreate the database? Thanks for any help!