Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


Activating Access 2007?


Activating Access 2007?

Author
Message
macroman
macroman
Forum God
Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)

Group: Forum Members
Posts: 71, Visits: 264
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.

Edited
9/20/2010 by macroman
macroman
macroman
Forum God
Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)

Group: Forum Members
Posts: 71, Visits: 264
Well I did the obvious, I added the line:

mdb1.visible = false

after the getobject statement... Access opens and then disappears fairly quickly. Still not what I was looking for. I'm thinking there may be a setting in Access somewhere, but I haven't had time to search for it.

GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search