Connecting Tech Pros Worldwide Help | Site Map

MS Access remote access from ADO

Besbello
Guest
 
Posts: n/a
#1: Nov 13 '05
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
Tom van Stiphout
Guest
 
Posts: n/a
#2: Nov 13 '05

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