Building a site with an Access database

  • pritesh_a
  • Graduate
  • Graduate
  • pritesh_a
  • Posts: 158
  • Loc: South London/UK

Post 3+ Months Ago

Hi,
i want to create a web page linked to a Access database where i can also do searchs via the web site.
i.e - search list of all employees for a particular person by searching via surname....first name....etc....

please can someone help...or does anyone know of and GOOD UP TODATE online TUTORIALS

Thanks
  • marengo
  • Beginner
  • Beginner
  • marengo
  • Posts: 52

Post 3+ Months Ago

F1 --> Beginner’s Guide to Databases

What I have about that (thanks, my school):

1.For Windows : from the Control Panel folder, select ODBC Data Source (32 bit); Windows NT users should choose ODBC. Windows 2000 users should select Data Sources (ODBC) from the Administrative Tools folder. The ODBC Data Source Administrator opens.
2. From the ODBC Data Source Administrator, select the System DSN tab. The System
DSN tab lists all the DSNs previously defined for your system. If you’ve installed
Dreamweaver, you’ll see GlobalCar, used in the Dreamweaver tutorial, in the list.
3. From the System DSN tab, choose Add. The Create New Data Source dialog box opens.
4. Choose the appropriate driver for your data source from the list. The driver for Access
databases, for example, is listed as Microsoft Access Driver (*.mdb); the one for Oracle
databases is shown as Microsoft ODBC for Oracle. Click Finish when you’re ready.
A setup dialog box for the driver selected appears next. Each setup dialog box is
somewhat different.
To use an existing Access database, choose the Select button from the
ODBC Microsoft Access Setup dialog box.
After you’ve created a DSN for your data source, you’re ready to create an ODBC DSN connection
in Dreamweaver. Although the basic procedure is the same for all five server models, the
specific steps are different enough to warrant the individual descriptions presented in the following
sections.

ASP


