My Access mdb file is updated daily

[acadid]

My Access mdb file is updated daily...here how it works :

A scheduler in vb launch a program in a module of my Access file...

This program launch queries based on some ODBC linked Progress tables
Access tables are created with final query information.

Those query created tables in Access need to be accessed by my vb app on many clients pc outside the building...

Client VBapp can need to access my Access file at any time, except at night most of the time when the creation process is in progress....


I want to know how can my VB6app access the mdb file with ado over the internet...

Help please..!

 

[KCI]

Hey,

From what I know, you really don't tell ADO any specifics about whether the access is local or over the net. ADO just needs to be able to resolve the computer name to the correct IP address. This is an issue that your network people can help with. the answer will involde mapping computer name to IP addresses this is done using DHCP or host tables. It depends on your network topograph (that is why you need your network guys and gals).

jjjjuuusssttt exxpeecct ittttt toooooo bbbbeeeee reallllyyyyy sssslllloooo

http://wwwww.

so bump up your timeouts. ~

good luck,
KCI