IT SOLUTIONS
Your full service technology partner! 
Crabjoe [Unspecified] -Collapse +Expand
-Collapse +Expand
Crabjoe
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (1)

Search Crabjoe:

Advanced
Personal Account . . .
Crabjoe
-- USA



Real Name:  Crabjoe [Unspecified]
Primary Role:  Coder
Joined: May 2002 (19 years ago)
Visits: 4
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.

Message Boards Activity

1 posts.
More...

Thread 2 of 2
Thread Starter or a Reply (but not last)  Group

dynamictiger
Access / SQL Question
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., , Confused
Posted to MB Topic: MS SQL « DBA Board
19 years ago

Crabjoe
dynamictiger,, , 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.
19 years ago
Nothing New Since Your Last Visit
2517
Hits

DBA, Databases, & Data

Thread 1 of 2
Thread Starter or a Reply (but not last)  Group

Crabjoe
Re: Access / SQL Question
dynamictiger,, , 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 to MB Topic: MS SQL « DBA Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

DBA, Databases, & Data
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]