A DSN connection is often an ASP developer’s first choice for rapid development because
of its easy setup. To establish a DSN connection in Dreamweaver, follow these steps:
1. Choose Window ➪ Databases to display the Databases panel
2. Click the Add (+) button and, from the drop-down list, select Data Source Name (DSN).
The Data Source Name (DSN) dialog box is displayed.
3. If you’re creating a connection on a Testing Server, choose the Dreamweaver Should
Connect Using DSN On Testing Server option; otherwise, choose the Using Local DSN
option. These two options are not available on the Mac, you must always use the
Testing Server.
4. Enter a label for your new connection in the Connection Name field. It’s a good habit
to identify your connections with the prefix conn; for example, you might label your
connection connDBA.
A drop-down list appears
when you click the Add (+) button, enabling
you to select a DSN-type connection.
5. If you’re defining a local DSN connection, select an entry from the Data Source Name
(DSN) drop-down list.
If your DSN has not been previously declared, choose Define to open the ODBC Data
Source Administrator and, as outlined in the previous section, create a new DSN.
When you’re done, the new DSN will appear in the list.
6. If you are defining a DSN connection on the testing server, enter the DSN name in
the field.
To select the DSN from a list of available ones on the Testing Server, choose the DSN
button. Dreamweaver will attempt to connect to the Testing Server and retrieve a list
of assigned DSNs. Select one from this list, if desired.
If your host has not set up his or her security properly, you may see DSNs other than those
for your site. Alert your ISP to this security problem, as it indicates that your data is accessible
by others. A Tech Note on the Dreamweaver support site (http://www.macromedia.com/go/14961) describes steps to take to remedy this problem, which has been reported only on
IIS 4.0 and 5.0 servers.
7. If necessary, enter a user name and password in the appropriate fields.
8. Certain databases, such as those from Oracle, enable you to restrict the number
of database items available from a connection. To limit the available tables, choose
Advanced and enter the desired Schema and/or Catalog.
9. To ensure that your connection is properly set up, choose Test from the Data Source
Name (DSN) dialog box. If the connection is established, Dreamweaver tells you the
connection was successful.
10. Click OK when you’re done to close the Data Source Name (DSN) dialog box. The new
connection is listed in the Connections dialog box.
11. Click Done to close the Connections dialog box.

If you don’t see a driver for your database listed here, you’ll need to get one from the manufacturer
or database sponsor. If you are working with MySQL databases, you can get an ODBC
driver from http://www.mysql.com/downloads/api-myodbc.html.
5. In the setup dialog box, enter the desired Data Source Name and select the data source.
Following are examples of the most commonly used data sources:
• For Access databases, choose Select to locate the database . If a
user name and password are required, select Advanced to enter that information.
• For Excel spreadsheets, choose Select Workbook to locate the proper file.
Select Options to limit the number of rows accessed.
• For SQL Server, select a name from the Server drop-down list. Choose (local)
if your system also acts as the SQL Server. Choose Finish when you are done.
• For MySQL databases, enter the MySQL host name or IP address and the full path
to the MySQL database. A user name and password, if necessary, may be entered
on the same screen. The MySQL ODBC driver also offers a wide range of options
that you may enable.
6. When you’ve closed the setup dialog box, choose OK to close the ODBC Data Source
Administrator.

To create a simple recordset, follow these steps:

1. From either the Bindings panel or the Server Behaviors panel, click the Add (+) button
and choose Recordset (Query) from the drop-down list.
If neither panel is visible, select one of their icons from the Launcher on the status bar
to bring the panel to the front.
2. In the Recordset dialog box, enter an identifying label for your recordset in the Name
field.
It’s good practice to prefix your recordset name with rs—as in rsDBA. This prefix
quickly identifies the recordset in the code.
3. Select a connection from the drop-down list of that name.
4. If the desired connection has not been declared, choose Define to open the Connections
dialog box. After a connection has been selected, the available tables are shown.
5. Select a table to work with from the Tables drop-down list. The chosen table’s fields are
displayed in the Columns list.
6. By default, all of the columns are included in the recordset. To specify certain columns,
choose the Selected option and then choose any desired field. Shift+click to select
contiguous columns, and Ctrl+click (Command+click) to select columns not next to
one another.
7. By default, all of the records in the selected columns will be available. To limit the
recordset further, use the four Filter drop-down lists as follows:
• Choose the field you want to base your filter on from the first drop-down list.
This list changes dynamically according to which table you’ve selected.
• From the second drop-down list, choose the expression you want to compare
with the data from the selected column in the first drop-down list. Available
expressions are =, >, <, >=, <=, <>, begins with, ends with, and
contains. Most of these are obvious except for <>, which means “not equal to”.

• Choose the type of value to compare to the selected field from the third drop-down
list. Available types are as follows: URL Parameter, Form Variable, Cookie, Session
Variable, Application Variable, or Entered Value. (These types are explained in the
following bullet list.)
• Enter the value to compare to the selected field in the fourth input field. Values
entered are not case-sensitive.
8. To sort the data, select a column from the first drop-down list under Sort, and then
choose either Ascending or Descending from the second list.
9. At any time, you can see what results will be returned for the recordset by choosing
Test.
To see how your simple recordset translates into SQL, choose the Advanced button. You can
return to the original dialog box by selecting Simple on the advanced Recordset dialog box.
10. Click OK when you’re done.
Perhaps the most challenging aspect to building a recordset is selecting the proper filter.
Many Web applications rely on the filter mechanism of recordset queries to display the
proper data. The following section describes how each of the different filter types is used:
✦ URL Parameter: URL parameters are arguments added onto the address of a page,
typically by a form using the GET method. For example, the URL http://www.idest.
com/mail_list.asp?email=jblow@anyhoo.com indicates that the e-mail field would
be set to jblow@anyhoo.com. URL parameters are encoded so that no spaces or high
ASCII characters are transmitted directly.
✦ Form Variable: Form variables are passed by forms using the Post method. Let’s say,
for example, a form is submitted in which there is a text field named emailText. Using
the Form Variable type, you could derive a recordset based on the domain of the e-mail
address submitted.
✦ Cookie: A cookie is a small text file placed on the client’s machine, and it may be read
or written to by a Web application. Cookies are often used for authentication. Once a
user has been verified, the stored cookie value may be examined to permit—or deny—
entrance to particular sections of the Web site.
✦ Session Variable: A session variable is similar to a cookie, but it is maintained on the
server side. Session variables are often used to track a visitor’s progress through the
site.
✦ Application Variable: Application variables are maintained throughout the life of an
application. Page counters are good examples of application variables. The life of an
application lasts from the time the Web site starts (because the server was turned
on or the site started) to the time the Web site stops (a server reboot or shutting down
the site service).
✦ Entered Value: The entered value is an absolute value to which the selected field is
compared. If, for example, I wanted to display only the DVDs in my database whose
title started with the letter D, I would choose begins with as an operator, and D as
my entered value.

Hope it helps
  • marengo
  • Beginner
  • Beginner
  • marengo
  • Posts: 52

Post 3+ Months Ago

also if you want to make all without learning try this apps:

http://www.bestcatalog.net/detail2902.html
(trial available)

some more tutors:
http://www.bestcatalog.net/cat_more135201-1.html
  • pritesh_a
  • Graduate
  • Graduate
  • pritesh_a
  • Posts: 158
  • Loc: South London/UK

Post 3+ Months Ago

I am using DW MX to create the layout of the site, throught there i wanted to import the Access database.

on the web page it self...the user can run a search on the database via drop down menus and show the results on the same or new window.
Thats my first step!

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: No registered users and 20 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.