Group:  Microsoft Access ยป microsoft.public.access.multiuser
Thread: VBA corrupt, how can I fix this?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

VBA corrupt, how can I fix this?
"Michelle" <nospammbytwo-news[ at ]yahoo.com.au> 07.12.2005 07:15:57
Hi

Using A2003 and client machines also using the same versions

I compile on my development machine a .mde to distribute on the FE on
clients machines (3 users). One of the user's machines just will not take
the compiled .mde. I have to put a .mdb on her machine, recompile, then make
an .mde on her machine for it to work.

I have tried reinstalling Access, tried re-registering the .dll but none of
this has worked.

I have the same problem with another client as well. I would dearly like to
be able to email my clients their FE .mde with instructions but this is not
possible while I have to re-compile etc.

Does anyone have any suggestions as to how I can fix this problem?

Much appreciated.

Michelle


Re: VBA corrupt, how can I fix this?
"Brendan Reynolds" <brenreyn[ at ]discussions.microsoft.com> 07.12.2005 13:35:57
Probably the problem PC has a different version of one of the object
libraries to which you have a reference.

The first thing to do, if you haven't already done so, is to make sure that
you have no references that you are not using. If the problem reference is
one that you are not using, and can remove, you're home free.

Otherwise, you'll need to either ensure that the same version of the
required object library is installed and registered on the problem PC, or
possibly use late binding.

Have you established which reference is causing the problem?

--
Brendan Reynolds

"Michelle" <nospammbytwo-news[ at ]yahoo.com.au> wrote in message
news:dn627d$6n3$1[ at ]otis.netspace.net.au...
[Quoted Text]
> Hi
>
> Using A2003 and client machines also using the same versions
>
> I compile on my development machine a .mde to distribute on the FE on
> clients machines (3 users). One of the user's machines just will not take
> the compiled .mde. I have to put a .mdb on her machine, recompile, then
> make an .mde on her machine for it to work.
>
> I have tried reinstalling Access, tried re-registering the .dll but none
> of this has worked.
>
> I have the same problem with another client as well. I would dearly like
> to be able to email my clients their FE .mde with instructions but this is
> not possible while I have to re-compile etc.
>
> Does anyone have any suggestions as to how I can fix this problem?
>
> Much appreciated.
>
> Michelle
>


Re: VBA corrupt, how can I fix this?
"Michelle" <nospammbytwo-news[ at ]yahoo.com.au> 07.12.2005 19:36:58
Hi Brendan

Yes. Under the References, it is the 'Visual Basic for Applications' which
resides in the c:\program files\common files\microsoft
shared\VBA\VBA6\VBE6.dll

Since you can't actually remove this reference I have tried taking a copy of
the .dll from my development machine to the users machine and registering
it, rebooting and that has not helped.

I would appreciate any other help that you can think of.

Cheers
Michelle


"Brendan Reynolds" <brenreyn[ at ]discussions.microsoft.com> wrote in message
news:u1JOpMz%23FHA.344[ at ]TK2MSFTNGP11.phx.gbl...
[Quoted Text]
> Probably the problem PC has a different version of one of the object
> libraries to which you have a reference.
>
> The first thing to do, if you haven't already done so, is to make sure
> that you have no references that you are not using. If the problem
> reference is one that you are not using, and can remove, you're home free.
>
> Otherwise, you'll need to either ensure that the same version of the
> required object library is installed and registered on the problem PC, or
> possibly use late binding.
>
> Have you established which reference is causing the problem?
>
> --
> Brendan Reynolds
>
> "Michelle" <nospammbytwo-news[ at ]yahoo.com.au> wrote in message
> news:dn627d$6n3$1[ at ]otis.netspace.net.au...
>> Hi
>>
>> Using A2003 and client machines also using the same versions
>>
>> I compile on my development machine a .mde to distribute on the FE on
>> clients machines (3 users). One of the user's machines just will not
>> take the compiled .mde. I have to put a .mdb on her machine, recompile,
>> then make an .mde on her machine for it to work.
>>
>> I have tried reinstalling Access, tried re-registering the .dll but none
>> of this has worked.
>>
>> I have the same problem with another client as well. I would dearly like
>> to be able to email my clients their FE .mde with instructions but this
>> is not possible while I have to re-compile etc.
>>
>> Does anyone have any suggestions as to how I can fix this problem?
>>
>> Much appreciated.
>>
>> Michelle
>>
>
>


