Automatically compile database

[kevins]

In order to make sure everything works properly in my database, I have to compile the database when I open it. Database tools - Visual Basic - Debug - Compile.

Is there a way to automate this so I don't have to do it every time I open the database? Thanks in advance.

[Rainlover]

This is not necessary. What makes you think it is.

[kevins]

I have a form that lists contact information. When I open the form initially, it's all blank. When I compile, it seems to fix the problem. I'm not really an expert with Access, so I'm not sure why it's happening now (it never happened before).

[Rainlover]

I have never heard of this problem.

In fact once you have compiled you should not be able to compile again until you change something.

When you access any code that is not compiled then MS Access automatically compiles it for you.

Non compiled code will not run. If you are going to tell me that the code is not compiled then that would be interesting.

[Rainlover]

Thinking on the Run, do you have any Yellow lines when you go to compile.

Do you have to reset or stop code in order to compile.

What else can you tell me.

[JoeM]

Kevins,

Are you sure you aren't confusing "Compiling" with "Compacting and Repairing"?

[kevins]

It's been happening to me every day or even when I close the database and then reopen in....but not it seems to be working fine. I was going to do some screenshots so you could see what I was dealing with, but maybe the problem fixed itself?

It started when I compacted and repaired my back end. The contact details form on my front end that lists all the information for any given contact was then blank for whatever record I selected. I would then go into VBA - Debug - Compile and that seemed to fix everything. Looks ok now but we'll see if it lasts. Thanks again for helping me try to solve my problem, I will investigate further to see if I can figure out what went wrong.

[Rainlover]

Are you saying that you have Code in the Back End.

[Missinglinq]

This type of thing comes under what I call Strange, Odd and Curious Behavior, and S/O/C/B, especially when coupled with repeating of the odd behavior, over and over and over, again, usually translates into corruption, of one type or another. Coming as the app opens, I’m afraid that it’s probably the app, itself that has gone south! When the app was opening properly, was there a Form that loaded automatically? If so, how was this accomplished?

The fact that it started immediately after you did a Compact & Repair only strengthens the likelihood that this is the problem, as, paradoxically, doing a C&R is a recognized cause of corruption. This procedure should never be done without backing up the app, first.

The first thing to attempt, for this type of corruption, is to create a new, blank file and import everything into it. Only takes a minute or two to create and check out, and if it doesn't work you haven't really lost anything! And, amazingly, it does frequently work!

Linq ;0)>

[Rainlover]

Ling may be onto something.

My advise would be to decompile before importing into a new database.

You don't want to go importing damaged code that may be there but you can't see.

[kevins]

Linq and Rain,

Took your advice and did the import today...so far so good! Will let you know if it gives me any issues. Thanks for the help.