MS Access remote access from ADO

[Besbello]

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]

On 3 Mar 2005 10:31:47 -0800, be******@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.

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