Re: Novice needs help - solution questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Jim Y wrote:

> I am not able to isolate the code that is creating the problem. At
> this time I just know that I cannot save two or more jobs in
> succession to the database. Because I can't find it, I posted the
> query in the newsgroup. I was/am hoping someone could help me locate
> my problem. I don't know enough about DAO database programming to
> know what is correct and what is not. I have posted some code and
> readers could not find anything wrong. Obviously, I don't know where
> to look for the problem. I need suggestions.
>
> The program has more than 25 forms and modules and compiles to an EXE
> file of more than 1 MB. I am going to try to provide an outline
> description of the program and will post it when finished. Maybe
> then someone can give me an idea what/where the problem lies.

Jim,

This is not meant to sound harsh, so my apologies beforehand if it does.

Through all your posts here, what is coming through to me is that you have
jumped into the deep end, and are only now realising that you can't swim. I
don't think that it is a bug that you have, it is a design flaw. Closing
forms in order to get database operations working corectly is not a bug
fix - it is a work-around.

I would strongly suggest that you start again, preferable using the DAO
recordset object and as few forms as you can. If nessesary, use the Data
Bound Controls until you get to your feet. I tend to feel that even if your
"bug fix" of destroying a form does not cause more issues, there will be
many more that you will encounter. The issue that you highlighted is a very
basic matter that you should have found out before releasing the product,
and the mere fact that you only found out about it after release indicated
to me thet it has not been tested very well.

It seems that this is just a private "freeware" product, not a commercial
product - consider it as simply a learning experience. Don't start spending
enourmous amounts of time and frustration on it - its not worth it.

--
Regards,

Michael Cole


.

Relevant Pages

  • Re: Novice needs help - solution questions
    ... > Jim Y wrote: ... I don't know enough about DAO database programming to ... > don't think that it is a bug that you have, ... > I would strongly suggest that you start again, preferable using the DAO ...
    (microsoft.public.vb.database.dao)
  • Announce: Release 0.70 of BDB-BASIC is now available
    ... Database functionality has been tested and bug fixed. ... The variable length string content is now preceded by a 1 ... BUG FIX HIGHLIGHTS: ...
    (comp.lang.basic.misc)
  • Re: crashes when copied...
    ... Might be this bug: ... You might try importing everything into another database. ... 304548 ACC2000: Error Message: Error Accessing File. ... Open Form/Report in design view and select menu option View> Code ...
    (microsoft.public.access.formscoding)
  • Re: From CB8 to CB9
    ... Its not the money that matters, playing tournaments, you know the best tools ... > NEVER experienced a corrupted database so far in SCID. ... > experience any grave bug and never lost any data... ...
    (rec.games.chess.computer)
  • Re: Problem with email attachment, 1 becomes 10
    ... My CV should be attached as a pdf-file. ... One piece of advice which has been useful to me which I learnt from the posting guidelines for this group is, before posting, to always try to reduce the problem to the minimum possible, let's say ten or twenty lines of code: ... In the case of your program there are two big chunks: first, lots of stuff involving reading lines from the database, which is where I suspect the problem has occurred, probably some kind of slip-up, but I can't prove this because I don't have the database available, and then there is an almost separate piece of code which involves sending a mail with an attachment, which might be where the bug happened, although I think it's unlikely. ... I have repeatedly had problems in Perl which I thought were incredibly difficult, ended up frustrated enough to want to post them here, and in the business of reducing them into a short newsgroup post as described, I ended up surprising myself by working out what the bug was without having to post it. ...
    (comp.lang.perl.misc)