Access Vs MS SQL Server 
Author Message
 Access Vs MS SQL Server

Hi, I have an application written in VB4 that uses Access databases. I use
data controls only for binding to dbgrids, dbcombos or a 3rd party grid. I
use the opendatabase, createsnapshot, createdynaset, etc, schema to make
the updates to the database. The database is getting larger and i need to
move to anothe databse engine.

Question:
Can I move to MS SQL Server without making a lot of changes to the code ?
Someone told me that I only needed to change the database
opening/connection part of the code ?

Thanks in advance.



Thu, 20 Jan 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. MS Access 2002 vs VB.net as a front-end to SQL Server data

2. MS SQL SERVER vs ACCESS on busy network

3. MS Access vs. SQL Server

4. Access vs SQL Server vs Sybase vs Oracle

5. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

6. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

7. Executing MS SQL Server 2000 stored procs via MS Access 2000

8. Moving Oracle records to MS SQL Server using MS Access

9. Complicated Record Handling on MS Sql server and MS Accesses Databases

10. CA-Prog Analyst, MS SQL Server, Visual Basic and MS Access

11. Access to MS ACCES and MS SQL server

12. Application Development: MS-Access, Visual Basic, SQL Server, SQL Anywhere

 

 
Powered by phpBB® Forum Software