Access not returning all rows on most desktops.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a VBscript that has been modified to work on 3 different Oracle views,
and all 3 work great on my desktop. I have 1 of them, that only hits 1
Oracle view, and brings back 6 fields to populate the Access table, I pass
the user ID and password in the script, so it shouldnt matter who you are
loged in as. The .mdb is on a land drive, and It works great from my desktop,
no matter who is logged into my desktop, but it only returns 3 of the 6
fields from anyone elses desktop, and always the same 3. I have checked
Access and Oracle client versions on each desktop, but they are the same.
Any ideals? Thanks
 
I was wrong, I did find a differences in the desktops, my Access version is
2002 sp2, where everyone else is sp 3. hmmm, I am afraid to upgrade mine,
then no one can run it correctly.
 
Back
Top