by Marcel Grueninge » Mon, 26 Aug 2002 14:46:40
I am looking for a tool which is able to transform sql
strings I generated in Access 2002 to a new view in SQL-
Server 2000. I was trying to copy and paste the SQL-
Strings. This is only working with simple views.
What can I do to bring my views from Acccess 2002 to SQL-
Server 2000?
Many thanks for your ideas.
Marcel Grueninger
by John Bel » Mon, 26 Aug 2002 15:48:11
The upsizing wizard will convert queries to view see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2...
l/acconChooseHowToUpsizeApplication.asp
John
Quote:> High,
> I am looking for a tool which is able to transform sql
> strings I generated in Access 2002 to a new view in SQL-
> Server 2000. I was trying to copy and paste the SQL-
> Strings. This is only working with simple views.
> What can I do to bring my views from Acccess 2002 to SQL-
> Server 2000?
> Many thanks for your ideas.
> Marcel Grueninger
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. 7062-IN-INDIANAPOLIS-DBA Skills-ORACLE-SQL-Database Administrator
3. SQL Server 2000 and Access 2002 ADP Project in NT 4.0
5. Jumping from Access 2002 to SQL Server 2000
6. Backupsoftware for ASE 11.9.2
7. Problem in migrating from Access 2002 to SQL server 2000
8. Cannot open tables using Access 2002 adp to SQL Server 2000
9. Access 2002/SQL Server 2000
10. SQL Server 2000/Access 2002 security issue
11. Access 2002 adp project with sql server 2000
12. Pessimistic locking with Access 2002/Sql-Server 2000