logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA
Irish Culture
Home Finance


dailyclick
All times in EST

Full Schedule
g
g ASP Site

BellaOnline's ASP Editor

g

Using Microsoft Access with SQL Server

Guest Author - Lisa Shea

If you're designing ASP pages to work with a SQL database, you need some way to create and maintain the tables of data. Microsoft Access lets you do that easily.

First off, make sure you get your hands on Access XP or 2000 or above. The older versions of Access weren't really designing to handle the level of SQL web work that goes on nowadays and made this sort of maintenance VERY difficult if not nearly impossible. Also make sure you've upgraded to SP2 to be able to use the SQL tools.

Launch Access and set up a new PROJECT. While a "database" in Access would let you link to (and view) content in your SQL database, by setting up a project you can actually create, edit and delete tables in your SQL Server database.

Put in the information provided by your hosting company about the IP address, username and password for this database. Choose the actual database name from the list provided. You now have a direct connection to that SQL Server database.

The easiest way to create tables is by importing the text file of data. You can export the data from any old system you were using or create a text file from scratch. Have the top row contain the field names. Tabs are usually the best delimiters (field separators) because data often has single or double quotes in it. The sequence of events would then be -

File
Get external data
import
delimited
row field names
new table (name)

that's it! The data imports, you have a table with good field names, and you can start writing ASP code to use that table!

Introduction to ASP Ebook

Download this ebook to get everything you need to know about learning ASP - from a step by step tutorial to function lists, sample code, common errors and solutions, and much more! 101 pages.
This site needs an editor - click to learn more!

Add Using+Microsoft+Access+with+SQL+Server to Twitter Add Using+Microsoft+Access+with+SQL+Server to Facebook Add Using+Microsoft+Access+with+SQL+Server to MySpace Add Using+Microsoft+Access+with+SQL+Server to Del.icio.us Digg Using+Microsoft+Access+with+SQL+Server Add Using+Microsoft+Access+with+SQL+Server to Yahoo My Web Add Using+Microsoft+Access+with+SQL+Server to Google Bookmarks Add Using+Microsoft+Access+with+SQL+Server to Stumbleupon Add Using+Microsoft+Access+with+SQL+Server to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the ASP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Lisa Shea. All rights reserved.
This content was written by Lisa Shea. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.

g


g features
Best uses for RSS

RSS and its future.

Force Download Dialog box with ASP

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor