HOW DO I INSTALL SP3?

[Guest]

I had requested help about connecting to my SQL database located on my
desktop from my laptop thus:
I need help urgently to connect to SQL Server on my desktop (running on
Windows XP Pro, with Office Developer installed) from my laptop (also running
Windows XP Pro). Both machines communicate easily as I transfer files between
the two.

But now I am working on an Access Project, and need to work from the laptop
occasionally. So I need to connect to the Access Project on the desktop. When
I pick *File/Connection/Data Link Properties-Connection Tab* from the laptop,
the server name on the desktop is shown when the two machines are connected,
but does not when they are not. However I have not been able to connect to
the server, probably because of the "gibberish" on the other Tabs of the Data
Link Properties.
Can someone help me out please?

Kevin3NF (MVP) eventually suggested that I install SP3. I guess SP3 is one
of the Windows files but I have no clue how to go about installing it. Please
help.

 

[Alex White MCDBA MCSE]

Hi,

if you are talking about SP3 for SQL, then MS has just released SP4 for SQL
2000, I have been beta testing it and I am very happy with it, it is already
on my production server.

http://www.microsoft.com/sql

 

[Guest]

I really don't know if the SP3 refers to SQL, Access or Windows. Please
enlighten me.
--
Glint

Hi,

if you are talking about SP3 for SQL, then MS has just released SP4 for SQL
2000, I have been beta testing it and I am very happy with it, it is already
on my production server.

http://www.microsoft.com/sql

 

[Alex White MCDBA MCSE]

Well Windows XP is on SP2 currently, Windows 2000 is on SP4, but I am
guessing that the original reponse refers to SQL server.

http://www.microsoft.com/sql

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

I really don't know if the SP3 refers to SQL, Access or Windows. Please
enlighten me.

 

[Norman Yuan]

Your messages is a bit confusing. Actually I read your communication with
kevin in the other NG. See comment inline.

I had requested help about connecting to my SQL database located on my
desktop from my laptop thus:
I need help urgently to connect to SQL Server on my desktop (running on
Windows XP Pro, with Office Developer installed) from my laptop (also running
Windows XP Pro). Both machines communicate easily as I transfer files between
the two.

But now I am working on an Access Project, and need to work from the laptop
occasionally. So I need to connect to the Access Project on the desktop.

When

You cannot connect to "Access Project" on your desktop machine from your
laptop. Access project is a front end app and develop IDE, which needs to
connect to SQL Server/MSDE (on the same computer or on other networked
computer). What you need is make sure you can connecto the SQL Server/MSDE
on your desktop computer from your laptop. If you need to work on the Access
project from your laptop, you simply copy the *.adp file to your laptop.
Note: when working with the Access project from your laptop, you need to
connect to a SQL Server/MSDE (which is on your desktop), meaning the two
computers need to connect to a network.

I pick *File/Connection/Data Link Properties-Connection Tab* from the laptop,
the server name on the desktop is shown when the two machines are

connected,

So, you can connect to the SQL Server/MSDE on your desktop from your laptop.
So far so good. What the problem is?

but does not when they are not.

Naturally. It should be this way.

However I have not been able to connect to
the server, probably because of the "gibberish" on the other Tabs of the Data
Link Properties.

You have already been connected as you staed above. What do you mean
"gibberish" on the other Tabs?

Can someone help me out please?

Kevin3NF (MVP) eventually suggested that I install SP3. I guess SP3 is one
of the Windows files but I have no clue how to go about installing it. Please
help.

Try this:

1. Make sure the two computers are connected to network.
2. Copy the Access Project to your laptop (or simply start a new Access
project).
3. Click menu "File->Connections..." in the Access Project and bring up
"Data Link Properties" dialog box.
4. On the "Connection" tab, select your desktop computer name in the server
name dropdown list. Sometime there is not any server name listed, you can
simply enter the server name. Note, if the SQL Server/MSDE was installed
with instance name, you need enter "ComputerName\SQLServerInstanceName" (You
have indicated you can see the desktop name in your message)
5. Make sure you select correct authentication method (Windows security or
SQL Security)
6. In "Select the database on the server" dropdown, select the database you
want the Access Project connected to.
7. Click "Test..." button the make sure the connection is OK.

Actually, if you can go as far as step4 (as you have indicated!), you should
not have problem, as long as your login credential is correct. It is rarely
that you need to deal with the other two tabs on this dialog box, unless you
are so experienced programmer that want to fine tune the connection
settings.

Although installing SQL Server/MDSE SP3/SP4 is strongly recommended, but I
susppect that isn't your problem right now.