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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is Access the best solution?

Status
Not open for further replies.
olekr

olekr

Instructor
May 27, 2001
19
NO
Hi folks!
I have made several Access db with VB60 on top. Front and back end system. What do you think is the best db solution to sell to small companies which not have Access? Is it perhaps MS SQL in bottom and use VB as interface?
Regs Ole
 
Sort by date Sort by votes
For small or medium size databases with few concurrent users, Access is fine. sql server is necessary if many users are going to connect at the same time, if the amount of data is very large or if u need extra functionality like stored procedures and so on.
 
Upvote 0 Downvote
Hi!
I have never testet a db with Access-tables in bottom without having Access on the file server or client PC. Is it possible?
Ole
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
589
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
244
ahmedsa2018
ahmedsa2018
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
400
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
3K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top