Connecting Tech Pros Worldwide Help | Site Map

MS Access remote access from ADO

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 13th, 2005, 07:52 AM
Besbello
Guest
 
Posts: n/a
Default MS Access remote access from ADO

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, 07:53 AM
Tom van Stiphout
Guest
 
Posts: n/a
Default 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]

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.