Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrating To SQL Server

Status
Not open for further replies.
sixsmithc

sixsmithc

Technical User
Feb 2, 2001
21
0
0
GB
Just after some advice really .....

I have a written a VB program for accessing an Access database - the main table in this database has roughly 300,000 records and 25 fields. I am thinking of moving to SQL server anytime soon - does anyone think there will be enough of a performace benifit to justify the extra costs / development time for this small number of records or do you think Access will be able to handle it?

Thanks

:)
 
Status
Not open for further replies.

Similar threads

Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
99
Andrzejek
Andrzejek
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
616
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
112
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to use a combo box to get data from SQL? 1
Replies
1
Views
56
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to get data from sql into a combo box in vb6?
Replies
3
Views
86
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top