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 Mike Lewis 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
0
0
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

JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
139
Andrzejek
Andrzejek
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
79
Dan Stoica
Dan Stoica
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
290
dhookom
dhookom
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
160
combo
combo
Moss100
  • Locked
  • Question
Make database appear as just a form
Replies
1
Views
57
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top