You can use the NewAccessProject method to create and open a new Microsoft Access project (.adp) as the current Access project in the Microsoft Access window.
Syntax
object.NewAccessProject projname [, connection]
The NewAccessProject method has the following arguments.
| Argument | Description |
|---|---|
| object | The Application object. |
| projname | A string expression that is the name of the new Access project, including the path name and the file name extension. If your network supports it, you can also specify a network path in the following form:
\\Server\Share\Folder\Filename.adp |
| connection | A string expression that's the valid connection string for the Access project. See the ADO ConnectionString property for details about this string. |
Remarks
The NewAccessProject method enables you to create a new Access project from within Microsoft Access or another application through Automation, formally called OLE Automation. For example, you can use the NewAccessProject method from Microsoft Excel to create a new Access project in the Access window. Once you have created an instance of Microsoft Access from another application, you must also create a new Access project. This Access project opens in the Microsoft Access window.
If the Access project identified by projname already exists, an error occurs.
The new Access project is opened under the Admin user account.
Note To open an Access database (.mdb), use the NewCurrentDatabase method of the Application object.