Connecting Tech Pros Worldwide Help | Site Map

MS Access remote access from ADO

  #1  
Old November 13th, 2005, 08:52 AM
Besbello
Guest
 
Posts: n/a
Hi all,
first of all, sorry, my English is horrible.
I have a local Borland Visual C++ application that uses an Access .mdb
file as DB. I need to make this application distributed, with a
centralized DB and many clients accesing to it. Could somebody suggest
a way to do this if:

- If possible, I want to keep Access as DB, because I would have
probably to change many queries and I donīt have enough time to do it.
If possible, we wonīt to use a database server, like MSDE or MySQL (as
you can see, we can afford a licensed product as SQLServer).

- I can connect a client to a .mdb file in another machine in my LAN,
so I know I can solve the problem by using a VPN, but we want to avoid
it, too. Is there any way to connect my program to a remote .mdb file
(through the Internet) without using a database server?

Is there any way to do what I want? Perhaps it's impossible....
Any help would be very appreciated.
Thanks and sorry again,

Besbello
  #2  
Old November 13th, 2005, 08:53 AM
Tom van Stiphout
Guest
 
Posts: n/a

re: MS Access remote access from ADO


On 3 Mar 2005 10:31:47 -0800, besbello@gmail.com (Besbello) wrote:

Right. You first tie both of my hands behind my back, and then you're
asking for my help?
Translation: don't say "we can't do this, and can't do that". Those
are (hopefully) conscious decisions, and who makes them should be
willing to live with the consequences.

Access db's can only successfully be accessed over the LAN or using
some form of terminal services.

-Tom.

[color=blue]
>Hi all,
>first of all, sorry, my English is horrible.
>I have a local Borland Visual C++ application that uses an Access .mdb
>file as DB. I need to make this application distributed, with a
>centralized DB and many clients accesing to it. Could somebody suggest
>a way to do this if:
>
>- If possible, I want to keep Access as DB, because I would have
>probably to change many queries and I donīt have enough time to do it.
>If possible, we wonīt to use a database server, like MSDE or MySQL (as
>you can see, we can afford a licensed product as SQLServer).
>
>- I can connect a client to a .mdb file in another machine in my LAN,
>so I know I can solve the problem by using a VPN, but we want to avoid
>it, too. Is there any way to connect my program to a remote .mdb file
>(through the Internet) without using a database server?
>
>Is there any way to do what I want? Perhaps it's impossible....
>Any help would be very appreciated.
>Thanks and sorry again,
>
>Besbello[/color]

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disconnecting from a MS Access database using VB.Net - ADOX ldb issue mchirouze answers 0 December 27th, 2007 07:08 PM
Data entry and processing - MS Access okay? SRAM answers 5 May 10th, 2006 07:25 PM
How to remote Access database from VB6 mamatha answers 4 November 21st, 2005 12:26 AM
MS Access Database Replication from VB Bie answers 1 July 17th, 2005 09:01 PM