Is there anyway of connecting to a remote database on another pc to add, edit or delete records in the database there?
Printable View
Is there anyway of connecting to a remote database on another pc to add, edit or delete records in the database there?
What type of database are we talking about here?
How are you connecting to the other PC?
er.........wat type of database? a database in access in my case
how am i connecting to the other pc? hm........i'm not sure either
sorry for the blur response, i'm not so good in vb database, could you explain to me how u would do it?
Yes, what you are describing is entirely possible but you cannot use DAO database programming to do it. You have to use ADO because it allows remote connection to databases (even online ones like SQL server). As far as the code, check www.freevbcode.com or on here for tutorials on how to use ADO, there are lots of them out there.
Nathan
Here is a link to a tutorial on how to switch from DAO to ADO (assuming you know DAO already of course :-) )
http://www.vbsquare.com/databases/begado/index.html
Nathan