Board index MS SQL Server

SQL Server 2000 and Access 2002 ADP Project in NT 4.0

SQL Server 2000 and Access 2002 ADP Project in NT 4.0

Post by Imerio Gavazze » Tue, 14 Aug 2001 20:25:52



We are evaluating the possibility of upsizing an Access mdb to an
Access 2002 adp project on SQL Server 2000. As our current platform is
Windows NT 4.0 SP 6, we are really concerned of this very quote that
I've found on the online docs of Access 2002.

/begin quote

Supported Microsoft SQL Server databases:
You can connect to one of the following SQL Server databases:

Microsoft SQL Server 2000 on Microsoft Windows 2000 and Microsoft
Windows 98 or later

Microsoft SQL Server 2000 Desktop Engine on Windows 2000 and Windows
98 or later

Microsoft SQL Server 7.0 on Microsoft Windows NT 4.0 or later (with
Microsoft Windows NT Service Pack 4 or later) and Microsoft Windows 95
or later)

Microsoft Data Engine (MSDE) on Windows NT 4.0 or later and Windows 95
or later

Microsoft SQL Server 6.5 on Windows NT 4.0 or later (with SQL Server
Service
Pack 5 or later)

end quote/

I tested an upsizing made on SQL Server 2000 Personal Edition and all
seems to work properly even in NT 4.0.

Any clarification, especially form MS guys, will be very appreciated.

Thanks in advance.

Ciao,
Imerio

 
 
 
Top

SQL Server 2000 and Access 2002 ADP Project in NT 4.0

Post by Mary Chipma » Tue, 14 Aug 2001 23:40:10


The docs are often wrong or leave out information. Basically, if you
can install a version of SQLS on an OS, you can upsize an Access mdb
to it. See SQL Books Online for the supported features for each
version--it gets confusing because msft changed the names between
versions (7 to 2000), but Access works with all of them (except CE).

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446



>We are evaluating the possibility of upsizing an Access mdb to an
>Access 2002 adp project on SQL Server 2000. As our current platform is
>Windows NT 4.0 SP 6, we are really concerned of this very quote that
>I've found on the online docs of Access 2002.

>/begin quote

>Supported Microsoft SQL Server databases:
>You can connect to one of the following SQL Server databases:

>Microsoft SQL Server 2000 on Microsoft Windows 2000 and Microsoft
>Windows 98 or later

>Microsoft SQL Server 2000 Desktop Engine on Windows 2000 and Windows
>98 or later

>Microsoft SQL Server 7.0 on Microsoft Windows NT 4.0 or later (with
>Microsoft Windows NT Service Pack 4 or later) and Microsoft Windows 95
>or later)

>Microsoft Data Engine (MSDE) on Windows NT 4.0 or later and Windows 95
>or later

>Microsoft SQL Server 6.5 on Windows NT 4.0 or later (with SQL Server
>Service
>Pack 5 or later)

>end quote/

>I tested an upsizing made on SQL Server 2000 Personal Edition and all
>seems to work properly even in NT 4.0.

>Any clarification, especially form MS guys, will be very appreciated.

>Thanks in advance.

>Ciao,
>Imerio


 
 
 
Top

SQL Server 2000 and Access 2002 ADP Project in NT 4.0

Post by Brian M. Sockey [M » Wed, 15 Aug 2001 00:42:21


Hi Imerio,

Mary is correct.   If you can install SQL Server 2000 (except CE) on a
machine then Access 2002 can connect to it.   If you can post where exactly
you got this quote from, I will pass the information on to the right person
so it can get updated.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Brian M. Sockey
Microsoft Access Developer Support

 
 
 
Top

SQL Server 2000 and Access 2002 ADP Project in NT 4.0

Post by Imerio Gavazze » Wed, 15 Aug 2001 23:42:38



Quote:> Hi Imerio,

> Mary is correct.   If you can install SQL Server 2000 (except CE) on a
> machine then Access 2002 can connect to it.   If you can post where exactly
> you got this quote from, I will pass the information on to the right person
> so it can get updated.

> I hope this helps! If you have additional questions on this topic, please
> reply to this posting.

> Brian M. Sockey
> Microsoft Access Developer Support

Brian,

Here is the path to the misleading quote:

Microsoft Access Help\Access Projects\
Understanding a Microsoft Access Project\About an Access project\
Supported Microsoft SQL Server databases

Thank you Mary for your reassuring words.

Ciao,
Imerio

 
 
 
Top

1. Access 2002 Project with SQL Server 2000

I'm using an Access 2002 Database Project to work with my SQL Server DB. I
have problems with the "Identity" auto increment setup. Here are the
problems I am running into:

- Have a products table with the following fields: productID, price,
category, and title. When you run a query based on this table and select a
certain product category as a criteria, you are run into problems adding new
records using this query view. i.e. here is an example query:

ALTER FUNCTION dbo.[QueryProducts Criteria 10]

()

RETURNS TABLE

AS

RETURN ( SELECT TOP 100 PERCENT ProductID, ProductTitle, ProductCategory,
ProductPrice

FROM dbo.tblProducts

WHERE (ProductCategory = '10') )

You get all the records that have the product category of 10 with this query
when you run this query in the Access Project Query datasheet view - but,
you run into problems going into the last blank row in the query row and
trying to add new records - the Auto Number Increment starts with the last
(highest) ProductID number displayed in your query view - not the highest
valid ProductID in the Products table.

What is my solution to this? I'm new to SQL Server 2000 so I don't know the
in and outs to it. The solution needs to work so that when I have a filtered
form and I'm trying to add new records, it correctly increments the highest
ProductID in the products table as well.

2. IF EXISTS

3. Lost Connection Access 2000 ADP and SQL Server 2000

4. Combined indexes (date-type +char type)?

5. SQL Server 2000 B2 and Access 2000 project distribution problems

6. Parameters in a Query

7. moving from Sql server 2000 evaluation to full version of Sql server 2000

8. Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in SQL Server 2000

9. Sql server 2000 on NT 2000 Advanced server

10. how to backup a sql server 65 server from a sql server 2000 server

11. Connecting to a Sql Server 2000 SP3 from a Sql Server 2000 SP2

12. Help: Understanding MDB vs ADP theology - Access 2002/SQL 2000


All times are UTC
Board index