VBS to open Access 07 (1 Viewer)

[JuniorWoodchuck24]

I've typed some code in to have a VBS document find my database and then open it. Only problem I have is that when Access opens it isn't maximized. How would I maximize Access itself, not the db's opening form.

Current code:
dim accessApp
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase("My path\MyDB.mde")

 

[vbaInet]

accessApp.runcommand accmddocmaximize

But are you doing any automation? Will Application.FollowHyperlink not be sufficient?

 

[JuniorWoodchuck24]

Yah just went ahead and made a hyperlink at the moment. Was trying to figure out some stuff because in near future probably going to write .bat file that finds the .mde file on the network copies it and pastes it to the users hard drive (if it exists it paste it over). This way I can just dump the new version on the network and the user clicks the .bat file and it gives them the latest version of the database.

 

[vbaInet]

Alright got you.

Glad you got that sorted.