help: How to use access upsizing tool to change access database to sql database 
Author Message
 help: How to use access upsizing tool to change access database to sql database

You can try this:
1. Create a device in SQL server
2. Create an empty database in that device
3. Crate a DSN in you machine to link to that database
4. Start the upsize program, chooice 'use existing database'
5. upload your table.


Quote:
> Everyone:
>    Please help! I can not run access upsizing tool correctly to change my
> access database to SQL database. I made DSN for file type,user type and
> system type, using access driver, but none of them can be accept when I
> run upsizing tool to choose DSN, it gave alarm of "can not
> use ODBC to input or output, or can not link an outer Microsoft
> Jet/ISAM  
> database to your database."
>        I tried the DSN with SQL driver, it seems can be accept, it asked
> to login the SQL SERVER. But I think I have no SQL TYPE database right
> now, I only have access database, I just want to change it to SQL, why
> should I choose SQL driver when my data is still access database?
>       I have no idea now, how can I change my access database to SQL
> SERVER 6.5 DATABASE ?

> Thanks in advance.



Fri, 12 May 2000 03:00:00 GMT
 help: How to use access upsizing tool to change access database to sql database

Everyone:
        Please help! I can not run access upsizing tool correctly to change my
access database to SQL database. I made DSN for file type,user type and
system type, using access driver, but none of them can be accept when I
run upsizing tool to choose DSN, it gave alarm of "can not
use ODBC to input or output, or can not link an outer Microsoft
Jet/ISAM  
database to your database."
       I tried the DSN with SQL driver, it seems can be accept, it asked
to login the SQL SERVER. But I think I have no SQL TYPE database right
now, I only have access database, I just want to change it to SQL, why
should I choose SQL driver when my data is still access database?
      I have no idea now, how can I change my access database to SQL
SERVER 6.5 DATABASE ?

Thanks in advance.



Sat, 13 May 2000 03:00:00 GMT
 help: How to use access upsizing tool to change access database to sql database

Thanks to James Hung,
     Now I learned more on SQL server with your help. I did as what you
said, but I met another problem. When I made file DSN in ODBC
adminstrator, I choosed SQL driver, it poped up SQL SERVER logon window,
in that window, I entered SQL SERVER's name (which located on another NT
server),and entered user and password (db owner), it failed to connect
to the SQL server. What can I do now?

Thanks in advance.

Quote:

> You can try this:
> 1. Create a device in SQL server
> 2. Create an empty database in that device
> 3. Crate a DSN in you machine to link to that database
> 4. Start the upsize program, chooice 'use existing database'
> 5. upload your table.


> > Everyone:
> >       Please help! I can not run access upsizing tool correctly to change my
> > access database to SQL database. I made DSN for file type,user type and
> > system type, using access driver, but none of them can be accept when I
> > run upsizing tool to choose DSN, it gave alarm of "can not
> > use ODBC to input or output, or can not link an outer Microsoft
> > Jet/ISAM
> > database to your database."
> >        I tried the DSN with SQL driver, it seems can be accept, it asked
> > to login the SQL SERVER. But I think I have no SQL TYPE database right
> > now, I only have access database, I just want to change it to SQL, why
> > should I choose SQL driver when my data is still access database?
> >       I have no idea now, how can I change my access database to SQL
> > SERVER 6.5 DATABASE ?

> > Thanks in advance.



Sat, 13 May 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Problems using Access Database upsized to SQL-server

2. Upsizing Access Database application to SQL Server Database

3. Problems using Access 7.0 Upsizing Tool for SQL 6.5

4. Using Access Upsizing Tools with SQL Server 7.0

5. Using Access Upsize Tools With SQL 7.0

6. Q: about Access Upsizing tools (Access -> SQL)

7. Access Upsizing Tool: Can't upsize tables with OLE field

8. Using GUI such as Access forms to access database created in SQL Server

9. Upsizing Database from Access 2000 to SQL Svr 2000

10. Upsizing Access-database to SQL-server 6.0

11. Error Upsizing Access Database to SQL Server 7.0

12. Upsizing access database to sql


 
Powered by phpBB® Forum Software