Re: VBA corrupt, how can I fix this?
"Brendan Reynolds" <brenreyn[ at ]discussions.microsoft.com> 07.12.2005 21:18:35
You might need to install the latest service releases on the problem PCs.
I'm not sure that copying and registering just that one DLL is a good idea -
that DLL may have dependencies on specific versions of other DLLs or
resources.
--
Brendan Reynolds

"Michelle" <nospammbytwo-news[ at ]yahoo.com.au> wrote in message
news:dn7dll$l06$1[ at ]otis.netspace.net.au...
[Quoted Text]
> Hi Brendan
>
> Yes. Under the References, it is the 'Visual Basic for Applications' which
> resides in the c:\program files\common files\microsoft
> shared\VBA\VBA6\VBE6.dll
>
> Since you can't actually remove this reference I have tried taking a copy
> of the .dll from my development machine to the users machine and
> registering it, rebooting and that has not helped.
>
> I would appreciate any other help that you can think of.
>
> Cheers
> Michelle
>
>
> "Brendan Reynolds" <brenreyn[ at ]discussions.microsoft.com> wrote in message
> news:u1JOpMz%23FHA.344[ at ]TK2MSFTNGP11.phx.gbl...
>> Probably the problem PC has a different version of one of the object
>> libraries to which you have a reference.
>>
>> The first thing to do, if you haven't already done so, is to make sure
>> that you have no references that you are not using. If the problem
>> reference is one that you are not using, and can remove, you're home
>> free.
>>
>> Otherwise, you'll need to either ensure that the same version of the
>> required object library is installed and registered on the problem PC, or
>> possibly use late binding.
>>
>> Have you established which reference is causing the problem?
>>
>> --
>> Brendan Reynolds
>>
>> "Michelle" <nospammbytwo-news[ at ]yahoo.com.au> wrote in message
>> news:dn627d$6n3$1[ at ]otis.netspace.net.au...
>>> Hi
>>>
>>> Using A2003 and client machines also using the same versions
>>>
>>> I compile on my development machine a .mde to distribute on the FE on
>>> clients machines (3 users). One of the user's machines just will not
>>> take the compiled .mde. I have to put a .mdb on her machine, recompile,
>>> then make an .mde on her machine for it to work.
>>>
>>> I have tried reinstalling Access, tried re-registering the .dll but none
>>> of this has worked.
>>>
>>> I have the same problem with another client as well. I would dearly
>>> like to be able to email my clients their FE .mde with instructions but
>>> this is not possible while I have to re-compile etc.
>>>
>>> Does anyone have any suggestions as to how I can fix this problem?
>>>
>>> Much appreciated.
>>>
>>> Michelle
>>>
>>
>>
>
>


Re: VBA corrupt, how can I fix this?
"Michelle" <nospammbytwo-news[ at ]yahoo.com.au> 16.12.2005 09:38:34
Hi

I would like to re-open this discussion if anyone has any other suggestions
as to the way to fix this problem?

Many thanks

Michelle

"Michelle" <nospammbytwo-news[ at ]yahoo.com.au> wrote in message
news:dn627d$6n3$1[ at ]otis.netspace.net.au...
[Quoted Text]
> Hi
>
> Using A2003 and client machines also using the same versions
>
> I compile on my development machine a .mde to distribute on the FE on
> clients machines (3 users). One of the user's machines just will not take
> the compiled .mde. I have to put a .mdb on her machine, recompile, then
> make an .mde on her machine for it to work.
>
> I have tried reinstalling Access, tried re-registering the .dll but none
> of this has worked.
>
> I have the same problem with another client as well. I would dearly like
> to be able to email my clients their FE .mde with instructions but this is
> not possible while I have to re-compile etc.
>
> Does anyone have any suggestions as to how I can fix this problem?
>
> Much appreciated.
>
> Michelle
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net