Convert accdb file to open office

However, you code should run the same. If its not, that means you haven't put enough error trapping in your code to be able to tell where the problems lie. So you need to go back to your code and do so.

How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to boblarson's post on April 16, It is on my own computer. Are there any ways to set as "Trusted Location"? My code might be blocked by that setting. I saw such pop up windows a couple of times, but I do not know how to set it.

In reply to melhzy's post on April 16, Open Access to your accdb. Then go to the Backstage File and select Options. Go to the Trust Center and you can can set Trusted Locations. If an Access app is not in a trusted Location it may not run properly.

In reply to Scottgem's post on April 16, Hi Scottgem, Thanks anyway. I find the problem by myself. Daniel Pineault MVP. In reply to melhzy's post on April 18, In reply to Daniel Pineault's post on April 18, Hi all Click Yes to make Access close the objects, or click No to cancel the entire process. If needed, Access will also prompt you to save any changes.

In the Save As dialog box, type a file name in the File name box, and then click Save. Access creates the copy of the database, and then opens the copy. Access automatically closes the original database.

However, you can open an Access 97 database in a previous version of Access, and then save the database in a format that Access can open. You can also use Access or Access to convert an Access 97 database to the. When you open an Access 97 database in either of these two products, the Database Enhancement wizard appears to help convert the database to an.

Because Access , Access , Access , and Access all use the same file format, you can use Access to open a database that was created in Access , Access , or Access without first using the Save As command. However, Access , Access , and Access include some features that require Access , Access , and Access to run.

Depending on the feature, one of the following might happen when you try to use the database in Access Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. If you use an existing database in the Access 2. To import forms and reports that contain VBA code and also modules , first convert your Access 2.

You can then use a more current version such as Access to convert that file to the. Access was the last version to support opening, importing, linking or exporting to Access 2.

You will need Access in order to be able to export, import or link data from Access 1. In this case, you'll have to use Access as an intermediary step to fully convert an Access 2. Open an Access 2. Import data from an Access 2. Import data from an Access 95 database into Access Convert an Access 2. When you open an Access 2. You can import tables, queries, and macros from an Access 2. To import forms, reports, or modules into an Access database, you first convert the database by using an earlier version of Access, then open the converted database by using Access , and then convert the database into an Access See the section Convert an Access 2.

When you import objects from another database, copies of the objects that you import are created in the destination database. The source is not altered. To import data from an Access 2. You then use commands on the External Data tab to proceed with the import process, which includes invoking the Import Wizard.

In the Open dialog box, select and open the database that you want to import the tables, queries, or macros into. On the External Data tab, in the Import group, click Access. In the File name text box of the Get External Data Wizard, type the name of the source database, or click Browse to display the File Open dialog box and then choose or type the name of the source database.

Click Import tables, queries, forms, reports, macros, and modules into the current database , and then click OK. In the Import Objects dialog box, click each tab and select the objects that you want. Remember that you can only import tables, queries, and macros from an Access 2. Imports any custom menus and toolbars that exist in the source database. The menus and toolbars are displayed on a tab named Add-Ins. Imports the selected queries as queries. In this case, remember to import all the underlying tables along with the queries.

Access copies the data and displays error messages if it encounters any problems. If the operation succeeds in importing the data, the final page of the wizard allows you to save the details of the operation as an import specification for future use.