Re: Save As Text Question

On Feb 24, 9:30 pm, lyle fairfield <lylef...@xxxxxxxx> wrote:
Access 2003 is the only version of Access in which this code has not been
extensively used by me.
I suggest that you remove the line "on error resume next” from the first
procedure and run the code again.
In all likelihood an Error Message will appear. Click Debug. The line where
the error occurs should now be high-lighted.
Tell us what line it is.

I'm starting to suspect that it may be the actual installations of
A2003 on both my desktop and laptop. Here's why:

On my desktop which was running A2003 SP2 the database fell over with
the generic "Microsoft Access has stopped working" as soon as I tried
to run the code. As an experiment I installed SP3 and the SP3 hotfix
and now the code runs fine.

On my laptop which is running A2003 SP3 with the SP3 hotfix applied,
when I run the code it stops at
app.LoadFromText acForm, Name, FileName
in the LoadFormsFromText sub. The forms have actually been saved as
text files, it just doesn't want to load them.

So now I have a situation where it runs fine on one installation of
A2003 SP3 and doesn't on the other. I suspect that the install of SP3
on the desktop has fixed whatever the problem was with the
installation of A2003 on that machine, and that the installation of
A2003 on the laptop may also have a problem.

I know that quite a few users have both A2003 and A2007 installed on
the same machine, but I wonder if this can cause obscure problems such
as the one I have experienced.

Also, given that it appears that SaveAsText is the only way to recover
from some database corruption problems, I wonder why Microsoft has
left it as an "undocumented" feature and not included it as a database
tool.

Having said all that, thanks for the reply even though I've probably
wasted your time.


.

Relevant Pages

  • Re: HELP! No Internet connection after failed update of Win XP SP3
    ... my problem is that I don't have access to the internet from my laptop any ... Installing SP3 Notes ... Internet Explorer and WinXP SP3 ... XP SP3: Post Installation Cleanup ...
    (microsoft.public.windowsupdate)
  • Re: Is WinXP Sp3 update necessary?
    ... - Whom told you that SP3 was for improved security? ... SP1a and SP2. ... Also - you eliminate any strange download ... installation and update of the SP3 is something of concern. ...
    (microsoft.public.windowsxp.general)
  • I experienced the same situtation
    ... Most likely after installation of SP3 ... uninstall all usb device and restart ... since USB connectivity is constantly disrupted. ...
    (microsoft.public.windowsxp.hardware)
  • Re: WUD or MUD repeatedly tells me that there are no available upd
    ... I could not uninstall SP3 because the uninstaller could not ... how to uninstall and of the 4 methods, ... uninstall it and enable the Windows Firewall at this point! ... It may take 1-2 hours for the installation to complete so ...
    (microsoft.public.windowsupdate)
  • Re: Is WinXP Sp3 update necessary?
    ... Slow boot up time.. ... Then when the installation is complete I ... Before the SP3 installation, the boot up time was just slightly above ... restore your most recent image. ...
    (microsoft.public.windowsxp.general)