PC Review


Reply
Thread Tools Rate Thread

Deleting macro by code

 
 
PaulB
Guest
Posts: n/a
 
      4th Dec 2006
Hello All,

How can I delete a macro in my BE-database by running code in the
FE-database?
This BE-database has a switchboard form which opens when the BE-database
is opened. Because there's code behind this form which should *not* run,
using "accObj.OpenCurrentDatabase BE-database.mde" as a new new
application is not possible.
Is there any other pssibility?

Thanks in advance!
 
Reply With Quote
 
 
 
 
Lynn Trapp
Guest
Posts: n/a
 
      4th Dec 2006
A backend database is not a good place to have code running, unless it is
code to keep users from opening the backend by itself. You should delete
that and move it to the front end.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"PaulB" <(E-Mail Removed)> wrote in message
news:45747cb6$0$14699$(E-Mail Removed)...
> Hello All,
>
> How can I delete a macro in my BE-database by running code in the
> FE-database?
> This BE-database has a switchboard form which opens when the BE-database
> is opened. Because there's code behind this form which should *not* run,
> using "accObj.OpenCurrentDatabase BE-database.mde" as a new new
> application is not possible.
> Is there any other pssibility?
>
> Thanks in advance!



 
Reply With Quote
 
PaulB
Guest
Posts: n/a
 
      4th Dec 2006
Yes, the switchboard form contains code to prevent the BE-database to be
openend. Nothing more, nothing less.


On 4-12-06 21:03, Lynn Trapp wrote:
> A backend database is not a good place to have code running, unless it is
> code to keep users from opening the backend by itself. You should delete
> that and move it to the front end.
>

 
Reply With Quote
 
Lynn Trapp
Guest
Posts: n/a
 
      4th Dec 2006
Then I would say you don't have a problem.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"PaulB" <(E-Mail Removed)> wrote in message
news:45748224$0$14700$(E-Mail Removed)...
> Yes, the switchboard form contains code to prevent the BE-database to be
> openend. Nothing more, nothing less.
>
>
> On 4-12-06 21:03, Lynn Trapp wrote:
>> A backend database is not a good place to have code running, unless it is
>> code to keep users from opening the backend by itself. You should delete
>> that and move it to the front end.
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting code from a macro (by a macro) =?Utf-8?B?QnJldHRqZw==?= Microsoft Excel Misc 2 8th May 2007 10:14 PM
Deleting macro code programatically Terry Lowe Microsoft Excel Programming 1 1st Sep 2004 02:30 AM
Re: deleting code by macro Rob van Gelder Microsoft Excel Programming 0 29th Jun 2004 09:44 AM
deleting code by macro jriehl Microsoft Excel Programming 2 29th Jun 2004 09:43 AM
Re: visual basic macro code for deleting referenced rows mudraker Microsoft Excel Programming 3 29th Jan 2004 05:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:14 AM.