Group:  Microsoft Access ยป microsoft.public.access.adp.sqlserver
Thread: SqlServer2005 with Win2k workstations running Access 2003

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

SqlServer2005 with Win2k workstations running Access 2003
"CyberDwarf" <steve.ingle[ at ]lineone.net> 28.09.2006 12:23:43
Hi

Has anyone out there had any problems running Win2k (SP4)
workstations/Access 2003/SqlServer 2005 in combination?

I have a client reporting connection dropout when loading our shrink-wrapped
Access ADE app, preceded by an error message saying 'class not registered'.

Not sure if this is an Access problem, or a Win2k problem run against the
SQL Server...

Any relevant comments gratefully received

TIA

Steve


RE: SqlServer2005 with Win2k workstations running Access 2003
Barry Gilbert 28.09.2006 13:13:03
I have an app deployed in that architecture, although mine is an adp. I
haven't had any problems like that.

Barry

"CyberDwarf" wrote:

[Quoted Text]
> Hi
>
> Has anyone out there had any problems running Win2k (SP4)
> workstations/Access 2003/SqlServer 2005 in combination?
>
> I have a client reporting connection dropout when loading our shrink-wrapped
> Access ADE app, preceded by an error message saying 'class not registered'.
>
> Not sure if this is an Access problem, or a Win2k problem run against the
> SQL Server...
>
> Any relevant comments gratefully received
>
> TIA
>
> Steve
>
>
>
Re: SqlServer2005 with Win2k workstations running Access 2003
"Graham R Seach" <gseach[ at ]accessmvp_REMOVE.com> 29.09.2006 12:11:16
As I understand, you can't use Access 2003 (or earlier) ADP/ADE against SQL
Server 2005. To use an ADP/ADE with 2005, you must use Access 2007.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"CyberDwarf" <steve.ingle[ at ]lineone.net> wrote in message
news:uF0c%23hv4GHA.3396[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text]
> Hi
>
> Has anyone out there had any problems running Win2k (SP4)
> workstations/Access 2003/SqlServer 2005 in combination?
>
> I have a client reporting connection dropout when loading our
> shrink-wrapped Access ADE app, preceded by an error message saying 'class
> not registered'.
>
> Not sure if this is an Access problem, or a Win2k problem run against the
> SQL Server...
>
> Any relevant comments gratefully received
>
> TIA
>
> Steve
>


RE: SqlServer2005 with Win2k workstations running Access 2003
Barry Gilbert 29.09.2006 13:58:02
PBSoft is correct. However, it sounds like MS is starting to steer people
away from ADP's. This page sums it up pretty well:
http://www.databaseadvisors.com/gazette/sqlexpress.htm

Barry

"CyberDwarf" wrote:

[Quoted Text]
> Hi
>
> Has anyone out there had any problems running Win2k (SP4)
> workstations/Access 2003/SqlServer 2005 in combination?
>
> I have a client reporting connection dropout when loading our shrink-wrapped
> Access ADE app, preceded by an error message saying 'class not registered'.
>
> Not sure if this is an Access problem, or a Win2k problem run against the
> SQL Server...
>
> Any relevant comments gratefully received
>
> TIA
>
> Steve
>
>
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net