drewvancamp wrote:
>>>My data source is an Access 2003 table. I'm in Windows >>>2000. I'm using Visual Basic 6.0. I'm trying to use a >>>DataGrid control and I've tried to use an ADODC data >>>control for the connection. I've also alternatively >>>used ADODB.Connection and ADODB.Recordset controls >>>instead of the ADODC control. >>> >>> >>Are you already creating the connection via code and assigning it to >>the connection for the ADODC? >> >> > >No. At this point I get the same result when using the properties >pages for the ADODC control as I do when I create ADODB objects >programmatically as I do when I create a Data Environment and create >bound controls or datagrid or flexgrids. > > > >>>As I'm developing the application on my computer (and none >>>of my work is local to the machine, but loading, running, >>>and saving on the network folders), the application does >>>what I described above very successfully. When I try to >>>run the application on a different computer on the same >>>network, the only difference is that the datagrid does not >>>populate with data from the table. And as weird as >>>it seems, I receive absolutely no errors! >>> >>> >>This could be a permissions issue. Do the 'other computers' and >>their users have rights to read AND WRITE to the folder the mdb file >>is in? >> >> > >I'm pretty sure it's not permission issues, but I'm not sure yet. > >I've been developing my app on my PC (henceforth referred to as myPC) >to be run from a specific other PC (henceforth referred to as >targetPC). I developed an awesome interface on myPC. Then I tested >it on the targetPC and discovered that data wasn't showing up. This >disturbed me and I began to think it was permissions settings for the >targetPC's login. When I use my own network login (which has lots of >permission to do all kinds of stuff) on the targetPC, it still didn't >populate the datagrid. Still unsure what was wrong, I had my cubicle >neighbor run it on his PC (henceforth referred to as neighborPC). >His didn't populate with data either! > >Then I began to wonder if the Data Environment file was required, but >I ran the EXE on myPC (which did not have the DSR file nearby) and it >runs consistently perfectly on myPC. > >It seems myPC is the only computer on which the applications will >show the data. Why? What's different about my computer? We all >have the same basic permissions and access to the same folders. > >!? help > >- Drew >http://drewvancamp.com > > I think you will find that the actual data file is not located in the same place on each |PC, and you are not 'correctly' identifying the path. Are you using UNC paths or mapped drives? UNC paths will give you less problems. The second obvious question is do all the machines in questions have the same versions of MS Office installed? or is there a situation where install on demand is in place and your machine is the only one which has used access? Matt '// ======================================================= 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/
