Corruption(?) after importing a form

[Guest]

Has anyone ever had this happen to them?

I was working on a form on my laptop. I imported this form into the main
database we use. The form has the same name as an older version so of course,
the new form was named with an added 1. I opened the old form - it worked as
it should. I then tried the updated form and I got an error due to there
being a space between a number and its unit when setting column widths in a
combo box i.e "3 cm" caused an error. "3cm" was OK. The old form then started
to show the same problem. When I had made sure that all the gaps were removed
I noticed that ALL strings were now delimited by spaces. For example "Allen
Jones" would be read as two seperate strings "Allen" and "Jones". We only run
off two computers in our 'network' so we just open the one database across
the network - there is no local copy on the 2nd computer. When I ran the db
off the 2nd computer everything ran perfectly for both forms and there was no
string problem.

It seems some type of corruption has occured during the import process, but
what? The database runs well, depending on the computer. I would appreciate
it if anyone could shed some light on the situation, and more importantly
give me an idea of how to fix it.

Thanks

 

[Allen Browne]

Couple of things to try:

Uncheck the boxes under:
Tools | Options | Name AutoCorrect.
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html
Then compact the database:
Tools | Database Utilities | Compact.
Follow that up with a decompile. Decompile a copy of the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact again.

Also, check the service packs on the laptop. You need both the latest Office
service pack for your version, and also the latest JET 4 service pack. Both
are available form support.microsoft.com