"Overflow" Trying to move Access table for SQL Server?

I'm trying to move several Access Tables from a moderate sized database to SQL Server 2000. Most of the tables will transfer using the Upgrade Wizard in Access 2003, however, there are a couple of tables that will not transfer. The wizard reports at the end of the upgrad, "table skipped" or "overflow"
I cannot find in the help section why this happens. I would appreciate any help you send my way.
Thanks,
Joe| I'm trying to move several Access Tables from a moderate sized database
| to SQL Server 2000. Most of the tables will transfer using the Upgrade
Wizard
| in Access 2003, however, there are a couple of tables that will not
transfer.
| The wizard reports at the end of the upgrad, "table skipped" or "overflow"
--
Hi Joe,
One known issue that causes the "table skipped" error are column names that
contain symbols such as quotes, commas and slashes. SQL Server doesn't
support all symbols for column names. If you rename such "odd" column
names, the upsize wizard should work again. Also a known issue is:
ACC2000: Tables Not Upsized When Query or Table Name Contains Apostrophe
http://support.microsoft.com/?id=216218
If all else fails, you can use Data Transformation Services (DTS) to export
to SQL Server:
ACC2000: How to Use Data Transformation Services (DTS) to Export Data from
a Microsoft Access Database to a SQL Server Database
http://support.microsoft.com/?id=250616
Hope this helps,
--
Eric Cárdenas
SQL Server support

!

Dear all,

I was given a project to transfer our database into sql server database.

In our previous database we used the datatype int4 for some columns to create some views and in some queries that we used to build our datawindows. In SQLServer 2000 i created a user defined function named int4. I can execute it with the line select dbo.int4(poso) from employee .

Unfortrunately this way make me to rebuild all my datawindows and replace int4( with dbo.int4( . Is there any way to execute queries using user defined function but omitting the first part name dbo. I mean to manage execute the command select int4(poso) from employee \\let int4 be a user definded function.

If i create an ODBC function i must use select fn int4(poso) from employee

I thing i could solve this if i could create a system function int4() but i have no idea how it can be done.

If i can’t solve this, i thing it will decided than is impossible to move to sqlserver Database. Has anyone any suggestions?

Thanks in advance,

Best regards,

In SQL Server, you are not allowed to create a system functions. There is no other choice. You have to use the dbo.int4().

But I am not sure what you are doing inside this function. How important it is. If it is permanent for all the query call, better update the values on the main table itself (using update statement) & take care while inserting these values.

|||

No, you will have to use the owner /schema prefix for the new defined function.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Hellen, please do not multipost.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Firstly many thanks for your reply!!!

As i said, i want to create this function so as not to change at all the code of our programs. Inside the code we use select statements and we use in a lot of points int4(). It is necessary as i have functions that i use to my database and i want to have the optional to use sqlserver database without changing at all my code.

As you said it is not possible in Sql Server as i am not allowed to create system functions. Is it possible inSql Server 2005 or 2008 to create system functions?

Any ideas of how i could create an odbc function but include the function in a select statement without the fn prefix? Or should i abandon the idea of moving to a strong database?

|||

No, this is not possible as far as I know. You should consider trying to change the code logic to support this (strong9 syntax :-)

Jens K. Suessmeyer

http://www.sqlserver2005.de