Trial code

This is a confusing post.

I do not know what you mean by "trial code." I do not know how VBA code can "time out." The way you are describing it makes it sound like it is a trial version of a commercial product, but that is not how VBA works.

You have posted in the Excel forum but are asking about code for Microsoft Access (.mdb). Did you put the code in Excel, or in Access?

Open the application, whether it's Excel or Access. Then press ALT+F11. This will open the VBA code editor window. From there you can find the code, and remove it or whatever it is you want to do with it.

You don't have that many posts so I read them all. The closest thing I see to what you are describing is in How can I use VBA to turn my Excel application into a time-limited demonstration?, but nobody provided any VBA code in that thread. So I don't know where you got whatever it is that you have.

If this is not helpful then we'll need more complete information from you about what you did.

Are you still using Office 2007?

thank you for getting back to me

Yes still use office 2007


Yes that was me

Ok let me explain

I wrote a mdb I want to send it to a person who I was doing it for

In that mdb i wanted to put a time out code on it so they could not work on it so after 30 days it would time out

I cannot find the original mdb to take out the code (hdd crash) to give him the mdb now

There was a key combo to open that mdb so I can take out the code to let him have the full version now

BUT I have forgot what it was

I know that if you have the now how you can bypass the time out as every one keeps telling me

IT IS MY MDB PROGRAM NOT A COMMERCIAL ONE

So do you understand now?

Thank you for your time so far.

I cannot find the original mdb to take out the code (hdd crash) to give him the mdb now

If you don't have the file at all, I don't understand what you want to do.

If this was done with VBA you can follow my instructions to remove the VBA. Is there a password on the VBA project?

You have to provide the actual file with the VBA, or at least the information that was given to you to make it. The description you are giving is too general to help, because this problem is very specific to how your file was set up. It is a custom solution, not one using Access features.

If you don't have the file at all, I don't understand what you want to do

I lost the file with no code in it
So if he liked it I could send it to him with out the timeout code in it

Okay so far

Now I LOST that file so the only way I could get at the file is for him to send it to me BUT I cannot open it to take out the dam code.

Hence my orgil post how to get into the file to take out the code.

If this was done with VBA you can follow my instructions to remove the VBA. Is there a password on the VBA project?

How when i cannot open the file? . No password in the file.

Seems I had some involvement in the original thread, though I have slept since then. Anyway, some thoughts:

If the client did not run use the file past the timeout date, get him to send it back to you. And you can pass it on to us, and we can try to break into it.

If the client used the file past the timeout date, the original file is lost and the file the user is left with has no formulae or code. No use to anyone.

So, now we clutch at straws.

Did you email the file to the client? If you did, does he still have your email? If he does, get him to send it back to you. Do you have a copy of the email in your Sent Mail?

Does the client still have the original file in his downloads folder? Did he make a copy before he used it (I would have)? Does he have automatic backups? If so, could one of his backups have the original file in it?

If you didn't email it to him, did you put the file on a USB stick and take it or send it to him? If there was a memory stick, who has it? Can you find it or get it back.

Short story: if you upload a copy of the original file (from wherever), we may be able to recover it for you.

I note that the original thread was not marked solved. Not was there any feedback to advise us of the final solution.

Before I would consider helping you recover your (?) file, you would have to demonstrate to me that you did actually create an application yourself and apply all the protection features described.

It would have been nice if you had thanked the people who tried to help you at that time (nearly two years ago).

Originally Posted by build56

the only way I could get at the file is for him to send it to me BUT I cannot open it to take out the dam code.

How when i cannot open the file? . No password in the file.

Why can't you open the file if the is no password? Because the VBA is preventing you from doing it?

If that's the problem, then change your security settings in Access options to not allow macros to run. Then open the file. Then open VBA and delete the code.

Let's cut to the chase. If you have a copy of the file with the code in it, upload it. Like, now.

Nobody was saying, or implying that you are stupid.

The forum rules state that you can't ask or answer questions that want/need to bypass security.

You and I would both be breaking that rule if I were to offer assistance to "recover" a file that you had not created. I was just looking for assurance that no rules would be broken if I tried to help you.

If you have gone elsewhere, it would seem we were all wasting our time trying to help you. That won't happen again.

Originally Posted by build56

I cannot open the file because the code has been run that gives him a time to look at it say 30 days and that has passed so every time you run the file ithas passed the time

If it is VBA that preventing the file from opening, then all you have to do is set security levels so that VBA can't run when you open the file. This is not a hack, or bypassing security features per se. It is how to prevent macros from running, which is itself a security feature.

disable macros.jpg

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link.)

Please acknowledge post #18. And look at the Forum Rules page to refresh your memory. Thanks.

pl

Nobody was saying, or implying that you are stupid.

No you was not, but you keep implying that I am lying that the file is mine

The forum rules state that you can't ask or answer questions that want/need to bypass security.

I completely understand that IF IT WAS NOT MY OWN FILE

offer assistance to "recover" a file that you had not created. I was just looking for assurance that no rules would be broken if I tried to help you

.

Once again I completely understand that. But unlike you all others took me at my word and gave me VERY GOOD HLEP

If you have gone elsewhere, it would seem we were all wasting our time trying to help you. That won't happen again

No You and ALL THE OTHERS ON HERE are not wasting you time. So what are you saying just because you cannot sort it I cannot go and get help
BTW it was not on other forum's it was on google.

Oh with this "that won't happen again" you refuse to offer any help in the future?

But unlike you all others took me at my word and gave me VERY GOOD HLEP

But NOBODY has broken the forum rule and helped you to bypass a security measure, which is what TMS ws talking about.

You said this early on in the thread:

You see my problem not I have the file BUT cannotget into it

Had a password been necessary that you did not know, regardless of whether you said it was your file or not, nobody would have helped you with that. At that point in the thread, it wasn't clear that you didn't need a password hack, hence two members' hesitation.

We don't know who you are any more that you know who we are: we do not take ANY member at their word in these circumstances because, sadly, human beings do lie to get what they want. However, had you needed to bypass a security measure AND were able to prove in some way that the file was yours (other than just saying so), then we could have assisted.

I think you are taking your helpers' understandable caution as a personal slight when it certainly was not meant as such. Nobody was trying NOT to help you - quite the reverse.

Moderator

Please read and digest post #22.

You are overreacting and this needs to stop now. Calm down and stop shouting at us.

We have hundreds of members asking for help here: if you think that we'll remember you and/or have time to go back and check all your earlier threads, then I am afraid you are misguided in this expectation.

I am closing the thread. If you need any clarification on what I have said, send me a PM.