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 TouchToneTommy 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
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

Swi
  • Locked
  • Question
Printer.Print to PDF 1
Replies
16
Views
1K
Swi
Swi
sal21
  • Locked
  • Question
Based the link above how to simulate click event
Replies
4
Views
334
2009luca
2009luca
sal21
  • Locked
  • Question
I can't find the routine to download the image file anymore
Replies
1
Views
280
strongm
strongm
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
576
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
possible to use xml2 or Set WHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1"), instead code in message
Replies
5
Views
487
2009luca
2009luca

Part and Inventory Search

Sponsor

Back
Top