(Msg. 1) Posted: Wed Oct 01, 2008 3:14 pm
Post subject: VBA code does not work when using accde file Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
Does anybody know why all vba code would stop working after converting an
Access 2007 accdb file to accde format? I have looked around for several
hours but I cannot find out why this would be. It appears from Microsoft’s
help topics that the code is compiled and un-editable but should still run.
I have added the directory containing the accde file to my trusted
directories but this does not work. Anybody have any ideas on how to fix
this? Thank you.
(Msg. 2) Posted: Wed Oct 01, 2008 8:58 pm
Post subject: Re: VBA code does not work when using accde file [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Just a guess but did you put the accde file in a "trusted" folder like you
have to do when you create a new accdb file?
Steve
"oracle8202" <oracle8202.DeleteThis@discussions.microsoft.com> wrote in message
news:697F7B5C-FFB4-443C-A0DD-B70FAE761962@microsoft.com...
> Does anybody know why all vba code would stop working after converting an
> Access 2007 accdb file to accde format? I have looked around for several
> hours but I cannot find out why this would be. It appears from Microsoft's
> help topics that the code is compiled and un-editable but should still
> run.
> I have added the directory containing the accde file to my trusted
> directories but this does not work. Anybody have any ideas on how to fix
> this? Thank you.
>
(Msg. 3) Posted: Thu Oct 02, 2008 7:53 am
Post subject: Re: VBA code does not work when using accde file [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you for your reply. I sure did. I have found some threads mentioning
this issue but I have not found any that had a solution.
"Steve" wrote:
> Just a guess but did you put the accde file in a "trusted" folder like you
> have to do when you create a new accdb file?
>
> Steve
>
>
> "oracle8202" <oracle8202.RemoveThis@discussions.microsoft.com> wrote in message
> news:697F7B5C-FFB4-443C-A0DD-B70FAE761962@microsoft.com...
> > Does anybody know why all vba code would stop working after converting an
> > Access 2007 accdb file to accde format? I have looked around for several
> > hours but I cannot find out why this would be. It appears from Microsoft's
> > help topics that the code is compiled and un-editable but should still
> > run.
> > I have added the directory containing the accde file to my trusted
> > directories but this does not work. Anybody have any ideas on how to fix
> > this? Thank you.
> >
>
>
>
(Msg. 4) Posted: Thu Oct 02, 2008 9:17 am
Post subject: RE: VBA code does not work when using accde file [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Just an update, out of desperation I have tried signing the database with a
certificate and I have tried disabling the sandbox. Neither have worked.
"oracle8202" wrote:
> Does anybody know why all vba code would stop working after converting an
> Access 2007 accdb file to accde format? I have looked around for several
> hours but I cannot find out why this would be. It appears from Microsoft’s
> help topics that the code is compiled and un-editable but should still run.
> I have added the directory containing the accde file to my trusted
> directories but this does not work. Anybody have any ideas on how to fix
> this? Thank you.
>
(Msg. 5) Posted: Thu Oct 02, 2008 9:50 am
Post subject: RE: VBA code does not work when using accde file [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Okay I have finally figured it out. You have to choose "Debug->Compile" from
the VBA editor and then create the accde file. I found the solutions on the
threads below.
> Does anybody know why all vba code would stop working after converting an
> Access 2007 accdb file to accde format? I have looked around for several
> hours but I cannot find out why this would be. It appears from Microsoft’s
> help topics that the code is compiled and un-editable but should still run.
> I have added the directory containing the accde file to my trusted
> directories but this does not work. Anybody have any ideas on how to fix
> this? Thank you.
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other