Re: Code Issues



AFKAFB wrote:

Why would AutoCorrect affect this ?  It happens to be switched on at
the moment.

Auto corrupt is a feature I've been turning off on every new mdb I make since I began using A2003 and read Allen Browne and others' advice on it.


It may well be a good idea for you to do what Salad suggested and create a new mdb and make sure autocorrect is turned off. Then use the get external data to bring the stuff from your current mdb into it.

I'm not sure if a decompile would be necessary after doing this, but I don't think it will hurt (notwithstanding Doug's caution). I find A2003 creates enormous mdb files and the decompile and then a compact helps me get things down to a manageable level. I've done some very involved apps in A97, for example, that never exceeded 5 megs in size. In A2003, I'm lucky to get anywhere near this size, though the big front enc app I'm working on presently is the largest I've ever done.

I also second Darryl's advice, I've run into irritating problems like he describes many times in the versions of Access I've used.


-- Tim http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "What's UP, Dittoooooo?" - Ditto .



Relevant Pages

  • Re: Multiple MDB files???
    ... Your advice is absolutely wrong, if you care about the data. ... BTW we have 27 back end mdb files. ... >> I have a databse with an Access front-end on everyone's individual PC ... >> more sense to create multiple back-end data files or if just one would be ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Security setup, completely lost
    ... I would delete all mdw files. ... Yes create a new mdb and import everything from you old mdb. ... If you have any advice please help. ... I gather that you are following the steps in the security FAQ. ...
    (microsoft.public.access.security)
  • Re: How do I programmatically import a class module?
    ... Holy file-shrinking batman! ... decompiling shaved 33% off the MDB, taking it from 8.9 down to 5.7. ... that is going to make life a ton easier for my people. ... for all your advice. ...
    (microsoft.public.access.modulesdaovba)
  • access mdb connection also requests .mdw connection for system db
    ... Hi, I have a regular .mdb that's called in my app as a subreport, works fine. ... Thanks for any advice. ...
    (microsoft.public.dotnet.languages.vb)
  • access .mdb connection also requests .mdw system .mdw connection i
    ... Hi, I have a regular .mdb that's called in my app as a subreport, works fine. ... Thanks for any advice. ...
    (microsoft.public.vb.crystal)