This is concerning Access 2000 and some pretty incomprehensibl e behavior
OK, I hope someone can explain this to me. After spending some 30 hours
developing forms and modules for an Access database (with a lot of help form
the folks here), suddenly Access decides to delete all of the forms and
modules.
I was working on a form to open another form to a specific record. I had just
finished the form for a trial and closed it, the typical dialog obx came up
asking if I wanted to save the form, I said yes, it opend the dialog box
asking for a name and I entered a name (frmInMov), hit the ok button and
suddenly all the forms listed in Database view window disappeard. Just gone.
Also gone were all the modules.
The tables are fine as are the queries and reports I've written to date, but
all forms are simply not there. No amount of messing with it seems to turn
anything up.
Any ideas at all or do I just have to start over?
Thanks for any help,
A very depressed Randy
----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email ab***@newsone.n et 14 1952
Sounds to me as if this was an _object lesson_ in the advisability of making
regular, and frequent, backups. When I am developing a database, I tend to
save a backup no less than every couple of hours, and often every couple of
"significan t changes".
If you haven't done any more to that database, make a copy and save the
original. In the end, if your time is worth anything, it may be worth your
while to send that to Peter Miller at http://www.pksolutions.com, who has an
excellent reputation for salvaging data from corrupted Access databases. In
the meanwhile, make another copy of the copy and try to use Access' compact
and repair on it.
But before you do that... check the scroll bar at the bottom of the Forms
tab of the database window... it is possible that the forms aren't _gone_
but only shifted so that you don't see them any more.
Larry Linson
Microsoft Access MVP
Larry Linson
Microsoft Access MVP
<st*********@ch arter.net> wrote in message
news:br******** **@news.netmar. com... This is concerning Access 2000 and some pretty incomprehensibl e behavior
OK, I hope someone can explain this to me. After spending some 30 hours developing forms and modules for an Access database (with a lot of help
form the folks here), suddenly Access decides to delete all of the forms and modules.
I was working on a form to open another form to a specific record. I had
just finished the form for a trial and closed it, the typical dialog obx came
up asking if I wanted to save the form, I said yes, it opend the dialog box asking for a name and I entered a name (frmInMov), hit the ok button and suddenly all the forms listed in Database view window disappeard. Just
gone. Also gone were all the modules.
The tables are fine as are the queries and reports I've written to date,
but all forms are simply not there. No amount of messing with it seems to turn anything up.
Any ideas at all or do I just have to start over?
Thanks for any help,
A very depressed Randy
----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email ab***@newsone.n et
What if you create a new database and try to import the objects in
this one? What if you go to Tools, Options, Show Hidden Objects =
YES. Can you see them? pi********@hotm ail.com (Pieter Linden) wrote in
news:bf******** *************** ***@posting.goo gle.com: What if you create a new database and try to import the objects in this one? What if you go to Tools, Options, Show Hidden Objects = YES. Can you see them?
I did keep a copy of the database and really only lost about 4 hours work.
But I was pretty frustrated and I suspect had become a bit too comfortable.
Access had never done this to me before. Sigh.. So, I managed to copy the
tables from the old database (I had spent a LOT of time importing the data
from a elemental spreadsheet) and got that into the backup copy then spent
most of the rest of the day recreating the forms. At least it was easier
this time since I knew what to do and already had the process down. I'm
still quite new to this. And I made 2 backups that I recopied about every
half hour. I'll try not to get caught out like that again.
Just a note. The repair function didn't do anything and it was pretty clear
something was corrupted. It also wouldn't let me make new forms in that
database. Kept complaining that it couldn't find something (tables,
dependent queries, whatever).
OK, so lesson learned. Thanks for the input.
Backup Maniac Randy no********@noma il.net (Randy Powell) wrote in
<Xn************ *************** *******@216.168 .3.44>: pi********@hot mail.com (Pieter Linden) wrote in news:bf******* *************** ****@posting.go ogle.com:
What if you create a new database and try to import the objects in this one? What if you go to Tools, Options, Show Hidden Objects = YES. Can you see them?
I did keep a copy of the database and really only lost about 4 hours work. But I was pretty frustrated and I suspect had become a bit too comfortable. Access had never done this to me before. Sigh.. So, I managed to copy the tables from the old database (I had spent a LOT of time importing the data from a elemental spreadsheet) and got that into the backup copy then spent most of the rest of the day recreating the forms. At least it was easier this time since I knew what to do and already had the process down. I'm still quite new to this. And I made 2 backups that I recopied about every half hour. I'll try not to get caught out like that again.
Er, even during development it's a good idea to use a split
architecture, with tables in one MDB and forms, reports, etc., in
another MDB with links to the MDB where the data tables are. You
would have had one less hassle if you'd been doing that already.
Just a note. The repair function didn't do anything and it was pretty clear something was corrupted. It also wouldn't let me make new forms in that database. Kept complaining that it couldn't find something (tables, dependent queries, whatever).
OK, so lesson learned. Thanks for the input.
Backup Maniac Randy
Well, also, how often do you compile your database? Do you have
compile on demand turned off? Have you ever decompiled? How often
to you compact?
All of these things are part of the regular development process and
insure that your application does not develop irretrievable
corruption of one or more objects.
Keep in mind that from A2K on, your whole project is stored in a
single record of the system table (this is why two people can't
edit your project at the same time), so corruption of one object
can quite easily leak over to many other objects.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
[snip]
-------------------- Well, also, how often do you compile your database? Do you have compile on demand turned off? Have you ever decompiled? How often to you compact?
All of these things are part of the regular development process and insure that your application does not develop irretrievable corruption of one or more objects.
Keep in mind that from A2K on, your whole project is stored in a single record of the system table (this is why two people can't edit your project at the same time), so corruption of one object can quite easily leak over to many other objects.
Keep in mine that a year ago I didn't even know what Access was. So I'm
pretty much a newbie. I haven't compiled it at all. I thought you did that
when you were done. Not even sure how to decompile it. I hadn't realized
you could put the tables in one .mdb file and the forms, reports, etc in
another. I'll try messing with that a bit.
Seems the more I learn in this, the more I realize I don't know much.
Randy
/DECOMPILE is a command-line parameter, "officially undocumented" but
mentioned in some articles in the Knowledge Base (a great source of Access
help, BTW) at http://support.microsoft.com.
Create a separate shortcut on your desktop, right-click, and edit the
command line to include your database name and /DECOMPILE. In some
particular situations, of which yours might be one, decompiling can save you
a lot of trouble; on the other hand, it shouldn't be used willy-nilly
because in certain other situations, it could make some problems worse or
cause problems.
In the module window, I go into the Tools | Options and uncheck "Auto Syntax
Check" because it is such a pain to me to be interrupted before I finish
typing in a line of code. Having done that, before I save a change, I go to
Debug on the menu, and choose "Compile" -- that gives me a check that I
haven't created compilation errors (and it also compiles the modules, so
they don't have to be compiled on first use, thus slowing me down in
execution).
But, it is better to overemphasize saving backup copies during development
than to underemphasize it -- you don't have to keep every copy you save (but
with the miniscule price and humungous size of hard drives, these days, it
is feasible to do so if you have a "newish" machine).
Best of luck with your project.
Larry Linson
Microsoft Access MVP
"Randy Powell" <no********@nom ail.net> wrote in message
news:Xn******** *************** ***********@216 .168.3.44... [snip] -------------------- Well, also, how often do you compile your database? Do you have compile on demand turned off? Have you ever decompiled? How often to you compact?
All of these things are part of the regular development process and insure that your application does not develop irretrievable corruption of one or more objects.
Keep in mind that from A2K on, your whole project is stored in a single record of the system table (this is why two people can't edit your project at the same time), so corruption of one object can quite easily leak over to many other objects.
Keep in mine that a year ago I didn't even know what Access was. So I'm pretty much a newbie. I haven't compiled it at all. I thought you did that when you were done. Not even sure how to decompile it. I hadn't realized you could put the tables in one .mdb file and the forms, reports, etc in another. I'll try messing with that a bit.
Seems the more I learn in this, the more I realize I don't know much.
Randy
> Seems the more I learn in this, the more I realize I don't know much.
Oh, and then you open a copy of the Developer Handbook, and you really
realize how little you know... but learning is like that. pi********@hotm ail.com (Pieter Linden) wrote in
news:bf******** *************** **@posting.goog le.com: Seems the more I learn in this, the more I realize I don't know much.
Oh, and then you open a copy of the Developer Handbook, and you really realize how little you know... but learning is like that.
Thanks for the help. I sorta got tossed into this a year or so ago and have
been learning as fast as I can.
Randy bo*****@localho st.not (Larry Linson) wrote in
<EG************ ******@nwrddc01 .gnilink.net>: Create a separate shortcut on your desktop, right-click, and edit the command line to include your database name and /DECOMPILE.
Or, *don't* put in a database name, and then you can use it to
decompile *any* MDB, simply by choosing one from the FILE OPEN
dialog when Access opens.
. . . In some particular situations, of which yours might be one, decompiling can save you a lot of trouble; on the other hand, it shouldn't be used willy-nilly because in certain other situations, it could make some problems worse or cause problems.
It is more useful in A97, in my experience, than in A2K and beyond.
In the module window, I go into the Tools | Options and uncheck "Auto Syntax Check" because it is such a pain to me to be interrupted before I finish typing in a line of code. Having done that, before I save a change, I go to Debug on the menu, and choose "Compile" -- that gives me a check that I haven't created compilation errors (and it also compiles the modules, so they don't have to be compiled on first use, thus slowing me down in execution).
Also, in the VB window Options dialog, go to the GENERAL tab and
uncheck COMPILE ON DEMAND. If you want to know why, read this
article:
The real deal on the /Decompile switch http://trigeminal.com/usenet/usenet004.asp
But, it is better to overemphasize saving backup copies during development than to underemphasize it -- you don't have to keep every copy you save (but with the miniscule price and humungous size of hard drives, these days, it is feasible to do so if you have a "newish" machine).
I don't make backups very often and I don't lose projects.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Csaba2000 |
last post by:
I apologize for the length of the page below, but I've tried
to whittle it down as much as I can. The problem is that
Netscape 6.1 on my Win 2K Pro machine is disappearing
the final row of the table.
Opera 7.01 and IE 5 and 5.5 are both OK with the page, and
the offending line is right before the commented out alert line,
but I have been unable to figure why it's happening.
Thanks,
|
by: notalent |
last post by:
I'm having a problem with a very basic program. I'm creating a app in
Visual Studio (2003) C# to zip up a collection of specified files &
directories and save them to a certain location.
I have a checkedListBox that holds all the directories and files that I
want saved. I have two buttons (One for selecting file & one for
directory) that are hooked to a openFileDialog and folderBrowserDialog.
When a new file or dir is selected, it...
|
by: Howard Jess |
last post by:
In Opera 8.01 (Linux; Build 1204) and in Opera 7.54 (Windows XP; Build 3865),
my form disappears from the HTML markup (below). To summarize:
1) In a <script> block in the <head> I create a form element (part of
object/feature/bug detection).
2) There's a <form> element defined in the <body>, with the id 'theForm'.
3) The onload function tries to access that form, and also counts the
total number of forms in the document. It fails to...
|
by: John Wind |
last post by:
Hello,
I posted this problem in a thread on a seperate message, I'm not sure
I did it right so I started a new message, sorry for any problem this
has caused. This problem has me pulling my hair out, any help would be
appreciated
I am experiencing the disappearing text in combo boxes problem on two
machines I've just installed ( one a new machine and the other a
re-formatted older
|
by: Rachel Suddeth |
last post by:
Here is my scenario:
I have a few custom controls that I set up on a form and tested setting
properties and appearances.
Then I added a couple references to the project which add classes I need to
get data from the server to actually do something useful. (These are
generated by 3rd party database software.)
After adding those references, and no other changes to my form.... all the
controls disappear from the visual interface on the...
| |
by: Mike Moore |
last post by:
For some unreason my datasets keep disappearing from my
web forms/controls. I see them in the solution explorer window,
but when I do back to regenerate the dataset again the name of
the dataset is not displayed in the dropdown list to generate an existing
dataset. Help!
|
by: Mike Bulava |
last post by:
I have created a base form that I plan to use throughout my application let
call the form form1. I have Built the project then add another form that
inherits from form1, I add a few panel controls each with a couple of
controls in them I then rebuilt my project and my new panels and all
controls they contained are gone... I've looked through the Auto generated
code but don't see anything that looks wrong Any body have any idea why
this...
|
by: George Yefchak |
last post by:
Hi folks,
What's the latest news on the "disappearing controls" issue? I've seen a
few posts over the last several months indicating that other people have the
same problem, but I've seen nothing about a solution. Surely their ought to
be a patch by now!
Just to review, the problem is that at seemingly random intervals, a form
will open in design view in VB.net 2003 with some controls missing.
(Sometimes just one, and sometimes LOTS...
|
by: JDeats |
last post by:
I have many labels that are disappearing from my form when the user
resizes it, they seem to dissapear when certain width/height
thresholds are exceeded.
I have no code in place purposely trying to alter these controls on
maximize, minimize or form resize so whatever is causing this is
default behavior. The settings on the labels that are disappearing are
all default settings with the exception of Font, which is set to
Vernanda 8.25pt...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |