In an earlier post entitled...
"A97 closes down each time I open a particular report"
it has been suggested that I rebuild problematic table - one in which
some corruption has occurred. I don't know which table is the problem,
so I would like to rebuild them all in a new database. I'm sure most
of you would cringe at the thought of having to do this manually for
most of your applications.
So, I'm writing to ask if any of you have written code to print the
vital elements required to construct your own tables from within code.
Something to automate the process, if you know what I mean. Manually
building a table isn't such a big deal. But 51 of them? That's another
story altogether.
So many individual field properties to keep up with! Wow, there's lots
of room for oversights and outright mistakes. Would like to create a
list of STUFF for each table that I could parse & import into code to
allow me to recreate the tables automatically - inside a VBA class
module.
I'm afraid of simply EXPORTING any existing table (structure only) for
fear of the unknown - I simply don't know whether any corruption that
might be present in any of my existing tables would be transferred to
the copies created.
Nov 13 '05
25  1898 
MLH wrote: Well, if it breaks again, I'll try this. But right now, its fixed.
I have not seen the problem again since rebuilding the
report as you suggested. I will be more assured the prob
is gone if, after a few days, it still seems to be gone.
Is the recordsource a stored query or a SQL string?
Yes, the recordsource is a stored query.
Try switching from one to the other.
(in a few)
ANd try setting the recordsource in the report's OnOpen event as
another way to test this kind of problem.
(again, in a few)(
One other option, if it continues to blow up, is to try a /decompile
switch on the icon to open Access. It will decompile the code. Then
recompile all/save.
Salad <oi*@vinegar.co m> wrote in
news:5%******** **********@news read2.news.pas. earthlink.net: MLH wrote:
Well, if it breaks again, I'll try this. But right now, its
fixed. I have not seen the problem again since rebuilding the
report as you suggested. I will be more assured the prob
is gone if, after a few days, it still seems to be gone.
Is the recordsource a stored query or a SQL string?
Yes, the recordsource is a stored query.
Try switching from one to the other.
(in a few)
ANd try setting the recordsource in the report's OnOpen event as
another way to test this kind of problem.
(again, in a few)(
One other option, if it continues to blow up, is to try a
/decompile switch on the icon to open Access. It will decompile
the code. Then recompile all/save.
Well, a decompile is a little more complex than that. Here are the
stops for the most successful decompile:
1. backup the MDB
2. compact it
3. decompile it
4. open the MDb in a new instance of Access (never use the one
opened to decompile for anything but the decompile) and compact it
again.
5. compile and save all.
6. compact the MDB.
It's important to not leave out any of these steps because you want
to make sure that all the discraded data pages within the MDB are
removed before you do the compile and save all.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
I guess I'll have to give this a try. Just blew again on me. It is
frustrating, not knowing where the corruption lies. And even
moreso when the nature of the corruption is such that evidence
of the problem inconsistent.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxx
One other option, if it continues to blow up, is to try a
/decompile switch on the icon to open Access. It will decompile
the code. Then recompile all/save.
Well, a decompile is a little more complex than that. Here are the
stops for the most successful decompile:
1. backup the MDB
2. compact it
3. decompile it
4. open the MDb in a new instance of Access (never use the one
opened to decompile for anything but the decompile) and compact it
again.
5. compile and save all.
6. compact the MDB.
It's important to not leave out any of these steps because you want
to make sure that all the discraded data pages within the MDB are
removed before you do the compile and save all.
David W. Fenton wrote: One other option, if it continues to blow up, is to try a
/decompile switch on the icon to open Access. It will decompile
the code. Then recompile all/save.
Well, a decompile is a little more complex than that. Here are the
stops for the most successful decompile:
1. backup the MDB
Check,
2. compact it
Check
3. decompile it
Check
4. open the MDb in a new instance of Access (never use the one
opened to decompile for anything but the decompile) and compact it
again.
Huh? If I add /excl /decompile it decompiles and opens the database.
So the database is open and it tells me I should now Compile the code.
Should the database be closed and reopened w/o the decompile switch and
then compacted? IS that what #4 means?
5. compile and save all.
Check
6. compact the MDB.
Check.
These are basically the steps I use...except for #4 which I don't
understand.
It's important to not leave out any of these steps because you want
to make sure that all the discraded data pages within the MDB are
removed before you do the compile and save all.
Salad <oi*@vinegar.co m> wrote in
news:LO******** *******@newsrea d3.news.pas.ear thlink.net: David W. Fenton wrote:One other option, if it continues to blow up, is to try a
/decompile switch on the icon to open Access. It will decompile
the code. Then recompile all/save.
Well, a decompile is a little more complex than that. Here are
the stops for the most successful decompile:
1. backup the MDB
Check,
2. compact it
Check
3. decompile it
Check
4. open the MDb in a new instance of Access (never use the one
opened to decompile for anything but the decompile) and compact
it again.
Huh? If I add /excl /decompile it decompiles and opens the
database. So the database is open and it tells me I should now
Compile the code. Should the database be closed and reopened w/o
the decompile switch and then compacted? IS that what #4 means?
Yes, because MichKa advised us that the decompile switch puts Access
in a state that may not be good for doing anything else. 5. compile and save all.
Check
6. compact the MDB.
Check.
These are basically the steps I use...except for #4 which I don't
understand.
I don't know if it does cause problems, but MichKa very strongly
advised against using any instance of Access opened with the
decompile switch for any purpose other than the decompile. He said
to close it and do anything else in a fresh instance of Access.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David W. Fenton wrote: Salad <oi*@vinegar.co m> wrote in
news:LO******** *******@newsrea d3.news.pas.ear thlink.net:
David W. Fenton wrote:
One other option, if it continues to blow up, is to try a
/decompile switch on the icon to open Access. It will decompile
the code. Then recompile all/save.
Well, a decompile is a little more complex than that. Here are
the stops for the most successful decompile:
1. backup the MDB
Check,
2. compact it
Check
3. decompile it
Check
4. open the MDb in a new instance of Access (never use the one
opened to decompile for anything but the decompile) and compact
it again.
Huh? If I add /excl /decompile it decompiles and opens the
database. So the database is open and it tells me I should now
Compile the code. Should the database be closed and reopened w/o
the decompile switch and then compacted? IS that what #4 means?
Yes, because MichKa advised us that the decompile switch puts Access
in a state that may not be good for doing anything else.
5. compile and save all.
Check
6. compact the MDB.
Check.
These are basically the steps I use...except for #4 which I don't
understand.
I don't know if it does cause problems, but MichKa very strongly
advised against using any instance of Access opened with the
decompile switch for any purpose other than the decompile. He said
to close it and do anything else in a fresh instance of Access.
Gotcha. Thanks for the update. Like I said, that's pretty much what I
did...but closing after decompile and then compacting then recompiling. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Roman Schicht |
last post by:
I have an 9i RAC on W2K-Advanced Server with 2 Nodes. The 2nd Node has
to be reinstalled from scratch for a problem with Windows.
What must be done (before and) after ReInstallation, that the RAC will
be the same as before??
Thanks for every Advice..
KR
|
by: Beyonder |
last post by:
I have five tables in my database, there are actually NO common fields
between them, not even a KEY or ID or anything like that, except for
the "body" of a blob field. and that text is not identical, just a
portion of that text is identical.
each table has 5 fields, all different except the blob, which is
called "message", so normally I use something like:
select * from table1 where message like '%apple%';
|
by: xo55ox |
last post by:
Hi,
I want to find out what is a good way to identify indexes that need
rebuilding. I tried to run DBCC showcontig and identify them based on
the scan density %. And according to a Microsoft Tech Net - All About
SQL Server Indexes discussion, the expert stated that based on the
Density (below 20%), I can pick out those indexes associated to the
table and run DBCC INDEXDEFRAG. But instead, I ran DBCC DBREINDEX to
rebuild all indexes...
|
by: aleatory |
last post by:
Hi Access masters,
Sorry for asking a very simple question, but how
could I locate source tables which have been linked
into the Access database? The following is an ASCII-
based screen shot:
| +===============================================
| | db1: Database
| +-----------------------------------------------
|
by: ortaias |
last post by:
A couple of my forms may be corrupted. I am using ACCESS2000. I have
noticed that on a couple of forms, my computer's CPU usage hits 100%
and stays there. Running the compacting/repair tool only provided
temporary relief. These forms have been checked for "bad" code, but
none was observed, also these forms previously did not seem to eat-up
the CPU usage. I am assuming that the best strategy to solve this
problem would be to rebuild...
| | |
by: Eugene |
last post by:
Hi all,
I have the following table
Name Date Wish Valid
Name is person's name, date defaults to getdate() and is never
assigned directly (datetime field), Wish is some message, and Valid is
bit, 1 indicates if the wish is the latest, and therefore valid. All
previous wishes are kept in database, and are "invalidated" by setting
|
by: Johnny Jörgensen |
last post by:
Can anybody please clarify to me what the difference between Build and
Rebuild is in Visual Studio 2005?
Cheers,
Johnny J.
|
by: digitalox |
last post by:
All efforts to rebuild indexes fails. Not with an error, but they still show high fragmentation.
The environment:
SQL Server 2005 in 2000 compatibility mode
non-clustered indexes on tables that have clustered indexes with unique constraint
Tried so far:
Rebuild, reorganize, manual drop and recreate, setting the db in 2005 mode
This only seems to happen on the tables that also have the clustered index with a unique contraint ( which...
|
by: dsdevonsomer |
last post by:
Hello all,
I am new to managing indexes on large tables and need some help.
Hopefully, I am not repeating question here. I searched as much as I
can, but not finding relatively best answer..
Here is my scenario.
I have 2 tables with more than 4 mil rows (1 - 2.8 Mil, 2 2.1 mil). Of
these tables, there are about 25 ( select ) queries run to help
generate reports every week.
|
by: afromanam |
last post by:
Whew..
OK, running access 2003 in win xpsp2 and access 2007 in win vista.
This is the question...
We have a db, split in front end (FE.mdb) and backend (BE.mdb)
FE has tons of linked tables from BE.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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: 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...
| |
