newbie questions on Access

  • Thread starter Thread starter Danny Ni
  • Start date Start date
D

Danny Ni

Hi,

I am a VB programmer, new to Access. I would like to connect Access to SQL
sever using ADO, I have questions:
(1) Is there a way to use ADO to create "Link Tables"? Or is ODBC the only
way to go? I went to File, Get External Data, Link Tables, I only saw ODBC.
(2) How do I set a Form's Record Source to a table in a SQL server database,
again I only want to use ADO.

Thanks in Advance
 
Danny Ni said:
What is ADP?
Click to expand...

Access Data Project.

Go file->new->Project

This means that you don't use odbc to link your tables..but everything
including forms is a native oleDB connection to sql server (this does mean
in effect a ado connection for each form).

Give it a try...you might like it..especially if you are a happy sql server
guy....
 
An ADP file uses the SQL Server engine to connect directly to a SQL Server,
rather than Jet, which is primarily designed to connect to an Access data
store.

Open Access, and click on File - New.
New Project will be one of the options - let the wizard step you through
its creation.

HTH
- Turtle
 
Back
Top