Online databases and VB 6 Pro? - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Online databases and VB 6 Pro? (/showthread.php?tid=38448)
Online databases and VB 6 Pro? by Salem on 02-14-2005 at 11:19 AM
Is ther a way to have a Microsoft Access database located on the internet and still be able to access it using Visual Basic 6?
This would be very helpful for me as i dont want my program to download the Access file all the time and then read it from the hard drive. If this is not possible, can you give me some code that will delete the downloaded Access file from the computer when it is no longer needed?
Thanx in advance
RE: Online databases and VB 6 Pro? by Ash_ on 02-14-2005 at 11:27 AM
quote:
Originally posted by RileyM
Is ther a way to have a Microsoft Access database located on the internet and still be able to access it using Visual Basic 6?
yes, but the server with the Database on it would require a program.
then you connect to the IP of the server using Winsock api calls, send your (sql) command.
then have the program on the server execute the SQL, send back the results, then you parse them locally.
go look up some SQL tutorials for Program to Database connections if you dont know that already
.as the for the Access file i dont understand, i dont use the Microsoft Access program if thats what you are talking about.
im sorry if this doesent help.