RunApp command line

Topic

New Reply

I am trying to open a database from another database using RunApp. The name of the database I am trying to open is 2 words separated by a space: Example My Data.mdb
Access doesn’t like the space. How do I do this without renaming the database?

Reply | Quote

Replies

Put square brackets around the database name when you reference it in code.

Reply | Quote

Thanks for your reply. I tried this and it doesn’t seem to work. My command line is:C:Program FilesMicrosoft OfficeOfficemsaccess.exe J:[Audit Reports.mdb]; Forms![frmSelectBndAudit#]. If I rename the database to “AuditReports.mdb” it works fine, but this is on a network and being used by others. Am I doing something wrong?

Reply | Quote

The following VBA code seems to work OK with a filename containing spaces.

Call Shell("c:program filesMicrosoft officeofficemsaccess.exe ""d:ianscompaccessCopy of db1.mdb""", vbNormalFocus)

Ian.

Reply | Quote