Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Re: How To Rebu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 15 of 17 Topic 30207 of 31596
Post > Topic >>

Re: How To Rebuild Objects From Text Files?

by Wayne <cqdigital@[EMAIL PROTECTED] > May 18, 2008 at 10:49 PM

On May 19, 1:51=A0am, lyle fairfield <lyle.fairfi...@[EMAIL PROTECTED]
> wrote:

> A little further search brings up this error described but no
> suggestion as to its cause or cure. If you were to post the text file
> for the first form that fails, some of us might see if we can load the
> form into a database with the LoadFromText method. If so, we will know
> its not your form. If not, we might be able to study the problem in
> general terms, (or you could just send me the text file and I'll post
> it: lyle dot fairfield at gmail dot com).- Hide quoted text -

After a few hours of experimentation I've made a few observations.
The DB I am working with is an A2003 database, but I have a sneaking
suspicion that it is one that I have converted from A2000.  Not sure
if this has any bearing on anything but I im****ted all of the objects
into a new A2003 database and tried running the code again. It
partially worked this time. As before, all the objects were saved as
text, but this time some of the forms were im****ted from the text
files before it fell over.  I then tried im****ting some of the forms
that were missed on the im****t one by one by using the LoadFromText
method and this worked. This seems to indicate that there is nothing
inherently wrong with the forms.  When I view the forms they look and
work fine.

The scenario is the same on a couple of other databases that I tried
running the code on. Some of the forms will im****t, then the code
fails. I'm 99% sure that these are native A2003 databases and haven't
been converted from an earlier version. As to why the original code is
failing and not im****ting all the objects, I don't know.  It may well
remain a mystery of the ages.  At least now I know that in a worst
case scenario if I ever have to use this, I can ex****t all the objects
to text using the original code and then use the LoadFromText method
to im****t them all one by one.  Quite laborious, but it would work.

I intend to experiment with this further when I have a bit more time
on my hands and will post if I get to the root of the problem.
 




 17 Posts in Topic:
How To Rebuild Objects From Text Files?
Wayne <cqdigital@[EMAI  2008-05-09 02:11:51 
Re: How To Rebuild Objects From Text Files?
lyle fairfield <lyle.f  2008-05-09 02:33:06 
Re: How To Rebuild Objects From Text Files?
"Rick Brandt" &  2008-05-09 06:08:38 
Re: How To Rebuild Objects From Text Files?
lyle fairfield <lyle.f  2008-05-09 05:55:26 
Re: How To Rebuild Objects From Text Files?
lyle fairfield <lyle.f  2008-05-09 06:38:42 
Re: How To Rebuild Objects From Text Files?
"Larry Linson"   2008-05-10 01:00:07 
Re: How To Rebuild Objects From Text Files?
lyle fairfield <lyle.f  2008-05-09 18:51:49 
Re: How To Rebuild Objects From Text Files?
"Larry Linson"   2008-05-11 22:01:45 
Re: How To Rebuild Objects From Text Files?
Wayne <cqdigital@[EMAI  2008-05-17 23:57:47 
Re: How To Rebuild Objects From Text Files?
lyle fairfield <lyle.f  2008-05-18 03:08:03 
Re: How To Rebuild Objects From Text Files?
Wayne <cqdigital@[EMAI  2008-05-18 03:55:47 
Re: How To Rebuild Objects From Text Files?
lyle fairfield <lyle.f  2008-05-18 07:01:37 
Re: How To Rebuild Objects From Text Files?
Wayne <cqdigital@[EMAI  2008-05-18 08:34:32 
Re: How To Rebuild Objects From Text Files?
lyle fairfield <lyle.f  2008-05-18 08:51:46 
Re: How To Rebuild Objects From Text Files?
Wayne <cqdigital@[EMAI  2008-05-18 22:49:30 
Re: How To Rebuild Objects From Text Files?
Chris Martin <nr.cmart  2008-05-23 09:26:11 
Re: How To Rebuild Objects From Text Files?
Wayne <cqdigital@[EMAI  2008-05-23 13:17:43 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 11:27:49 CST 2008.