Code without Form

[ulrich1947]

Hi All,

I come across a problem more frequently, since I installed Windows 7. When I
open my Application, automatically a number of Tables, Forms and Reports are
imported from a backend. These Tables, Forms and Reports are deleted when I
close the application. This worked for hundreds of years properly.

Now, now and then - not regularly - the application cannot be opened because
the opening procedure stops, telling me, a certain Form cannot be found. So I
have to stop. Searching for a solution i found out I have code for a form,
which is not - yet - part of the application, not even due to be imported. E.
g. I have a Form called "ADDRESSkpl" (but it happens to other forms as well)
which has a module attached to get it working. So it tells me, this form
cannot be found - and it isn't listed in Forms. But if I open VBA section,
the form is listed and its code can be seen. However, if I even touch the
forms name, I get the message, that this form cannot be found. To delete just
the form is impossible. Futhermore in systems table MSysObjects i find
entries like "~sq_cADRESSkpl~sq_clisteTERMINE" (and severeal more) which
refers to a part of the form.

I can solve the problem, if i start a new database and import every table,
query, form and report to it and start again. but what a trouble.

Anyone who understands my problem (sorry, its not my language) and can give
me a clue to solve it.

thanks

Ulrich

PS: since i use Windows 7, MSaccess is regarded as an unknown application
whose start must always individually permitted.

 

[ruralguy via AccessMonster.com]

Why are you importing those objects when the application loads? It sounds
like your application is not properly split.

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html
http://www.accessmvp.com/TWickerath/articles/multiuser.htm
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB

 

[AccessVandal via AccessMonster.com]

What version of Access? Is the DB is Trusted Locations?

It appears that your backend database is not split. If it is split, the
backend DB only has tables, no forms, reports or modules.

Looks like that there is some locked up while importing the backend with
Windows 7. Most us (I believed haven't use Windows 7 with Access yet) don't
have answers to your problem judging from the replies to your post.

Were there any users connected to the backend DB(not split) when you import?

If it's possible, you might want to post to MS Support.

PS: since i use Windows 7, MSaccess is regarded as an unknown application
whose start must always individually permitted.

snip...

 

[ulrich1947]

The Access Version is Access 2000, the DB is Trusted Locations.

My Backend contains exept tables also forms, reports and even modules. I do
not understand, whats wrong with that. It works for years actually. Reason
for storing e. g. forms in the backend is, that each individual user works
with various forms. User A may use Form A, B and C; User B maybe B, C and D,
depending in which place (i. e. various shops - kiosk's - at various sites)
they are run and by whom. There is no network and no one else than the user
is connected to the specific computer. I do not want forms (etc.) to keep in
the Frontend, as they blow up the Frontend and I do not want to have certain
Forms even theoretically available in the Frontend. So far for the Problem of
Code without Form.

For the problem starting access in general, that can has nothing to do with
the afore mentioned problem, as starting an empty db by doubleclicking
MSaccess causes just the same problem. By the way, can you possibly state the
www. or email - address to get through to MS Support ?

I hope you understand my explanation. I am German, my English is more for
common use than specialized for technical problems.

Thanks for trying.

Ulrich

 

[AccessVandal via AccessMonster.com]

If you're using A2000, you don't need Trusted Locations. I'm assuming you
have a backup of your db?

Did you see the sites posted by RG? (ruralguy) on spliting the db and
corruption?

Anyway, here is another from Tony Teows on corruption
http://www.granite.ab.ca/access/corruptmdbs.htm

and why split.
http://www.granite.ab.ca/access/splitapp/why.htm

and it seems to me the you might want to use this from Tony
http://www.autofeupdater.com/
Might be a better solution than sharing the same FE? Sharing a db with
multiple users have a tendency to cause corruption. You're very lucky that
you had never encounter these for years before and now you do. It's time to
think about spliting.

I have two forms disappearing but the codes remain in the project viewer and
I had successfully recovered my database without any help. It was due to
Access hanging and instead of waiting, I used the Task Manager to shutdown
Access. Sharing the same database file may also cause this problem but I'm
not certain about yours.

Compact and Repair or Compiling the code will not work in your case or even
decompiling. Once I found out a solution to my problem, it was easy.

 

[AccessVandal via AccessMonster.com]

PS. As for the MS support, I do not know your licence or whether are you
entitle to call up MS. My guess you may have to pay them if you need support.

or try here for recovery
http://www.everythingaccess.com/
or do a google search for ms access repairs.

Just in case, I'm not employed by them either nor I'm getting paid to do this.
lol