Convert MS SQL DB to MS Access DB

Print this Topic  Previous Topic Home Topic Next Topic
You are here: Globodox DB > Convert DB >Convert MS SQL DB to MS Access DB

You do not need MS Access installed on your machine to work with Globodox and to create or open a MS Access based Globodox DB. Globodox installs all the files required to do this.
 

To Convert MS SQL DB to MS Access DB

1.Make sure no users are logged on to Globodox.
2.Login as superadmin, from Globodox desktop client.
3.Select Settings > System Settings > DB List in the Navigation pane. The DB List tab will now be displayed on the Ribbon bar.
4.From the DB List pane i.e. the right pane select the DB that you want configure for multi-user environment.
5.Click the Convert DB option on the DB List tab. The Convert DB window will now be launched.
6.You can change the name for the DB from the New DB Name box.
7.Select MS Access option from the New DB Type drop down. The MS Access - Settings window will now be launched.
8.The default location of the DB's File Store (folder) will be displayed in the Choose or type in the DB location box. You can change the File Store location by clicking the Browse button.
9.Click the Convert button to convert the MS SQL DB to an MS Access DB.

 

Notes:

For MS Access DB: By default all Globodox Databases and its File Stores are stored in the C:\Globodox Databases folder. File Store is a normal Windows folder which is located inside a folder with the same name as the name of its related DB.
For MS SQL SERVER: By default all Globodox Databases are are stored in the SQL Server Management Studio. File Store is a normal Windows folder which is located inside a folder with the same name as the name of its related DB.
For MySQL: By default all Globodox Databases are stored in the My SQL Administrator. File Store is a normal Windows folder which is located inside a folder with the same name as the name of its related DB.

 


Related Topics

Configure Globodox DB for multi-machine environment

Convert a MS Access DB to a MS SQL DB
Convert MS SQL DB to My SQL DB
 

 


Page URL: http://www.itaz.com/globodox/help/index.htm?convert_mssql_db_to_ms_access.htm