Home Evaluation Summary for programmers Product limitations Goals of Axisbase Quick start Installation Using the launchpad and opening databases Connecting to a sample database Using building blocks Planning Define the purpose Define the requirements Borrow existing work Determine the architecture Design the data model Design the process model Deploy and maintain the product
building blocksPerforming a mailmerge Bulk e-mailing
ProgrammingSingle-threaded progress indicator in c#
Database menu itemsImport XML Save Copy As Integrity Check Change Password
Database Properties windowOpening the database properties window Record types tab Display types tab Roles and Users tabs Sidebar tab Database ID/Links tab Counters tab
Building blocksBuilding blocks window Editing grids and cells Hyperlinks and nesting Data Subset window Data Outsource window List window Window window Report window Bulk Operation window Label Printer window Choosing a data source
Special topicsExpression syntax Browse records Storing building blocks within other building blocks Programming Using custom code in building blocks Using Axisbase as an embedded database Axis1.Util namespace reference Axis1.Data namespace reference (Fishnets) Axis1.Data namespace reference (other) Axis1.Forms namespace reference
Using the launchpad and opening databases
Use this page to learn how to open server and local databases, how to use the various windows in Axisbase, what is an Axis ID, and how password security works.
Depictions of different ways to open a database
A client/server application is one that involves two software programs: the server software is the unattended background process that usually runs on a server computer. (The term "server" can refer to both hardware and software.) The client software is the program you use on a workstation that displays windows.
Single-computer scenario: single-user
Scenario of opening a file over a local network: In this case, you access the file on a company server by a share name such as "\\serv1\data\myfile.axis1", or a mapped drive letter, such as "Z:\myfile.axis1". Only one workstation can open the file at a time.
Server scenario: In this case, one computer acts as a database server, and the workstations connect to the server process, instead of directly to the file. Any number of workstations can connect at the same time.
When you choose Axisbase from the Windows Start menu, it opens the launchpad, shown here:
The main purpose of the launchpad is to remember recent files and connections that you have opened, and allow you to create and open new files, and make new connections. It also controls the database server (see below).
Click once on any recent file or connection to re-open it.
Click "Open Database File" to open a file in single user mode.
Click "Connect to Server" to open a connection in multi-user mode.
Passwords and security
A user name and password are only required in multi-user mode. When you have access to open a file through the file system, the file is considered yours and no limits are imposed. Therefore, if you want to secure a database file, it must be placed in a directory that only the database adminsitrator has permission to access. Access permissions are controlled by Windows, not by Axisbase. You can set permissions from the Properties window of a Folder. (right-click on the folder in Windows Explorer.)
The user name "super" automatically has full rights to a database, so you should guard the password for that user.
If you ever lose the super password, you can stop serving the database, open the database as a file, and reset the password. (See the how-to section for more information on setting up security roles and users.)
Walkthrough: Connecting to a sample server on Axisbase.comPlease see Connecting to a sample database.
Walkthrough: Setting up a server
Connections through the internet are initiated by two pieces of information: the host (a computer), and the port. The port is a number used to distinguish multiple network services on the same host. The default Axisbase 1 port number is 3569. To minimize confusion, you should use that port number unless it is already used for another service.
Here are the steps to serve a database file on one computer (the server) and then access it from another (the workstation). We assume you already have an Axisbase file that you want to serve.
1. Open the file you intend to serve as a file. Open the database properties window (F7), and select the Users tab. Create the user "super" if it isn't there, and set its password to "super". To do this, choose New Row from the List menu, enter the new row, then choose Commit Changes from the Changes menu. Close the file.
2. Move the file to the server's hard drive. You may want to create a folder such as c:\data to contain database files.
3. Go to the server and open the Axisbase launchpad, then open the Axisbase Server section of the window. If the server isn't installed, press Install; if it is stopped (installed but not running now), press Start. When you are done, it should look like this:
4. Click on "Connect to configuration database..." to open the server configuration. If this is the first time you have opened the file, the factory user name is "super" and the factory password is "super". It will then ask you to change the password to something else.
5. Notice the Axis ID of the configuration database is AXIS. Open the Control Panel window window, which will look something like this. (Actually the graphic is a pre-release version so yours may look different.)
6. Under "Files to serve", enter a new record for the database file that you copied to the server in step 2. In the List menu, choose New Row, then enter the AxisID and file path like the example shown here. When done entering, choose Commit Changes from the Changes menu. Within a minute after committing the change, the Axisbase server will start serving your database file.
7. Go to a workstation, and run Axisbase from there. In the Tasks section, click on "Connect to Server". You should see this window:
8. Enter the three pieces of information Axisbase needs to connect to the server.
Press Connect and you should see the login sequence, then (assuming you remembered the password!) you will see your database file just as if you opened it directly as a file.
Command lineIf you need to invoke Axisbase from the Windows command prompt, use this syntax.