Re: Access Project connecting to multiple SQL Servers
- From: "dbahooker@xxxxxxxxxxx" <dbahooker@xxxxxxxxxxx>
- Date: 6 Jul 2006 15:55:54 -0700
I have heard that Microsoft IS working on a patch for this; and this
feature will be available in Access 2007.
I love ADP; I think that it's one of the most important products that
Microsoft has released.
-Aaron
Norman Yuan wrote:
That is the fact you have to live with: Acccess2003 or earlier version
cannot be used to create server objects (SPs, Views, Tables...) on SQL
Server 2005. There seems MS has no plan to fix this in a future service pack
since ADP is on its way of phasing out. I do not know if upcoming Access2007
allows creating server object on SQL Server 2005 or not (it still support
ADP format).
So, to use ADP with SQL Server2005, you have to find other way to
create/modify server objects outside your ADP app.
"Greg from FL" <Greg from FL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5A0D9F31-F159-4297-B0BE-E4B197716633@xxxxxxxxxxxxxxxx
Good morning. We are having an issue and would like to see what our
solution
could be. We have an Access 2003 Project (.adp) connected to a SQL 2000
Server and all works great. We are adding an additional link to a SQL
2005
server. When the views are run individually, they work fine. However,
when
we try to create view from those linked servers it times out. We have
changed the timeout to 0 and it never responds. So we've tried using the
SQL
2005 server as the primary server for an Access 2003 Project (.adp) and
then
linking the SQL 2000 server and it works fine. However, same thing, when
creating a query off of the two views, this time we get errors like:
1. This version of Microsoft Office Access doesn't support design changes
with the version of Microsoft SQL Server your Access project is connected
to.
See the Microsoft Office Update Web site for the latest information and
downloads. Your design changes will not be saved.
2. You have connected to a version of SQL Server later than SQL Server
2000. The version of Visual Studio or Access that you are using was
released
before the version of SQL Server to which you are connected. For this
reason, you might encounter problems. Please check with Microsoft to see
if
there is a service pack that you should apply to Visual Studio or Office
in
order to get support for the version of SQL Server to which you are
connected. You can continue but any new object types might not be
enumerated, and it will not be possible to save any objects or database
diagrams that you create using the Visual Database Tools.
The version of Access 2003 specifically is: Microsoft ® Office Access
2003
(11.6566.6568) SP2
Any assistance you can provide will greatly assist us with our project.
Thank you.
.
- References:
- Re: Access Project connecting to multiple SQL Servers
- From: Norman Yuan
- Re: Access Project connecting to multiple SQL Servers
- Prev by Date: Access ADP Server Filter By Form two issues.
- Next by Date: Re: Access Project connecting to multiple SQL Servers
- Previous by thread: Re: Access Project connecting to multiple SQL Servers
- Next by thread: Re: Access Project connecting to multiple SQL Servers
- Index(es):
Relevant Pages
|
