Hi,I recently 'upgraded' to the Office 2007 suite and I was trying to update a VB6.0 db program to handle tables in Access2007. At one point the code sets an object variable:
Set mdb1 = GetObject(fileToOpen)
fileToOpen is the full path to an Access file, whether in the old .mdb or the new .accdb format. Anyway, when that statement is executed, Access opens. Access 2002 didn't open at all but I was able to get a list of tables, select one and access its data. If I leave Access open the program executes and when the program finishes, Access closes also.
My question is what do I need to do to keep Access from opening or becoming visible? Its not a big deal but it is kind of annoying.