I.T. Discussion Community!
-Collapse +Expand
Search DBA Group:

-Collapse +Expand DBA Store

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardMS SQL Topic   Print This     

Access / SQL Question

Access / SQL Question in MS SQL topic (part of our DBA, Databases, & Data group).

Quick Search: Question   Access /   Access / SQL  
Perth, Western Australia
I have been playing around with a database structure on and off for about 18 months. The structure is huge and contains several circular relationships. Current Model is in excess of 70 tables and is around 70% complete (although I am not going to sweat about the 30%).

I had been planning in doing the whole thing in Access in a frontend backend configuration. However, it has been suggested I use SQL to store the tables.

I have never used SQL, has anyone got any suggestions where to start to learn how to use my tables within this program? And I guess more importantly how to link the tables into my Access front end?

I will be using Office XP and SQL that comes with the developer edition.

Athlon XP 1600
Windows XP
Office XP

Perth the most isolated capital in the world
 Posted 19 years ago (Thread Starter)
Comment Quote
About dynamictiger -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #5308, 1 replies
Thread Started 2/15/2002 1:25:00 PM
View Counter=2516
Last Reply Posted 5/25/2002 10:14:00 AM)
Location=Perth, Western Australia  
Joined=19 years ago   MB Posts=62  
Most Recent Post
-- USA

To use SQL table in access, the 1st thing you need to do is set the permisssions in the SQL tables. Then to link the tables in Access, it's easy. I use an ODBC connection and the in Access go to File ->Get External Data -> Link Tables. Hope the answer isn't too late for you.
 Posted 19 years ago
Comment Quote
About Crabjoe -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #6342 (Level 1.1)  Reply to 5308
Thread Started 5/25/2002 10:14:00 AM
View Counter=2
Location=-- USA 
Joined=19 years ago   MB Posts=1  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1181A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5308 Counter
Since 4/2/2008

Follow PrestwoodBoards on: 

©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech