Re: Novice needs help - solution questions

Tech-Archive recommends: Speed Up your PC by fixing your registry


"Michael Cole" <noone@xxxxxxxxxx> wrote in message news:e12o6hQVFHA.3424@xxxxxxxxxxxxxxxxxxxxxxx
> 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 agree, it is not good coding. That is a suggestion I received. At this point, I am willing
to try anything that resolves the problem.

>
> 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.

What I need is a good tutorial. I am hoping to learn to use the database in my programs. I
have asked for a text on VB and DAO, but no one has been able to give me a text name. Yes, I have
been considering starting again, but would like a *good* text as a guide in the process. I want to
create a database program that works.

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
>

Thank you for your comments. I do agree with them.
Jim Y


.

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, ... "bug fix" of destroying a form does not cause more issues, ...
    (microsoft.public.vb.database.dao)
  • Re: Import Text with existing schema.ini file utility
    ... the database engine looks for schema.ini. ... As far as I know it's not possible to specify schema.ini in SQL; ... DAO is specifically designed to work with the Jet ... >> oDB.Execute strSQL ...
    (microsoft.public.access.modulesdaovba)
  • Re: Run action query in back-end from front-end database
    ... whatnot in the back end database. ... The queries are housed in the back end ... The reason I have the upload tables in the back end is that it will be on ... Rick's code uses DAO, and Access 2000 doesn't have a reference set by ...
    (microsoft.public.access.externaldata)
  • Re: Dao350.dll unsupported under Windows 7
    ... Jet 4.0 is that we have many customers now using our app with DAO 3.51 ... standard user account in Windows to ensure none of the Sandbox ... tried one of our menu commands: Compact Database. ... CloseDB, didn't close the db and left an ldb file lying around. ...
    (microsoft.public.vb.general.discussion)
  • 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)