Hi Drew, 

> Firstly, the path that leads to the data, if it were incorrect
> (and it did not find the MDB file), it would generate an error.
> Well I'm not receiving errors.  Secondly, the path is absolute
> throughout the network.  I'm giving the application the full
> path.

Have you tried disconnecting the ADODC and assigning the connection
to it via code? This usually corrects the path issues and the ADO
versioning problems inherent in the ADODC.

If you've tried this, can you show us your code?


> ...My neighbor's machine is an exact clone of my machine,
> software, ActiveX, libraries and all.  No errors, no termination
> of the app, ...and sadly, no data populating the grid, although
> the blank grid comes up nicely.  (:

How recently was the clone performed? Is it possible you've
installed the latest MDAC and Jet libs on your machine and not on
his?

Most of us here are very wary of any of the component-based
libraries from MS written for ease of use - the datagrids, data
controls and what not. They're, at best, unreliable, and, at worst,
a nightmare to ensure the environment is sound and satisfactory in
every scenario.


That said, does the application need to be able to write to the
database, or can it be used only for display?

Some things you might try:

* Have the application start via sub main, using a local path for
the MDB in the ADODC, then copy the MDB file from the network share
before loading the form. This will determine if it's a permissions
issue on the network share.

* Export the table for your datagrid into a CSV file, bind THAT to
the ADODC and see if it works. This will determine if it's an MDAC
or Jet problem.

* Have the application load a separate form that ONLY attempts to
read and write to a *new* text file using the FileSystemObject in
the net-share folder, then exits. Have it use something like a
machine-name + timestamp entry so you can validate that it truly
worked and from which PC. This will help diagnose permissions
issues.


Depending on your network setup this can be something as obscure as
rights permitted to a specific IP (yours) are not being shared
equally across all other IP's, or something as simple as the MDAC
version or a locked MDB file (because Access was 'looking' at it
while the app was being ran).

Regards,

Shawn K. Hall
http://12PointDesign.com/
http://ReliableAnswers.com/





'// =======================================================
    Rules : http://ReliableAnswers.com/List/Rules.asp
    Home  : http://groups.yahoo.com/group/vbHelp/
    =======================================================
    Post  : [email protected]
    Join  : [EMAIL PROTECTED]
    Leave : [EMAIL PROTECTED]
'// =======================================================
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/vbhelp/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to