Results 1 to 5 of 5

Thread: Connecting to a remote database

  1. Jul 3rd, 2002, 03:35 AM #1
    fkheng
    fkheng is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Posts
    332

    Connecting to a remote database

    Is there anyway of connecting to a remote database on another pc to add, edit or delete records in the database there?
    Reply With Quote Reply With Quote
  2. Jul 3rd, 2002, 04:52 AM #2
    simonm
    simonm is offline
    Fanatic Member simonm's Avatar
    Join Date
    Sep 2000
    Location
    Devon, England
    Posts
    796
    What type of database are we talking about here?

    How are you connecting to the other PC?
    Everything I say is either loose interpretation of dubious facts or idle speculation rooted in irrational sentiment.
    Reply With Quote Reply With Quote
  3. Jul 8th, 2002, 02:33 AM #3
    fkheng
    fkheng is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Posts
    332
    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?
    Reply With Quote Reply With Quote
  4. Jul 8th, 2002, 08:46 AM #4
    ironwill96
    ironwill96 is offline
    New Member
    Join Date
    Jul 2002
    Location
    NC, USA
    Posts
    4
    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
    Reply With Quote Reply With Quote
  6. Jul 8th, 2002, 08:48 AM #5
    ironwill96
    ironwill96 is offline
    New Member
    Join Date
    Jul 2002
    Location
    NC, USA
    Posts
    4
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width