Cannot migrate from access 2000 to SQL 2000 
Author Message
 Cannot migrate from access 2000 to SQL 2000
When I use the SQL Migration wizard from access 2000 on a
PC,I get an error when it want to connect to the SQL 2000
Server environnement. Here are the following error :

Overflow capacity

It isn't a problem of security, because I can connect to
SQL 2000 server via ODBC.
If I do the same with SQL 7 server environnment and the
same PC with access 2000, it runs well.

Can you something about it ?
Tanks for your help



Tue, 08 Mar 2005 21:37:21 GMT
 Cannot migrate from access 2000 to SQL 2000

When I use the SQL Migration wizard from access 2000 on a
PC,I get an error when it want to connect to the SQL 2000
Server environnement. Here are the following error :

Overflow capacity

It isn't a problem of security, because I can connect to
SQL 2000 server via ODBC.
If I do the same with SQL 7 server environnment and the
same PC with access 2000, it runs well.

Can you something about it ?
Tanks for your help



Tue, 08 Mar 2005 21:38:26 GMT
 Cannot migrate from access 2000 to SQL 2000
That's a known compatibility issue between Access 2000 and SQLS 2000.
See the following article for the fix:
http://office.microsoft.com/downloads/2000/Accsql.aspx

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

On Fri, 20 Sep 2002 06:38:26 -0700, "jean-michel"

Quote:

>When I use the SQL Migration wizard from access 2000 on a
>PC,I get an error when it want to connect to the SQL 2000
>Server environnement. Here are the following error :

>Overflow capacity

>It isn't a problem of security, because I can connect to
>SQL 2000 server via ODBC.
>If I do the same with SQL 7 server environnment and the
>same PC with access 2000, it runs well.

>Can you something about it ?
>Tanks for your help



Wed, 09 Mar 2005 00:25:08 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. cannot migrate access 2000 to SQL 2000

2. Migrating queries in Access 2000 to SQL Server 2000

3. win98 users cannot access SQL 2000 under WIN 2000 server

4. Migrate to Win 2000/Sql 2000 from Win Nt/Sql 7.0

5. Migrate from Old SQL 2000 server to a New SQL 2000 server

6. Upsize Access 97 to SQL 2000 without SQL 7 or Access 2000

7. Access 2.0 migrate to SQL 2000

8. Help : Migrating from Access 2000 to SQL Server as a Back End

9. Problem in migrating from Access 2002 to SQL server 2000

10. Cannot access SQL 65 with SQL 2000 drivers

11. Migrating Access 2000 to SQL Server

12. Migrating Access 97 to SQL 2000


 
Powered by phpBB® Forum Software