Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Go Back  Xtreme Visual Basic Talk > > > Frequently Asked DATABASE Questions


Closed Thread
 
Thread Tools Display Modes
  #21  
Old 03-06-2006, 01:08 PM
loquin's Avatar
loquinFrequently Asked DATABASE Questions loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default Database Modelling


I recently ran across an excellent training document at the University of Texas which discusses data modelling and relational design. This document, titled "Introduction to Data Modeling," is a more thorough discussion of these topics than are the database installments in the Standards & Practices Tutorial.
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown

Last edited by loquin; 03-06-2006 at 01:13 PM.
  #22  
Old 04-06-2006, 08:45 AM
loquin's Avatar
loquinFrequently Asked DATABASE Questions loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default

Here's another database article that is useful: Best Practices for Database Design. The author discusses naming conventions and practices for database objects, and why following a structured approach in this area can be helpful.
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
  #23  
Old 04-15-2006, 03:58 AM
Shurik12Frequently Asked DATABASE Questions Shurik12 is offline
Steppe Walker

Retired Moderator
* Expert *
 
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
Default

An article on Multiple ADO recordsets
Quote:
...an ADO feature that's few developers are aware of
http://www.4guysfromrolla.com/webtech/083101-1.shtml
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
  #24  
Old 06-18-2006, 02:29 AM
Shurik12Frequently Asked DATABASE Questions Shurik12 is offline
Steppe Walker

Retired Moderator
* Expert *
 
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
Default

The link shows differrent ways of opening an ADODB recordset:
http://support.microsoft.com/?kbid=168336
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
  #25  
Old 08-02-2006, 03:14 PM
loquin's Avatar
loquinFrequently Asked DATABASE Questions loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default Open Source Database Feature Comparison Matrix

For those interested; Three pages of feature comparisons...
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
  #26  
Old 04-03-2007, 10:53 AM
loquin's Avatar
loquinFrequently Asked DATABASE Questions loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default

__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
  #27  
Old 09-18-2007, 01:27 PM
loquin's Avatar
loquinFrequently Asked DATABASE Questions loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default

A common question we see is "How do I copy the contents of an Excel spreadsheet to an Access database?"

ref Access/Excel - How to copy data from Excel to Access
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
  #28  
Old 09-19-2008, 12:55 PM
loquin's Avatar
loquinFrequently Asked DATABASE Questions loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default

Quote:
I KNOW that I should normalize my database, but, I just can't get my brain around it. Do you have any examples that I could look at???
Well, I don't, but, these guys do. They're designed for specific, real-world applications. Many are available for download, as an Access database...
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
  #29  
Old 12-09-2008, 10:08 AM
loquin's Avatar
loquinFrequently Asked DATABASE Questions loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default MS Access SQL Tutorials

MS Access is a very good desktop database, and, when used while being aware of its limits, can be an acceptable database for smaller multi-user applications.

In order to effectively use Access to its full potential, though, you must become proficient with Structure Query Language (SQL.) And, since each database implementation of SQL has its own 'flavor,' you really need to become proficient with the Access SQL dialect.

In order to assist you, Microsoft has created a three-lesson Access SQL Tutorial which will serve to arm you with the basics:
  1. Access SQL: Fundamental
  2. Access SQL: Intermediate
  3. Access SQL: Advanced
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
 
Frequently Asked DATABASE Questions
Frequently Asked DATABASE Questions
 
-->