This is a multi-part message in MIME format.

------_=_NextPart_001_01C1EC5D.9456C9B6
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I have an Access database that links to SQL Server 2000.  Since this
will be used by a few hundred people, I would rather like to avoid
installing the SQL ODBC driver on a few hundred machines.  Is there a
way a script the installation of the driver when a new user first runs
the database?  Or is there a way to link the table without installing
the ODBC driver?


Gregory Montague
GTSI, Corp
Database Analyst
Tel  (xxx) xxx-xxxx
eFax  (xxx) xxx-xxxx

This is a multi-part message in MIME format.

------=_NextPart_000_07BD_01C1EC66.EEDCED80
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Messageyou could automate the process of installing and configuring the 
ODBC drivers so that when they login it a does it for them.
  ----- Original Message -----
  From: Gregory Montague
  To: Access
  Sent: Thursday, April 25, 2002 2:32 PM
  Subject: [access] Installing SQL ODBC Drivers


  I have an Access database that links to SQL Server 2000.  Since this 
will be used by a few hundred people, I would rather like to avoid 
installing the SQL ODBC driver on a few hundred machines.  Is there a 
way a script the installation of the driver when a new user first runs 
the database?  Or is there a way to link the table without installing 
the ODBC driver?


  Gregory Montague
  GTSI, Corp
  Database Analyst
  Tel  (xxx) xxx-xxxx
  eFax  (xxx) xxx-xxxx

This is a multi-part message in MIME format.

------_=_NextPart_001_01C1EC65.970C5A3F
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Would you have sample code for the automation?

Thanks,


Gregory Montague
GTSI, Corp
Database Analyst
Tel  (xxx) xxx-xxxx
eFax  (xxx) xxx-xxxx

-----Original Message-----
From: Pritesh_b [mailto:pritesh_b@t...]
Sent: Thursday, April 25, 2002 9:39 AM
To: Access
Subject: [access] Re: Installing SQL ODBC Drivers


you could automate the process of installing and configuring the ODBC
drivers so that when they login it a does it for them.

----- Original Message -----
From: Gregory Montague <mailto:Gregory_Montague@G...> 
To: Access <mailto:access@p...> 
Sent: Thursday, April 25, 2002 2:32 PM
Subject: [access] Installing SQL ODBC Drivers

I have an Access database that links to SQL Server 2000.  Since this
will be used by a few hundred people, I would rather like to avoid
installing the SQL ODBC driver on a few hundred machines.  Is there a
way a script the installation of the driver when a new user first runs
the database?  Or is there a way to link the table without installing
the ODBC driver?


Gregory Montague
GTSI, Corp
Database Analyst
Tel  (xxx) xxx-xxxx
eFax  (xxx) xxx-xxxx

On Thu, 25 Apr 2002 09:32:00 -0400 "Gregory Montague" wrote:

> I have an Access database that links to SQL Server 2000.  Since this
> will be used by a few hundred people, I would rather like to avoid
> installing the SQL ODBC driver on a few hundred machines.  Is there a
> way a script the installation of the driver when a new user first runs
> the database?  Or is there a way to link the table without installing
> the ODBC driver?

Can't Access talk to it native mode, no driver needed? I thought that was 
an option.

Paul

Access databases can talk to other Access database without a driver, but
as far as I know, all other communications need ODBC connectivity of
some sort.  I've been able to imbed ODBC connectivity to Oracle in a
query and avoid installing the driver, but haven't found a why to link
tables without a driver.

Gregory Montague
GTSI, Corp
Database Analyst
Tel  (xxx) xxx-xxxx
eFax  (xxx) xxx-xxxx


-----Original Message-----
From: PStreeter@C...
[mailto:PStreeter@C...]
Sent: Thursday, April 25, 2002 11:17 AM
To: Access
Subject: [access] Re: Installing SQL ODBC Drivers


On Thu, 25 Apr 2002 09:32:00 -0400 "Gregory Montague" wrote:

> I have an Access database that links to SQL Server 2000.  Since this
> will be used by a few hundred people, I would rather like to avoid
> installing the SQL ODBC driver on a few hundred machines.  Is there a
> way a script the installation of the driver when a new user first runs

> the database?  Or is there a way to link the table without installing
> the ODBC driver?

Can't Access talk to it native mode, no driver needed? I thought that
was
an option.

Paul

This is a multi-part message in MIME format.

------=_NextPart_000_081E_01C1EC78.34099B40
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Messageno i dont have one but normally sysadmin have a tool called SMS.  
Another good place is to ask at 
http://www.microsoft.com/data/feedback.htm

