Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using MSSQL Server as data source, how to access SQL tables best

Status
Not open for further replies.
MacDaddyNickP

MacDaddyNickP

Programmer
Jun 7, 2005
22
US
I have recently begun work on a project using MS SQL Server 2000 as a data source and am trying to understand the 'best' way to access the tables, ODBC or otherwise. How does one configure Access to use ODBC tables. I have written a considerable amount of VBA Access code and am pretty familiar with Access development. What I lack is the methodology of accessing SQL tables via ODBC. Can someone help me with this?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
311
Zyborg
Zyborg
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
418
Andrzejek
Andrzejek
DarkOne72
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
990
lameid
lameid
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
315
Dan Stoica
Dan Stoica
BFroeschlKC
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top