Broken forms

[news.microsoft.com]

I'm using Access2000 on Windows XP (English edition).

Last week I opened the databse file on another computer, which runs the
Japanese versions of windows and Access. Everything appaeared to work fine.
But when I took the files home, the Access forms were corrupted. It isn't a
fatal bug - the raw data is still intact. But the forms just show "1"
insteadof teh actual data. Running the repair database option will fix this,
but only until teh next time I open the file. How can I repair this
properly?

-
Fabian

 

[Arvin Meyer [MVP]]

You should have your databases split into Front and Back ends, with only the
data running on the back end and everything else on a front end. There is a
wizard to help you do that: [Tools ... Database Utilities ... Database
Splitter] Keeping seperate front-ends for each language should alleviate
your problem and reduce any chance of corruption.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[news.microsoft.com]

If I'd known this might ever have been an issue, I would never have opened
it on that other machine. It is especially puzzling, as the database file in
question was originally created on a Japanese version of windows XP.

I have tried splitting the database, which succeeded, but that has done
nothing to fix the problem. I can understand how that might prevent this
kind of thing happening in the future, but the more important issue is how
do i fix this in the present? I7m after a repair solution at the moment, not
a prevention solution.

Regards,
Fabian

You should have your databases split into Front and Back ends, with only
the
data running on the back end and everything else on a front end. There is
a
wizard to help you do that: [Tools ... Database Utilities ... Database
Splitter] Keeping seperate front-ends for each language should alleviate
your problem and reduce any chance of corruption.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I'm using Access2000 on Windows XP (English edition).

Last week I opened the databse file on another computer, which runs the
Japanese versions of windows and Access. Everything appaeared to work fine.
But when I took the files home, the Access forms were corrupted. It isn't a
fatal bug - the raw data is still intact. But the forms just show "1"
insteadof teh actual data. Running the repair database option will fix this,
but only until teh next time I open the file. How can I repair this
properly?

-
Fabian

 

[Arvin Meyer [MVP]]

Try building a new empty database and importing each form. Compile it and it
should be OK. If that doesn't work try using the code from my website:

http://www.datastrat.com/Code/DocDatabase.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

If I'd known this might ever have been an issue, I would never have opened
it on that other machine. It is especially puzzling, as the database file in
question was originally created on a Japanese version of windows XP.

I have tried splitting the database, which succeeded, but that has done
nothing to fix the problem. I can understand how that might prevent this
kind of thing happening in the future, but the more important issue is how
do i fix this in the present? I7m after a repair solution at the moment, not
a prevention solution.

Regards,
Fabian

You should have your databases split into Front and Back ends, with only
the
data running on the back end and everything else on a front end. There is
a
wizard to help you do that: [Tools ... Database Utilities ... Database
Splitter] Keeping seperate front-ends for each language should alleviate
your problem and reduce any chance of corruption.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I'm using Access2000 on Windows XP (English edition).

Last week I opened the databse file on another computer, which runs the
Japanese versions of windows and Access. Everything appaeared to work fine.
But when I took the files home, the Access forms were corrupted. It

isn't
a

fatal bug - the raw data is still intact. But the forms just show "1"
insteadof teh actual data. Running the repair database option will fix this,
but only until teh next time I open the file. How can I repair this
properly?

-
Fabian