hope it helps
  ----- Original Message -----
  From: Gregory Montague
  To: Access
  Sent: Thursday, April 25, 2002 3:29 PM
  Subject: [access] Re: Installing SQL ODBC Drivers


  Would you have sample code for the automation?

  Thanks,


  Gregory Montague
  GTSI, Corp
  Database Analyst
  Tel  (xxx) xxx-xxxx
  eFax  (xxx) xxx-xxxx
    -----Original Message-----
    From: Pritesh_b [mailto:pritesh_b@t...]
    Sent: Thursday, April 25, 2002 9:39 AM
    To: Access
    Subject: [access] Re: Installing SQL ODBC Drivers


    you could automate the process of installing and configuring the 
ODBC drivers so that when they login it a does it for them.
      ----- Original Message -----
      From: Gregory Montague
      To: Access
      Sent: Thursday, April 25, 2002 2:32 PM
      Subject: [access] Installing SQL ODBC Drivers


      I have an Access database that links to SQL Server 2000.  Since 
this will be used by a few hundred people, I would rather like to avoid 
installing the SQL ODBC driver on a few hundred machines.  Is there a 
way a script the installation of the driver when a new user first runs 
the database?  Or is there a way to link the table without installing 
the ODBC driver?


      Gregory Montague
      GTSI, Corp
      Database Analyst
      Tel  (xxx) xxx-xxxx
      eFax  (xxx) xxx-xxxx

I would use ADO if I was talking to SQL Server.  The ADO 2.1 driver supplied
with Access 2000 should exist on every machine that they have Access
installed on.

|-----Original Message-----
|From: Gregory Montague [mailto:Gregory_Montague@G...]
|Sent: Thursday, April 25, 2002 8:27 AM
|To: Access
|Subject: [access] Re: Installing SQL ODBC Drivers
|
|
|Access databases can talk to other Access database without a driver, but
|as far as I know, all other communications need ODBC connectivity of
|some sort.  I've been able to imbed ODBC connectivity to Oracle in a
|query and avoid installing the driver, but haven't found a why to link
|tables without a driver.
|
|Gregory Montague
|GTSI, Corp
|Database Analyst
|Tel  (xxx) xxx-xxxx
|eFax  (xxx) xxx-xxxx
|
|
|-----Original Message-----
|From: PStreeter@C...
|[mailto:PStreeter@C...]
|Sent: Thursday, April 25, 2002 11:17 AM
|To: Access
|Subject: [access] Re: Installing SQL ODBC Drivers
|
|
|On Thu, 25 Apr 2002 09:32:00 -0400 "Gregory Montague" wrote:
|
|> I have an Access database that links to SQL Server 2000.  Since this
|> will be used by a few hundred people, I would rather like to avoid
|> installing the SQL ODBC driver on a few hundred machines.  Is there a
|> way a script the installation of the driver when a new user first runs
|
|> the database?  Or is there a way to link the table without installing
|> the ODBC driver?
|
|Can't Access talk to it native mode, no driver needed? I thought that
|was
|an option.
|
|Paul
|
|
|
|

An alternative to ODBC is OLEDb and you can use a UDL file.  I have a
UDL file setting on a single server that the access app uses UNC path
to locate.  \\servername\path\appname.udl.


--- Pritesh_b <pritesh_b@t...> wrote:
> Messageno i dont have one but normally sysadmin have a tool called
> SMS.  Another good place is to ask at
> http://www.microsoft.com/data/feedback.htm
> 
> hope it helps
>   ----- Original Message ----- 
>   From: Gregory Montague 
>   To: Access 
>   Sent: Thursday, April 25, 2002 3:29 PM
>   Subject: [access] Re: Installing SQL ODBC Drivers
> 
> 
>   Would you have sample code for the automation?
> 
>   Thanks,
> 
> 
>   Gregory Montague
>   GTSI, Corp
>   Database Analyst
>   Tel  (xxx) xxx-xxxx
>   eFax  (xxx) xxx-xxxx
>     -----Original Message-----
>     From: Pritesh_b [mailto:pritesh_b@t...] 
>     Sent: Thursday, April 25, 2002 9:39 AM
>     To: Access
>     Subject: [access] Re: Installing SQL ODBC Drivers
> 
> 
>     you could automate the process of installing and configuring the
> ODBC drivers so that when they login it a does it for them.
>       ----- Original Message ----- 
>       From: Gregory Montague 
>       To: Access 
>       Sent: Thursday, April 25, 2002 2:32 PM
>       Subject: [access] Installing SQL ODBC Drivers
> 
> 
>       I have an Access database that links to SQL Server 2000.  Since
> this will be used by a few hundred people, I would rather like to
> avoid installing the SQL ODBC driver on a few hundred machines.  Is
> there a way a script the installation of the driver when a new user
> first runs the database?  Or is there a way to link the table without
> installing the ODBC driver?
> 
> 
>       Gregory Montague
>       GTSI, Corp
>       Database Analyst
>       Tel  (xxx) xxx-xxxx
>       eFax  (xxx) xxx-xxxx
> 
>       --- 
>     --- 
>   --- 
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/