Results 1 to 2 of 2

Thread: remote data with SQL

  1. Aug 14th, 2001, 05:55 PM #1
    alistair4267
    alistair4267 is offline

    Thread Starter
    Member alistair4267's Avatar
    Join Date
    Jul 2001
    Posts
    45

    remote data with SQL

    hi

    i have created a database in ACCESS 2000 and uploaded it to my mates server with is a (UNIX server) i have a list view with 3 colums:

    ID
    UserName
    Password

    i want to be able to connect to the database which is on my mates server, and allow to listview to display what is in the database? How can this be done?

    is supports SQL

    thanx

    alistair4267
    Reply With Quote Reply With Quote
  2. Aug 14th, 2001, 08:44 PM #2
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    Well as long as you can see the .mdb on your mates server then you should be fine!

    I mean, if you connect to your mates server via a phone line or something and you know where the db lives you've got your path to your db.
    The use dao's tabledef or adox to view tables forms or if you want the actual data do it the usual way.
    If you dont quite know the usual way see Karls tutorials on DB's on www.vb-world.net

    Other things look at using ASP perhaps.
    Or when connecting download the db onto your computer using the inte control then run it from there!

    Hope that isnt too confusing!
    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