language change in field?

[dnrhymer4]

Hi All,

I'm a little stumped with this one. I have a table showing all my fields in English. I then created a query based on this table. For months now, it's been working fine. Today, I went into the query and one of the fields is showing in Korean? I've tried to delete it and re-add that field to the table, but it hasn't helped. Can someone help me?

 

[vbaInet]

Sounds like corruption or maybe you need to learn Korean

1. Perform a Compile & Repair.
2. Create a new blank database and import all your forms, queries etc into it.

 

[dnrhymer4]

Great. Thanks .

 

[vbaInet]

You're welcome. What do you think would have caused the corruption? Is the database split?

 

[dnrhymer4]

Yes, it is split. I was doing some work on the front end this week, mostly cosmetic stuff. But I never used that table or query while I was working on it, so I'm really not sure.

 

[vbaInet]

It might be the way you split it. Do you have a shared folder where each user runs the db from?

 

[dnrhymer4]

Yes I do. Is there anything I can change to prevent it from happening again?

 

[vbaInet]

Well that's your problem. The database is not split. It's just shared and that leads to corruption. Also your users aren't using a wireless connection to access the db are they?

I will send you some links on properly splitting the db later. Unless one of the site's VIPs seeing this thread have some resources for you!

 

[dnrhymer4]

Awesome. Really appreciate it. I thought I did split it? I created a backend with all my tables and then have a front end which I stored in the shared folders for users. I'm new at this so I'm sure there's some step that I've overlooked.

 

[vbaInet]

Basically, it's split logically but the front end should be distributed to each user's machine and you link that to your back end.

 

[vbaInet]

Here are the links as promised:

http://members.shaw.ca/AlbertKallal/Articles/split/index.htm
http://databases.about.com/od/tutorials/ss/splitaccessdb.htm
http://www.databasedev.co.uk/split_a_database.html
http://support.microsoft.com/kb/304932

FE Updater utility:
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx

It may seem much, but the more you know the better