Creating a New Microsoft Access Database

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  User Guide and Reference > Databases > Connecting to a Database > Setting up an ADO Connection >

Creating a New Microsoft Access Database

As an alternative to connecting to an existing database file, you can create a new Microsoft Access database file (.accdb, .mdb) and connect to it, even if Microsoft Access is not installed on the computer. The database file created by XMLSpy is empty. To create the required database structure, use Microsoft Access or a tool such as DatabaseSpy ( https://www.altova.com/databasespy ).

 

 

To create a new Microsoft Access database:

1.Run the database connection wizard (see Starting the Database Connection Wizard).
2.Select Microsoft Access (ADO), and then click Next.

access_create_new

3.Select Create a new MS Access database, and then enter the path (either relative or absolute) of the database file to be created (for example, c:\users\public\products.mdb). Alternatively, click Browse to select a folder, type the name of the database file in the "File name" text box (for example, products.mdb), and click Save.

Notes

Make sure that you have write permissions to the folder where you want to create the database file.
The database file name must have the .mdb or .accdb extension.
4.Click Connect.

© 2019 Altova GmbH