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...
>

Change collation all db tables and db

If I need to copy a db to another server but I need to chnage the new db
collation and the collation of all the columns, is there a better way than:
1. Create new DB with desired collation
2. Create table scripts without collation option or constraints; run them
3. Use BCP or DTS to move the data
4. Script contraints, stored procs, views....; run them
I ran DTS object move but that always seems to copy the column collation.
Ideally I would like to somehow force a backup or restore to use a given
collation.
-Peterhttp://groups.google.co.uk/groups?q...
&rnum=2
Jacco Schalkwijk
SQL Server MVP
"Peter L." <PeterL@.discussions.microsoft.com> wrote in message
news:62681A24-84DC-4E41-A1B0-FD85D8F93AB5@.microsoft.com...
> If I need to copy a db to another server but I need to chnage the new db
> collation and the collation of all the columns, is there a better way
> than:
> 1. Create new DB with desired collation
> 2. Create table scripts without collation option or constraints; run them
> 3. Use BCP or DTS to move the data
> 4. Script contraints, stored procs, views....; run them
> I ran DTS object move but that always seems to copy the column collation.
> Ideally I would like to somehow force a backup or restore to use a given
> collation.
> --
> -Peter|||Thanks Jacco. I guess there is no easy way to change collation.
-Peter
"Jacco Schalkwijk" wrote:

> http://groups.google.co.uk/groups?q...r />
bl&rnum=2
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Peter L." <PeterL@.discussions.microsoft.com> wrote in message
> news:62681A24-84DC-4E41-A1B0-FD85D8F93AB5@.microsoft.com...
>
>

Change collation all db tables and db

If I need to copy a db to another server but I need to chnage the new db
collation and the collation of all the columns, is there a better way than:
1. Create new DB with desired collation
2. Create table scripts without collation option or constraints; run them
3. Use BCP or DTS to move the data
4. Script contraints, stored procs, views....; run them
I ran DTS object move but that always seems to copy the column collation.
Ideally I would like to somehow force a backup or restore to use a given
collation.
-Peter
http://groups.google.co.uk/groups?q=...phx.gbl&rnum=2
Jacco Schalkwijk
SQL Server MVP
"Peter L." <PeterL@.discussions.microsoft.com> wrote in message
news:62681A24-84DC-4E41-A1B0-FD85D8F93AB5@.microsoft.com...
> If I need to copy a db to another server but I need to chnage the new db
> collation and the collation of all the columns, is there a better way
> than:
> 1. Create new DB with desired collation
> 2. Create table scripts without collation option or constraints; run them
> 3. Use BCP or DTS to move the data
> 4. Script contraints, stored procs, views....; run them
> I ran DTS object move but that always seems to copy the column collation.
> Ideally I would like to somehow force a backup or restore to use a given
> collation.
> --
> -Peter
|||Thanks Jacco. I guess there is no easy way to change collation.
-Peter
"Jacco Schalkwijk" wrote:

> http://groups.google.co.uk/groups?q=...phx.gbl&rnum=2
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Peter L." <PeterL@.discussions.microsoft.com> wrote in message
> news:62681A24-84DC-4E41-A1B0-FD85D8F93AB5@.microsoft.com...
>
>

Change collation all db tables and db

If I need to copy a db to another server but I need to chnage the new db
collation and the collation of all the columns, is there a better way than:
1. Create new DB with desired collation
2. Create table scripts without collation option or constraints; run them
3. Use BCP or DTS to move the data
4. Script contraints, stored procs, views....; run them
I ran DTS object move but that always seems to copy the column collation.
Ideally I would like to somehow force a backup or restore to use a given
collation.
--
-Peterhttp://groups.google.co.uk/groups?q=bart+duncan+collate+database+jacco&hl=en&lr=&group=microsoft.public.sqlserver.*&selm=%23%24c1OFoaEHA.1652%40TK2MSFTNGP09.phx.gbl&rnum=2
--
Jacco Schalkwijk
SQL Server MVP
"Peter L." <PeterL@.discussions.microsoft.com> wrote in message
news:62681A24-84DC-4E41-A1B0-FD85D8F93AB5@.microsoft.com...
> If I need to copy a db to another server but I need to chnage the new db
> collation and the collation of all the columns, is there a better way
> than:
> 1. Create new DB with desired collation
> 2. Create table scripts without collation option or constraints; run them
> 3. Use BCP or DTS to move the data
> 4. Script contraints, stored procs, views....; run them
> I ran DTS object move but that always seems to copy the column collation.
> Ideally I would like to somehow force a backup or restore to use a given
> collation.
> --
> -Peter|||Thanks Jacco. I guess there is no easy way to change collation.
-Peter
"Jacco Schalkwijk" wrote:
> http://groups.google.co.uk/groups?q=bart+duncan+collate+database+jacco&hl=en&lr=&group=microsoft.public.sqlserver.*&selm=%23%24c1OFoaEHA.1652%40TK2MSFTNGP09.phx.gbl&rnum=2
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Peter L." <PeterL@.discussions.microsoft.com> wrote in message
> news:62681A24-84DC-4E41-A1B0-FD85D8F93AB5@.microsoft.com...
> > If I need to copy a db to another server but I need to chnage the new db
> > collation and the collation of all the columns, is there a better way
> > than:
> >
> > 1. Create new DB with desired collation
> > 2. Create table scripts without collation option or constraints; run them
> > 3. Use BCP or DTS to move the data
> > 4. Script contraints, stored procs, views....; run them
> >
> > I ran DTS object move but that always seems to copy the column collation.
> >
> > Ideally I would like to somehow force a backup or restore to use a given
> > collation.
> >
> > --
> > -Peter
>
>