access problem - reference problem ?

D

Dennis hoyer

Hello newsgroup,

i have a microsoft access 2000 database. Now, i have to install it on
the pc of our customer. The customer has installed 2003. I can export
all data, but i can not open the reports of this database.
I will get the message ( if i got some) an active x or ole object is
not installed. But i don't know which on can't be used. If i will
create an equal database which the same references, it is not the
problem. The only thing which i can not use on this pc is "insert a
diagram"

After this, we have installed a access runtime 2000, but the same
error.

Have somebody an idea, which i can resolve this problem ?

i think it is a reference problem but i don't know which one.


please help me,


best regards

Dennis
 
T

Tom Wickerath

Hi Dennis,

If you think it is a reference problem, then perhaps these two article will
be helpful:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

On the affected machine(s), open the Visual Basic Editor (ALT F11). Click on
Tools > References. Are any of the references marked as MISSING?

Make sure that the code compiles okay, without any errors:
Debug > Compile ProjectName

where ProjectName is the name of your VBA project.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
D

Dennis hoyer

Hello Mr. Wickerath ,

first, thank for your tips, i will try it on monday.

if i want to open the code of the project, i always get an unexpected
error.
in the microsoft error message, it shows me the error in the module
vbe6.dll.
I have test this with my vbe6.dll from my computer. I have used
regsvr32 and i have reregister my version
but i did't solve the problem, because i will get a new unexpected
error in the ntdll.dll.

but i can not change all dlls because its the computer of my
customer.....

On friday i have try to make a new report, that works! because if i
will set the datasource to a query , then i will get an unexpected
error.

Perhaps, exist a tool which can automaticly combine the old references
with similar new references ?

best regards

Dennis
 
T

Tom Wickerath

Hi Dennis,
if i want to open the code of the project, i always get an unexpected
error in the microsoft error message, it shows me the error in the module
vbe6.dll.
Click to expand...

This does not sound good. What is the exact error message?
It sounds like you may have a corrupted VBA project. Make a copy of your
database. To the copy, try opening it with the undocumented /decompile
switch. If you only have one version of Access loaded onto your PC, you can
click on Start > Run and enter the following command:

msaccess /decompile

The next database that you open will have it's compiled "P Code"
automatically discarded. I recommend holding down the Shift key, while
opening the database, to prevent any code from running at startup (via an
Autoexec macro, or a form that is set to open under Tools > Startup). Do a
compact and repair right away, still holding down the Shift key the entire
time. Then try opening a code module. If successful, click on Debug > Compile
ProjectName, where ProjectName is the name of your VBA project.

Which version(s) of Access are in use? Have you applied the latest service
packs to all machines for:

1.) The operating system
2.) The version of Office (or just Access)
3.) The Jet database engine and
4.) Microsoft Data Access Components (MDAC)

There are links in this article for items 1-3, above:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

To update MDAC, visit this page:

http://www.microsoft.com/downloads/...95-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en

Perhaps, exist a tool which can automaticly combine the old references
with similar new references ?
Click to expand...

Not sure what you are asking here, but I've never heard of a need for any
such tool that combines references.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
D

Dennis hoyer

Hello Mr. Wickerath ,

thank you for your tips, i will try it on monday

I am a german developer and we are now in shanghai to install our
system.
here are the setup of the pcs
1.) The operating system
Click to expand...
Windows XP (with chinese support) SP 2
2.) The version of Office (or just Access)
Click to expand...
Office 2003 full installation with all components (with chinese
support)
3.) The Jet database engine and 4.0
4.) Microsoft Data Access Components (MDAC)
Click to expand...
2.8

i have try to install the mdac_type.exe but i get the message " its
already installed under windows xp"

I don't think that the mdb or mde is brocken, because the same file
runs on my laptop. On my laptop i have installed an office 2000 and i
have no problems. If i run it on the laptop of my partner ( office
2002 ), no problem.

I have try to install the access runtime 2000 english, but the same
error on the customer machine. I can not use any database on his pcs.


best regards

Dennis
 
T

Tom Wickerath

Hi Dennis,

You are very likely running into a weird code page type error, of which my
understanding is very limited. There have been times in the past when I've
invited folks from the newsgroup to send me a copy of their database, so that
I could look further into a problem. When the database was created in some
countries (Poland and Turkey are examples), I've had lots of trouble being
able to run any VBA code. I wonder if the same thing is not happening to you,
since your code was likely created with a German code page setting, but now
you are in China trying to get it to work.

Also, make sure that you have not used any country specific things, such as
umlauts, that are not supported in another language. Let me emphasize that I
don't have much experience with code page issues, but you might try the
following to fix this (on a copy of your database):

1.) Save all code modules (form, report and stand-alone modules) to one or
more text files.

2.) Delete all code modules (set the Has Module property to No for forms and
reports)

Perform steps 1 and 2 on your laptop, where you can open the code modules.
Compact that database. Then transfer it to one of the new PC's with the
Chinese language support. See if you can open the forms and reports okay. If
not, create a new database and attempt to import these objects or use the
undocumented SaveAsText (from your laptop) / LoadFromText (from the new
Chinese-based PC) commands to save and restore each form and report (with any
code already removed) to a text file. Access MVP Arvin Meyer has code that
you may find helpful, if run from your laptop where you can run code. See
"DocDatabase.txt" here:

http://www.datastrat.com/Code1.html

Note: I recommend not attempting to save code with this method, because you
will likely have the same code page issue when the object is restored.
Instead, try importing the objects (devoid of code) using the Chinese code
page set as the default (a control panel setting). Then restore the code by
creating a new module and pasting it back in from the text file backups.

This thread may be helpful to you
http://groups.google.com/group/micr...002f8f8992?lnk=st&q=&rnum=43#e01290002f8f8992

Is it possible to enable the German language on the Chinese PC's?

Office 2003 full installation with all components (with chinese
support)
Click to expand...

Is Service Pack 2 installed?
4.0
Click to expand...

Is Service Pack 8 for the Jet database engine installed?


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
D

Dennis hoyer

hi,

ok i will try all your tips tomorrow.
it is a little bit difficult here, because you can not read
anything :)

the chinese signs have so many meanings .....



thanks for your help, i will give you response


Dennis
 
T

Tom Wickerqueer

WARNING

Tom Wickerath is a known troll, he reccomends MDB at every turn.

I would reccomend moving to SQL Server and avoiding the MDB crybaby newbies
 
D

Dennis hoyer

Hi,

thank you for your help, i have solve the problem.
You was right, it was a codepage problem.

If you create a report in german, the access will always use
Seitenfuß
Gruppenfuß


The sharp "S" (ß) can not be used by an chinese system. After i have
change this, the reports have some corrupts because it shows me some
groups which does not exist. I have make a new database and import all
report, modules and forms.

After this it works.

Thank you for your help

best regards

Dennis
 
Top