|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/mguerinweb/DBAdmin/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html><head>
<title>StP Database Administrator for MS Access Readme</title>
<META http-equiv=Content-Type content="text/html; charset=windows-1250">
<meta content=JavaScript name=vs_defaultClientScript>
<meta content=http://schemas.microsoft.com/intellisense/ie5 name=vs_targetSchema>
<meta content="Microsoft Visual Studio.NET 7.0" name=GENERATOR>
<meta content=VisualStudio.HTML name=ProgId>
<meta content="Microsoft Visual Studio.NET 7.0" name=Originator>
<style type=text/css> A { COLOR: blue; TEXT-DECORATION: none }
A:hover { COLOR: red; TEXT-DECORATION: underline }
BODY{background-color: white; font-family: Verdana; font-size: 10pt}
H1,H2,H3,H4,H5{font-family: 'Times New Roman'}
</style>
</head>
<body text=black vLink=blue link=blue bgColor=white
MS_POSITIONING="FlowLayout">
<H1>StP Database Administrator for MS Access
version 2.0.2 Readme</H1>
<H3>Table of contents</H3>
<ul>
<li><a href="#Overview">Overview</a>
<li><a href="#Features">Features</a>
<li><a href="#Requirements">Requirements</a>
<li><a href="#new">What's new</a>
<li><a href="#Installation">Installation</a>
<li><a href="#Upgrade">Upgrade from previous version</a>
<li><a href="#FAQ">Frequently Asked Questions</a> (FAQ)
<li><a href="#Licensing">Licensing and pricing</a>
<li><a href="#Contact">Contact information</a></li></ul>
<h3><a name="Overview"></a>Overview</h3>
<P>StP Database Administrator (DBAdmin below) is a
tool that allows you to manage your MS Access databases through your browser,
providing various set of functions you can perform with your databases, without
having downloading them, changing and uploading again. Most of features needed
for database management are included, you can even create a new blank databases
on-line.</P>
<h3><a name="Features"></a>Features:</h3>
<ul>
<li>View tables in your database
<li>Creating/modifying/deleting tables, data in tables,
stored procedures, views and relations (foreign keys) between tables
<li>Cycling through records in table, modifying/adding
data if needed.
<li>Editing extended properties of fields(columns) in
table, like description, default value, etc.
<li>Generates SQL statement for each table with syntax
highlighting.
<li>Creating/modifying/deleting indexes
<li>Executing views and stored procedures
<li>Provides human-readable description of each relation
between tables
<li>Free-Type Query allows running your own SQL queries (single or
multiple, separated with semicolon).
<li>When executing multiple queries at once you have an option to rollback
(using transactions) if one of them fails, or continue regardless any
errors.
<li>Compact and repair database
<li>Creating back up copy of your database and restoring from backup
<li>Exporting your database structure in form of SQL statements.
<li>Setting/changing/removing database password.
<li>Saves database paths for quick access later (doesn't save database
passwords though).
<li>XML and Excel (text-delimited) data export.
<li>Browsing for your database, so you do not need to type the path by
yourself
<li>Checking for a new version in one click.</li></ul>
<H3><a name="Requirements"></a>Requirements</H3>
<ul>
<LI>ASP enabled web server (such as IIS or PWS) -
<strong><em>required</em></strong>
<li>Sessions enabled on your web server -
<strong><em>required</em></strong>
<LI>Any Mozilla-compatible web browser: MS Internet
Explorer 5.x or higher, Netscape 6.x or higher, Opera, Mozilla -
<strong><em>required</em></strong>
<LI>Write permissions on the web server -
<strong><em>optional</em></strong>
<li>MSXML parser version 3.x or higher installed on the server -
<strong><em>optional</em></strong></li></ul>
<h3><a name="new"></a>What's new in
version 2.0.2</h3>
<p>
Only bugs fixes included in this release. Here is the list:</p>
<ul>
<li>Bug fix - Javascript error on Settings page.
<li>Bug fix - Application hangs when trying to view data of a table with no
columns
<li>Bug fix - Not able to open a database if folder has no write permissions.
<li>Bug fix - Unable to edit text fields with double quote (") in the data.
<li>Bug fix - Database can be removed from the saved list only when
another one is opened </li></ul>
<p>For the full versions history, see <A href="history.htm" >History.htm</A> file.</p>
<H3><a name="Installation"></a>Installation</H3>
<P>Below are steps that you should perform to successfully
install DBAdmin.</P>
<ol>
<li>Double click on the downloaded archive file and
choose a directory where all unzipped files should be placed. This directory
is temporary and can be safely removed after installation.
<li>Open file "scripts\inc_config.asp" in any text editor
such as Notepad and find the line:<br><font color=green
>Const DBA_cfgAdminPassword = "<strong
>admin</strong>"</font><br>This is
your password as administrator. You should change it to your own, so just
replace "admin" with your new password.
<li>Optional - DBAdmin uses Session object to store some
settings and transfer them from page to page. If you want to change those
Session variables names, you can do this in same "scripts\inc_config.asp" file
- see remarks inside it.
<li>Optional - If you want to use XML file to store your configuration and
database paths, you should update the value of <font
color="green">DBA_cfgProfilePath</font>
in the same file, and set it to a virtual path to XML
file. Note that the folder where this file will reside MUST be
created and has write access.
<li>Now save configuration file, create some directory on
your Web server (for example "dbadmin") and upload all files, including
subfolders into it.
<li> Configuration is done. Open your browser and
navigate to DBAdmin main page ("default.asp").</li></ol>
<H3><a name="Upgrade"></a> Upgrade from version 1.x</H3>
<P> You should remove any previous version installed on
your server and upload the new one as is (after changes described in Installation
section).</P>
<h3>Upgrade from version 2.x</h3>
<p>Just upload all files to your server, but <strong>keep</strong> your
<strong>configuration</strong> file (scripts/inc_config.asp), to save your current
settings.</p>
<H3><A name=faq></A><a
name="FAQ"></a>FAQ</H3>
<ul>
<LI><A name=a1_a2></A><A name=a3></A><font color=red
><b>Cannot create a blank
database</b></font><br>Make sure you that the folder in
which you are trying to create a new database has write permissions. Usually
there is always at least one folder that has it - a folder where your hosting
provider lets you to place your MS Access databases <br>
<LI><A name=a4></A><font color=red
><b>I got an error "TypeLib not
found" in inc_protect.asp</b></font><br>A type library for ADO is
not registered on your server, so you cannot use METADATA tag to specify it.
Usually it happens on Windows 98 machines, but fortunately can be solved
easy. Open the file "scripts\inc_config.asp" in any text editor
(such as Notepad) and find the line below: <br><font color="green"><!--
METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4"
--></font> <br>This should be the last line in this file. Delete it and
instead type this text:<br><font color="green"><!--#include file=adovbs.inc
--></font><br>
This
fix should solve
the problem of ADOType library
<br>
<LI><A name=a5></A><FONT color=red><STRONG
>I can't see Views created with Database Administrator in
MS Access.</STRONG></FONT><BR>
MS Access doesn't support Views, only Stored Procedures
(named Queries in MS Access) can be created and changed. Stp Database
Administrator, which uses ADO, has full support for both Stored
Procedures and Views. But if you want to be able to see your Views in MS
Access later, always create them as Stored Procedures. <br>
<li><font color="red"><strong>I got error saying: "Cannot update. Database or
Object is read-only".</strong></font><br>This error usually says that the
folder where you put your database has no write permissions. If you got this
error on your server, you should contact your hosting provider and ask which
folder is designed for MS Access databases and place all your databases there
(as well as DBAdmin configuration file). If the error occurs on your home
computer, you should edit permissions of the folder and add
IUSR_<em>ComputerName</em> (or Internet Guest Account) with write
permissions.<br>
<li><strong><font color="red">How to adjust permissions of the
folder?<br></font></strong>Follow the link to Microsoft's Knowledge Base: <a
title="How to change folder permissions on Windows XP"
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;308418"
target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;308418</a>
(applies also to Windows 2000/NT).<br></li></ul>
<h3><a name="Licensing"></a>Licensing and pricing</h3>
<p>DBAdmin is a free tool for any web-master for personal
use only. Commercial use requires you to buy it. E.g. if you have an e-commerce
web site, or you are selling from your site and DBAdmin in any way helps you
(customers info stored in database, products, etc.), then you are a commercial
user. Commercial license is given per site (or domain if not points to same
site), regardless how many users are using it, or how many databases you have.
For latest prices, please visit <a href="http://www.stpworks.com/redir.asp?linkid=2" target=_blank>DBAdmin home page</a>. There are several options available but you can contact
me if you need a special offer.</p>
<H3><a name="Contact"></a>Contact information</H3>
<P>If you have any problems, questions, suggestions, feel free to either post in
the <A href="http://www.stpworks.com/redir.asp?linkid=4" title="StpWorks.com Forum" target="_blank">
StpWorks.com forum</A> or write directly to my e-mail: <A href="mailto:[email protected]?subject=StpDatabase Administrator question">
[email protected]</A>. Make sure to check for updates, using the link in
Database Administrator.</P>
<P><strong><em>Philip Patrick</em></strong>, <em>creator of
Stp Database Administrator.</em></P>
</body></html>