Accessing Remote MSAccess Database with ADO.Net

  • Thread starter Thread starter Voyager
  • Start date Start date
V

Voyager

Hi,

How can I connect to an access database located over a remote server
through internet?

Is it possible if updating a remote database is done in background and
application doesn't affect by delay in accessing remote Server?

Best Regards,

Wasim
 
Hi Voyager,

Since access database is a file, you will have to enable access/modifying
security of the file and probably of the folder where file resides (since
access will want to create also ldb file).
If you are using security within access I believe you will have to also need
to access security file (mdw or something).
You can use a asynchronous delegate or a thread for updating.
 
On 19 Dec 2003 03:12:24 -0800, (e-mail address removed) (Voyager) wrote:

¤ Hi,
¤
¤ How can I connect to an access database located over a remote server
¤ through internet?
¤
¤ Is it possible if updating a remote database is done in background and
¤ application doesn't affect by delay in accessing remote Server?
¤

You need to use the Remote (Data Services) OLEDB Provider:

http://www.able-consulting.com/MDAC/ADO/Connection/MSRemote.htm#MSRemoteAccess

If I understand your second question, you will need to start another thread for
your application if you want the operation to run in the background:

http://msdn.microsoft.com/library/d...n-us/vbcn7/html/vaconFreeThreadingExample.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top