About upsizing access DB file to MS SQL 7.0 
Author Message
 About upsizing access DB file to MS SQL 7.0

Hi,

I have an application which is using Access database file as storage before,
and it is become very big after several months later.  In order to increase
to capability for WAN access, we would like to upsizing the application to
store the data in MS SQL Server.

In order to minimize the impact of migration, we would like to use the
approach of export the existing DB to SQL Server and link all tables in our
access Access DB to SQL Server.  But it is found that our application has
problem in access data in the system.

I have compared the table and data in both system and it seems that they are
the same.  Are there any suggestions in the setup?

Best regards,
  Francis



Mon, 04 Nov 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Upsizing SQL 6.5 to SQL 7.0

2. How to open an upsized SQL Server 7.0 Database through VB6

3. ms access 2000 and sql 7.0

4. MS Access and SQL 7.0 databases with VBScript

5. access + MS SQL server 7.0 over dial up line

6. Is MS-SQL 7.0 Desktop replace Access ?

7. progress bar error by modification (MS Project 2000, MS SQL 7.0 and IIS 5)

8. Can I Use Access DB IN MS SQL SERVER

9. Help - Access yes/no fields upsized to SQL Server SQL_BIT fields

10. upsizing from Access 2000 to SQL 7

11. Upsizing ACCESS to SQL SERVER, Need Help

12. NEWBIE : UPSIZE .RPT from ACCESS to SQL SERVER

 

 
Powered by phpBB® Forum Software