upsizer wizard

[KimMazz]

Hi, my first time here. If a fellow user hadn't told me about these groups I wouldn't know about them. But I am glad they are here now

I am using Access 2002 Office XP Pro. I have sql server installed on my pc on port 1433. I run zone alarm. I tried to use the upsizer on an Access db and got the message from zone alarm do I want Access to access the internet on port 1434. Obvously the wrong port.

The upsizer can't find the server or access is denied. Does anyone have a clue what I should do from here

Also, is it possible to enter the newsgroups through my newsreader instead of the web? (OUtlook express

Thanks, Kim

 

[Alex Dybenko]

1. try to run cliconfg and add there sql server alias with exact port number
2. to read news via outlook express you can use hhtp server
msnews.microsoft.com

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hi, my first time here. If a fellow user hadn't told me about these groups

I wouldn't know about them. But I am glad they are here now!

I am using Access 2002 Office XP Pro. I have sql server installed on my

pc on port 1433. I run zone alarm. I tried to use the upsizer on an Access
db and got the message from zone alarm do I want Access to access the
internet on port 1434. Obvously the wrong port.

The upsizer can't find the server or access is denied. Does anyone have a

clue what I should do from here?

 

[Tony Toews]

Hi, my first time here. If a fellow user hadn't told me about these groups I wouldn't know about them. But I am glad they are here now!

I am using Access 2002 Office XP Pro. I have sql server installed on my pc on port 1433. I run zone alarm. I tried to use the upsizer on an Access db and got the message from zone alarm do I want Access to access the internet on port 1434. Obvously the wrong port.

SQL Server uses both 1433 and 1434 ports. I haven't done any research
on exactly why though.

FWIW Do a search at the Knowledge Base at support.microsoft.com using
the keywords "upsizing" to review the various white papers on upsizing
Access to SQL Server as well as to ensure you have any updates
required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm