The conversion of SQLite to Access database conversion using Full Convert is simple and has to do a few quick steps:
Click the Create new conversion link or click the New button in the ribbon above.
We will choose SQLite from the list of available source database engines. SQL Azure is a cloud version of SQL Server.
You will need to use your server URL in the Server field, and the rest is standard (username, password, database name).
List on the left shows all the databases which can be filled with your source database data. Select the one you need and fill-in required parameters.
We will choose Access database from the list of available source database formats and fill in connection properties. You can simply click ellipsis (...) button to select MDB or ACCDB database file. It depends on the version of your database. Access 2007 databases are contained in ACCDB files, while earlier versions are contained in MDB files.
If your Access database is protected, fill-in your password as well.
In case you use Access workgroups and security, you will need to also find your system database and specify username/password for it.
Click the Convert! button to get started.
If there were any warnings or errors during conversion, you will be able to examine them in detail.
This small tutorial shows how easy it is to convert SQLite to Access using Full Convert Enterprise.