By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,035 Members | 1,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,035 IT Pros & Developers. It's quick & easy.

Desperate: Save as Text/Load From Text

P: n/a
Access 2003.

Will someone please explain how to do this? My applications have all
become so absolutely despairingly *&^%ing corrupted - I have no idea
why - I honestly suspect some asinine XP update as being the culprit
as one day this summer all of a sudden, compact and repair started
crashing my applications all of which had never experienced any
problems until then.

AND PLEASE DON'T SAY "GOOGLE IT"! Google won't produce any results
when one Googles "Load From text" and Googling "Save as Text" just
produces a bunch of messages with Larry telling people to Google for
it.

Thanks ever so much. I have lost all faith in Access 2003 as a stable
platform in my organization.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Sep 5 '08 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Have you tried creating a new blank database and importing everything into
it from the corrupt Db?

Phil

"Timmy!" <tm******@mun.cawrote in message
news:63**********************************@59g2000h sb.googlegroups.com...
Access 2003.

Will someone please explain how to do this? My applications have all
become so absolutely despairingly *&^%ing corrupted - I have no idea
why - I honestly suspect some asinine XP update as being the culprit
as one day this summer all of a sudden, compact and repair started
crashing my applications all of which had never experienced any
problems until then.

AND PLEASE DON'T SAY "GOOGLE IT"! Google won't produce any results
when one Googles "Load From text" and Googling "Save as Text" just
produces a bunch of messages with Larry telling people to Google for
it.

Thanks ever so much. I have lost all faith in Access 2003 as a stable
platform in my organization.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Sep 5 '08 #2

P: n/a
http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
or
http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
may help.

Maybe.

Perhaps.

Depending.

If all else ....
On Sep 5, 9:15*am, "Timmy!" <tmars...@mun.cawrote:
Access 2003.

Will someone please explain how to do this? *My applications have all
become so absolutely despairingly *&^%ing corrupted - I have no idea
why - I honestly suspect some asinine XP update as being the culprit
as one day this summer all of a sudden, compact and repair started
crashing my applications all of which had never experienced any
problems until then.

AND PLEASE DON'T SAY "GOOGLE IT"! *Google won't produce any results
when one Googles "Load From text" and Googling "Save as Text" just
produces a bunch of messages with Larry telling people to Google for
it.

Thanks ever so much. *I have lost all faith in Access 2003 as a stable
platform in my organization.
--
Tim *http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Sep 5 '08 #3

P: n/a
On Sep 5, 12:19 pm, "Phil Stanton" <p...@myfamilyname.co.ukwrote:
Have you tried creating a new blank database and importing everything into
it from the corrupt Db?

Phil

Hi Phil, thanks for the response. That doesn't work. Decompile
doesn't work. The darn thing compiles properly when I click Debug-
>Compile.
Something is really whacked out.
--
Tim
Sep 5 '08 #4

P: n/a
On Sep 5, 1:36 pm, lyle fairfield <lyle.fairfi...@gmail.comwrote:
http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
orhttp://www.ffdba.com/downloads/Save_ADP_Objects_As_Text.htm
may help.

Lyle, thank you very much.

It turns out that Googling "Save as Text" and /or "Load from text" was
getting me nothing. However, after reading your pages and then
googling these expressions without the spaces, I was able to find more
posts.

Your code is much appreciated - I have a ton of objects.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Sep 5 '08 #5

P: n/a
On Sep 5, 1:36 pm, lyle fairfield <lyle.fairfi...@gmail.comwrote:
http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
orhttp://www.ffdba.com/downloads/Save_ADP_Objects_As_Text.htm
BTW, aren't these the same link? In any event, I tried your code
after doing things "handraulically" (which was brutal). I remmed out
a few things that didn't come onto the web page with a ' and I also
did the same to the with app/end app code in you main sub as I didn't
understand what it did - I work with mdbs and wasn't sure what the ade
stuff is.

Anyway after both methods (yours, altered as above, and the handraulic
method), the shift-compact and repair seems to be working without
crashing the damn things (fingers crossed).

I may have a flakey network card - sometimes two or three times a day,
I lose connection to our network, the internet and, most importantly,
the Oracle database against which my mdbs are written. I suspect it
was one or more of these instances that have done this. When I get a
new PC, I'm going to take this one to the top of our Memorial tower
and drop it laughing maniacally.

Thanks so much (again with fingers crossed)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Sep 5 '08 #6

P: n/a
One shoulda said
http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
"Timmy!" <tm******@mun.cawrote in news:05621b48-91f4-447b-8e3a-
20**********@a70g2000hsh.googlegroups.com:
On Sep 5, 1:36 pm, lyle fairfield <lyle.fairfi...@gmail.comwrote:
>http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
orhttp://www.ffdba.com/downloads/Save_ADP_Objects_As_Text.htm

BTW, aren't these the same link?
Sep 6 '08 #7

This discussion thread is closed

Replies have been disabled for this discussion.