Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Unanswered: access and windows profiles problem?

    Hi All, new to this forum. I'm a statistician by trade, and have only a rudimentary knowledge of databases. In Access, I can do the simple stuff, build tables, forms, queries, a few simple macros, but that's about the extent of it. I've recently inherited a project where Access must talk to some scanning software and I've run into a problem that is way over my head. I'm running XP service pack 3 with office 2003. The scanning software is Cardiff teleforms 10.x.

    All the software is installed locally in the usual places. Office was already installed before I installed the scanner stuff under my windows profile. My profile has full admin privileges (the profile is actually for our whole network). After the install, everything worked just as it should have under my profile. Scan a form->scanner reads data->exports data to an Access container. Great. Now we want to have a lab tech do the same thing under her profile. everything works fine till the export, which fails. The error message from Access says the failure is because a required field (our primary key) cannot be null, and sure enough, when we look at the table all fields are empty.

    So I call our IT guy and he changes the tech's profile to have full privileges to everything on that machine. Still fails. Switch back to my profile and repeat exactly the same procedure, and everything is fine again. We create a local profile on the machine with full privileges. That fails, too.

    We spoke at length to the Cardiff people and they were pretty convinced it was an Access issue. So here I am, looking for help. I am assuming that the problem has something to do with having installed the software and running it for the first time under my profile, but I have no idea where to even begin a fix.

    Sorry if this is a bit vague or if I haven't used the right language, but it's the best I can do given my level of knowledge. Can any kind soul point me in the right direction?

    Thanks,

    Mike Babyak

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    it may well be an access issue
    the message is tellignyou that there is no priamry key data
    so I'd want to know what fills the primary key.. if its autonumber then it suggests there is somehtign wrong with the interface between cardiff any Access. my immediate suspisicion there would be to make certain you are usign the saem or simialr build of stuff as Cadiff suggest

    it could be the JET library is incomaptable
    it could be the access library is oncompatable


    it coudl be soemthign as dumb as makeing certain the access file is enabled for read write
    it could be the netwrok /file / directory permissions need settign to allow read write access.. that's be down to your netwrok trolls

    it could be permissions with access for that user... I don't know if you are explicitly using access workgroup security.

    ultimately as I read it, irrespective of whether the problem is in Access or not, ultimately the ownership of the problem is Cardiff teleforms, after all its their interface that is failing.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2009
    Posts
    2
    Quote Originally Posted by healdem
    it may well be an access issue
    the message is tellignyou that there is no priamry key data
    so I'd want to know what fills the primary key.. if its autonumber then it suggests there is somehtign wrong with the interface between cardiff any Access. my immediate suspisicion there would be to make certain you are usign the saem or simialr build of stuff as Cadiff suggest

    it could be the JET library is incomaptable
    it could be the access library is oncompatable


    it coudl be soemthign as dumb as makeing certain the access file is enabled for read write
    it could be the netwrok /file / directory permissions need settign to allow read write access.. that's be down to your netwrok trolls

    it could be permissions with access for that user... I don't know if you are explicitly using access workgroup security.

    ultimately as I read it, irrespective of whether the problem is in Access or not, ultimately the ownership of the problem is Cardiff teleforms, after all its their interface that is failing.
    Thanks for the reply. AFAIK, based on our conversations w Cardiff, everything we are running is within their recommended specs. And you're right, I felt like they should be doing more (esp at $8k for the software and service agreement). But they aren't at least until I get more desperate, anyway.

    The primary key is a prefill already printed on the hard copy of the form, not something Cardiff generates per se. Since the whole thing works under my profile, I'm guessing it's access security, but that's where I run into my total ignorance. I've never set up any security stuff in Access. I assume there is some default security setting, as none of us has done anything explicit wiht it. But I'll also look into the read/write thing, too just to make sure.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    its more likely to be user account security at the operating system level in my books if you have proved its working in Access. Unless, as said earlier, you are limiting access to things within the application using workgroup security

    if you have paid $8K then its about itme they got off theiur arses and really helped.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •