Change connection information Access 2003 with MSDE

I have a copy of an ADP and MSDE database that I tweak occasionally from an
alternate location. I used to be able to do this just fine. When I would
try to open the ADP the connection was broken because the server on this
computer I'm using has a different name than the "live" server.
Since I upgraded to Access 2003, when I open the ADP and try to edith the
ADP, I can't get to it. How can I change the connnection properties?
Linda
hi Linda
Linda Burnside wrote:
> I have a copy of an ADP and MSDE database that I tweak occasionally
> from an alternate location. I used to be able to do this just fine. When
> I would try to open the ADP the connection was broken because
> the server on this computer I'm using has a different name than the
> "live" server.
> Since I upgraded to Access 2003, when I open the ADP and try to edith
> the ADP, I can't get to it. How can I change the connnection
> properties?
in the File menu, you can access the "connection" menu item, which will
open the Data link dialog you can use to select the desired SQL Server
instance (and database)..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Yes, I know where it is. Problem is that nothing happens when I click on
Connection. It won't open.
Linda
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3m7637F156p68U1@.individual.net...
> hi Linda
> Linda Burnside wrote:
> in the File menu, you can access the "connection" menu item, which will
> open the Data link dialog you can use to select the desired SQL Server
> instance (and database)..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Linda,
Linda Burnside wrote:
> Yes, I know where it is. Problem is that nothing happens when I
> click on Connection. It won't open.
does the Data Link dialog not open?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The box that shows the connection information (if that's what you're calling
the data link dialogue) does not open. When I click on the word
"Connection" from the menu, nothing happens.
Linda
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3m8l81F15g1kqU1@.individual.net...
> hi Linda,
> Linda Burnside wrote:
> does the Data Link dialog not open?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Since "Data Link Properties" dialog box is an independent COM component
comming with Windows, you can test it with a "*.udl" file to make sure the
"Data Link Properties" dialog box itself is OK or not. If it is OK for
"*.udl" file, then the problen could be the installation of Access2003. If
the "Data Link Properties" dialog box does not work even with "*.udl", you
may have to repair your Windows or Windows registry (I am not surewhat to do
or what the cause is).
To test "Data Link Properties" dialog box:
1. Open Notepad;
2. Save a blank Notepad file on desktop as "MyDataLink.udl";
3. Double-click "MyDataLink.udl", which should open "Data Link Properties"
dialog box.
"Linda Burnside" <linda@.nospam_burnsidebiz.com> wrote in message
news:N0ILe.52$Z%6.1@.newssvr17.news.prodigy.com...
> The box that shows the connection information (if that's what you're
calling
> the data link dialogue) does not open. When I click on the word
> "Connection" from the menu, nothing happens.
> Linda
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3m8l81F15g1kqU1@.individual.net...
>