"David W. Fenton" <(E-Mail Removed)> wrote in message
news:Xns9939DE06AC434f99a49ed1d0c49c5bbb2@127.0.0.1...
> "Amy Blankenship" <(E-Mail Removed)> wrote in
> news:(E-Mail Removed):
>
>> "David W. Fenton" <(E-Mail Removed)> wrote in message
>> news:Xns99398A6BBA3E3f99a49ed1d0c49c5bbb2@127.0.0.1...
>>> "Amy Blankenship" <(E-Mail Removed)> wrote in
>>> news:O#(E-Mail Removed):
>>>
>>>> I have a piece of software that I have built that tracks user
>>>> interaction to an Access database that gets installed to the
>>>> user's computer in their UserApplicationData folder. For one
>>>> user, I have been able to determine that the software is not
>>>> able to communicate with the database. I have verified that the
>>>> user has Jet 4 installed and that he is on XP SP2.
>>>
>>> From other posts in the thread, it's clear you're using ODBC to
>>> communicate with the data. Thus, you are not using Access for the
>>> front end. ANd that means that your statement that you're
>>> interacting with an Access database is false -- you are not using
>>> Access at all (though you may have used Access to create the
>>> MDB), but you are using Jet.
>>
>> I did say I was using Jet.
>
> If you were using Access, you could be using Jet, too. The key point
> is that you are *not* using Access, which was not made clear.
The database driver I am using is Microsoft Access Driver (*.mdb). So
whoever named the drive clearly _does_ consider the driver to be to a
Microsoft Access database, however _you_ care to argue the semantics of the
situation.
>>> Those are important details that you need to spell out to get
>>> help when posting to an Access newsgroup.
>>
>> "Those" is a pronoun you are using here, apparently without an
>> antecedent. I can't really provide "those" details without knowing
>> which details you actually want.
>
> Here are some suggestions:
>
> 1. what language/platform you are programming in.
Macromedia Authorware. I didn't expect that anyone here would have ever
used it or know its characteristics, so it didn't seem relevant.
> 2. what errors you are getting
None. It is not possible to get at that information.
> 3. what database engine you are using.
Jet.
> You provided the last, mixed in with claims of using Access, which
> implies an incorrect answer to #1, which is why someone asked you if
> you were using Environ(), which is a VBA command.
I am using an access database (tables contained in an mdb file, if for
whatever reason you don't consider that to be an Access database) as the
data source for an exe that is not an access database.
>>> It is unlikely that your problem has anything at all to do with
>>> Jet, in my opinion, and is entirely something wrong in your
>>> program, whatever language you happen to be using to write it.
Well that's interesting, but the question was actually if it is a Jet
problem, what could it potentially be? So regardless of whether I am
correct or not correct I need to research the possible issues that could be
causing it. I don't need a complete primer on all causes, just some
pointers on areas to search. Sometimes the right search term can make all
the difference.
>> Why are you posting to this thread? I am specifically asking for
>> theories of what could be wrong on the Jet side.
>
> And from what you've said, I'm telling you that it's unlikely to be
> a Jet problem.
I am aware that you are telling me that. However, just because you are
telling me that doesn't mean you're right. I'm not always 100% right in all
the answers I give in the areas where I am an expert. Sometimes it's a
situation I have not encountered yet or something I have incompletely
understood. Are you _so_ perfect then that you are _sure_ it couldn't be
Jet? Or are you simply saying that your experience has not yet come up on a
situation where Jet failed, so it is something that you are unable to
formulate theories on?
>> I am a world recognized expert in
>> the software I used to write the program.
>
> Oh, I BOW DOWN TO YOUR EXPERTISE!!!!!!!
Cool. Thanks. Could you kiss my toes while you're down there? My
husband's been working awfully hard lately...
>> Therefore, there is no one I can
>> ask about problems on that side. I am relatively inexperienced
>> with Access and Jet, so I am coming to gather more information on
>> the part of the equation where there are people available who know
>> more about the situation than I do. So if you have some helpful
>> theory to add, great. Please do so. But if you're just posting to
>> say I'm an idiot to be asking questions, please don't bother.
>
> If you're such a great programmer, why have you written a program
> that doesn't report error messages from the components you are
> using? That's completely idiotic and unprofessional.
Are you seriously telling me you report all errors of any kind that occur in
your programs to end users? I am amazed that any of them come back. I _do_
perform error trapping, of course, but to show each and every error that
occurs (some deliberate) to end users would be the end of my career.
> Nobody can help you at all until you have identified the error that
> is occuring.
Wow. I find it appalling that the entire Access community is so ignorant of
how Jet works that among them they can't formulate a single theory of how it
could fail without an error message being provided. For instance, couldn't
it be this:
http://support.microsoft.com/kb/174655/en-us But no one _here_
came up with that link or anything comparable. Come on. I know there has
to be _someone_ around here who's got enough experience behind him/her to at
least venture some educated guesses.
-Amy
Similar Threads
