MS Access project with SQL Server - Connecting to SQL Server with Access 2003

Author

Connecting to SQL Server with Access 2003

Joe Black

2006-03-22, 9:34 am

Hi all,

I have a site with about 50 PCs, these all run XP pro other than 2 W2K
machines, I have Office 2003 Pro installed on all these machines. On the
Server is Windows 2003 server and it has an instance of SQL Server Express
running on it, I also have an instance of SQL Server 2000 running on another
machine.

My problem is as follows:

I open MS Access and select new, then select create project with existing
data, I give this a file name and I am prompted with the Data link
properties window. In Windows XP I can select from the server list all of
the SQL Server instances on the network, but with Windows 2000 this list
shows neither SQL Server 2000 or Express instances.

Does anyone know why this is the case and how to resolve this problem?

My google searches have revealed no specific information, but maybe I am not
asking it the right questions :-(

TIA

Joe

Norman Yuan

2006-03-22, 9:34 am

Try to manually enter the SQL Server/SQL Express server (and instance) name
into the combo box, select appropriate login security and then click
"Refresh" button.

"Joe Black" <JoeBlack@newsgroup.nospam> wrote in message
news:uMghPkbTGHA.4264@TK2MSFTNGP11.phx.gbl...
> Hi all,
>
> I have a site with about 50 PCs, these all run XP pro other than 2 W2K
> machines, I have Office 2003 Pro installed on all these machines. On the
> Server is Windows 2003 server and it has an instance of SQL Server Express
> running on it, I also have an instance of SQL Server 2000 running on
> another machine.
>
> My problem is as follows:
>
> I open MS Access and select new, then select create project with existing
> data, I give this a file name and I am prompted with the Data link
> properties window. In Windows XP I can select from the server list all of
> the SQL Server instances on the network, but with Windows 2000 this list
> shows neither SQL Server 2000 or Express instances.
>
> Does anyone know why this is the case and how to resolve this problem?
>
> My google searches have revealed no specific information, but maybe I am
> not asking it the right questions :-(
>
> TIA
>
> Joe
>

Joe Black

2006-03-22, 9:34 am

Hi Norman,

Thank you, but I have tried this already, I should have mentioned this in my
first post. When I do this and select Test Connection I get the following
error though:

"Test connection failed because of error initialising provider. [DBMSSOCN]
General network error. Check your network documentation."

I don't know if this helps at all.

Cheers

Joe

"Norman Yuan" <NotReal@NotReal.not> wrote in message
news:e6dPV3bTGHA.5924@TK2MSFTNGP09.phx.gbl...
> Try to manually enter the SQL Server/SQL Express server (and instance)
> name into the combo box, select appropriate login security and then click
> "Refresh" button.
>
> "Joe Black" <JoeBlack@newsgroup.nospam> wrote in message
> news:uMghPkbTGHA.4264@TK2MSFTNGP11.phx.gbl...
>
>

Pepe

2006-03-22, 11:33 am

Be sure to have installed on the W2k machines the lastest MDAC.

Regards

"Joe Black" <JoeBlack@newsgroup.nospam> escribió en el mensaje
news:uMghPkbTGHA.4264@TK2MSFTNGP11.phx.gbl...
> Hi all,
>
> I have a site with about 50 PCs, these all run XP pro other than 2 W2K
> machines, I have Office 2003 Pro installed on all these machines. On the
> Server is Windows 2003 server and it has an instance of SQL Server Express
> running on it, I also have an instance of SQL Server 2000 running on
> another machine.
>
> My problem is as follows:
>
> I open MS Access and select new, then select create project with existing
> data, I give this a file name and I am prompted with the Data link
> properties window. In Windows XP I can select from the server list all of
> the SQL Server instances on the network, but with Windows 2000 this list
> shows neither SQL Server 2000 or Express instances.
>
> Does anyone know why this is the case and how to resolve this problem?
>
> My google searches have revealed no specific information, but maybe I am
> not asking it the right questions :-(
>
> TIA
>
> Joe
>

Wei Lu

2006-03-22, 8:39 pm

Hi Joe,

Welcome to use MSDN Managed Newsgroup Support.

Have you tried the suggestion Pepe provided?

You can find the latest MDAC in the following site:

http://www.microsoft.com/downloads/...0fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
====================
====================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Joe Black

2006-03-23, 7:50 am

Hi Pepe,

I have just given that a try, sadly it still exhibits the same problems. I
have applied all the latest updates from the microsoft update site too, and
still no joy :-(.

Thanks

Joe

"Pepe" <pepe@noquierospam.com> wrote in message
news:%23JOcVscTGHA.5808@TK2MSFTNGP12.phx.gbl...
> Be sure to have installed on the W2k machines the lastest MDAC.
>
> Regards
>
>
> "Joe Black" <JoeBlack@newsgroup.nospam> escribió en el mensaje
> news:uMghPkbTGHA.4264@TK2MSFTNGP11.phx.gbl...
>
>

Joe Black

2006-03-23, 7:50 am

Hi all,

I got it working, many thanks to all of you for the help.

I needed MDAC 8 installed as Pepe suggested, then I needed to type in the
server as Norman suggested.

Joe

"Joe Black" <JoeBlack@newsgroup.nospam> wrote in message
news:uMghPkbTGHA.4264@TK2MSFTNGP11.phx.gbl...
> Hi all,
>
> I have a site with about 50 PCs, these all run XP pro other than 2 W2K
> machines, I have Office 2003 Pro installed on all these machines. On the
> Server is Windows 2003 server and it has an instance of SQL Server Express
> running on it, I also have an instance of SQL Server 2000 running on
> another machine.
>
> My problem is as follows:
>
> I open MS Access and select new, then select create project with existing
> data, I give this a file name and I am prompted with the Data link
> properties window. In Windows XP I can select from the server list all of
> the SQL Server instances on the network, but with Windows 2000 this list
> shows neither SQL Server 2000 or Express instances.
>
> Does anyone know why this is the case and how to resolve this problem?
>
> My google searches have revealed no specific information, but maybe I am
> not asking it the right questions :-(
>
> TIA
>
> Joe
>

Pepe

2006-03-23, 7:50 am

BRAVO!!

"Joe Black" <JoeBlack@newsgroup.nospam> escribió en el mensaje
news:%23SK4wjmTGHA.2656@TK2MSFTNGP10.phx.gbl...
> Hi all,
>
> I got it working, many thanks to all of you for the help.
>
> I needed MDAC 8 installed as Pepe suggested, then I needed to type in the
> server as Norman suggested.
>
> Joe
>
>
> "Joe Black" <JoeBlack@newsgroup.nospam> wrote in message
> news:uMghPkbTGHA.4264@TK2MSFTNGP11.phx.gbl...
>
>

Sponsored Links