Re: Linking SQL Server tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brendan Reynolds (brenreyn)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 18:57:15 +0100

I notice the help topic you quoted is talking about an Access project (ADP).
Are you using an ADP, or an MDB? In an MDB, select ODBC from the 'files of
type' list. In the Select Data Source dialog, click 'New' if you don't
already have a DSN set up. The procedure is fairly straight forward. Post
back here again if you get stuck. 

-- 
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"folke" <folke@discussions.microsoft.com> wrote in message 
news:CFE4BA6D-07E0-4D68-96A9-A011A57AFF4B@microsoft.com...
> I'm trying to link tables from SQL Server to my Access 2003 database.
> When I do File>Get External Data>Link Tables I get a File Dialog where I 
> can
> choose "everything" BUT SQL Server!? I did install Jet SP8! According to 
> the
> help I should start a Wizard! Any hints??
>
> This SHOULD happen according to help but does not!
> Open an Access project, or switch to the Database window for the open 
> Access
> project.
> On the File menu, point to Get External Data, and then click Link Tables.
> In the first screen of the Link Table Wizard, select the type of link you
> want to create, either Linked SQL or Transact SQL, and then click Next.
> If you select Linked SQL, Access creates a linked server which provides 
> the
> most functionality, including the ability to update data if the OLE DB 
> data
> source allows, and permanently stores the data source connection 
> information
> in the Microsoft SQL Server database. Also, if the SQL Server database you
> are linking to is on another SQL Server, in most cases, SQL Server will
> optimize join operations. However, you must be a member of either the
> sysadmin or setupadmin roles.
>
>
> -- 
> Folke

Relevant Pages

  • Re: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)
  • Use of Access project with SQL Server Over VPN
    ... front-end database to connect to reports and input forms ... accessing the internal network via VPN. ... creating it as an Access Project, ... terrible trouble connecting to the SQL Server through the ...
    (microsoft.public.sqlserver.security)
  • Re: client/server application using Access as front end
    ... Access project is a quick way to create clients. ... You can remove the standard Access menus from your your client so that users ... If you have some experience with access databases you can benefit from this ... when you create an access application working with sql server. ...
    (microsoft.public.sqlserver.clients)
  • Re: Convert to SQL Query
    ... What yu need is Stored Procedure, instead of View, in SQL Server/MSDE ... (Stored Procedure/View is saved in SQL Server, not in Access Project file), ... because View in Sql Server cannot take parameter. ... WHERE CL.clientId = pClientId ...
    (microsoft.public.access.adp.sqlserver)
  • Access Project - cannot edit SQL Server records if create the table in project
    ... We have Access Project as the front end for a SQL Server database. ... edit/add/delete the records in this table from within the MS Access project. ...
    (microsoft.public.access.externaldata)