question

PangRan-4454 avatar image
0 Votes"
PangRan-4454 asked thedbguy answered

Access Database couldn't opened if the system locale changes

I maintened serveral access database was created by access 2003(not too sure which version exact but surely it uses "Toolbar" instead of "Ribbon"),bascially the function of these databases are the same,the only difference is the table stores in it.
Now the software I'm using is office 365 version 2012(Build 13801.20808 Click-to-Run)
The error code while I open the database is "The expression you enetered has a function name that XXXXX can't find"(XXXXX is the form name)
After I clicked "OK" button then the Macro error comes.
Macro Name:AutoExec
Action Name:RunCode
Error Number:2425
Arguments:OpenWelcome() (Open welcome is defined in the VBA code)
Then I closed database and hold "SHIFT" key to reopen it,and I try to see what's wrong in my VBA code but when I goto "Visual Basic" under "Database Tools" got an error says "The database cannot be opened because the VBA project contained in it cannot be read.The database can be opened only if the VBA project is first deleted......"
This database was developed years ago by a German team and dismissed for quiet a long time~
Since this database was developed by German team so my system locale setup is English(United States) but this morning I tried to switch to Chinese(Simplified) and it can be opened but some charaters in VBA code can't be recognized,after switch back to English(Even German) I still got the same error message.
I tried to use another laptop(Locale setup was English) to open the same file and can be opened but I can't,but for sure my laptop is good because I could open some access files.
Can some body help me?
Much appearciated.






office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered

Hi. If the file got corrupted, then to fix it would be to fix the source of corruption. This could mean anything. What you'll have to do is log every situation when a problem occurs to the file that eventually corrupts it. If you find a common thread among the corruption incidents, then you could try fixing that situation to avoid getting the corruption. For example, if you find out that the file usually gets corrupted when users shuts down their machines without properly exiting the db first, then you can educate them to stop doing that. Just a thought...

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered PangRan-4454 commented

Hi. Do you have any backup copy. I suspect the file your trying to open may be corrupted.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,thedbuy
Thanks for your answer,I don't think the database is corrupted because I still could open it by Chinese(Simlified,China) system locale only show up the error when I switched system locale to English and most of the databases I'm having have this symptom,and I can open the same file using others laptop.
Do you have any other suggestions or how to do determine my databse is corrupted?
I do have back up copy but this smpytom is keep happening which I want to resolve it permenantly.
Thank you for your help.

0 Votes 0 ·

New finding:
I installed two version of office:
1.Office 365
2.Office 2003
I opened an access by office 365 there is no problem with the function but once I open it by office 2003 it pops up the error saying
"The expression you entered has a function name that XXXXX can't find"
I guess now the access database is corrupted then I use office 365 to give it a try,it behaves as what I'm expected.
I didn't save anything only execute the open action,does database file automaticlly saved when I open it?

0 Votes 0 ·