473,799 Members | 3,197 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Linking tables and memory growth

I have a large database application with user data in a backend and
forms, code etc in a frontend. It includes a facility for migrating
data from an earlier backend to the current backend by linking to the
second backend and moving data between corresponding tables. Problem is
that Access invariably crashes during this process.

I have taken the migrate forms and code into a separate database and
observed that the memory used by MSACCESS.EXE grows from about 28M to
235M after one migrate operation. There are a little over 200 tables in
the backend database so during the migrate, an additional 200 links are
created in the frontend. Access usually crashes on the second attempt.

I have narrowed the memory growth to the TransferDatabas e operation,
but it doesn't matter if I create the link, copy the data and then
delete it, or create all the links, use them and delete them as a
block. Generally it is in deleting the links that Access crashes.

Does anyone have any experience with this problem or any suggestions?

Watto

Oct 19 '06 #1
2 1880
Does anyone have any ... suggestions?

Don't use links. Just use SQL and explicit designations of the
databases.

eg.

CurrentDb.Execu te "INSERT INTO " _
& "[C:\Documents and Settings\Lyle\M y
Documents\Acces s\db1.mdb].[Table1] " _
& "SELECT * FROM " _
& "[C:\Documents and Settings\Lyle\M y
Documents\Acces s\db2.mdb].[Table1]"

Oct 19 '06 #2
Are all 200 tables really different? ie would it be possible to put
some of the tables into one table with an extra field indicating the
table it was originally in.

Although this may require reworking some of the queries you have
developed based on these tables you may find that this is not such a
difficult task and if a large number of these table are similar it
maybe one query where you previously had many.

watto wrote:
I have a large database application with user data in a backend and
forms, code etc in a frontend. It includes a facility for migrating
data from an earlier backend to the current backend by linking to the
second backend and moving data between corresponding tables. Problem is
that Access invariably crashes during this process.

I have taken the migrate forms and code into a separate database and
observed that the memory used by MSACCESS.EXE grows from about 28M to
235M after one migrate operation. There are a little over 200 tables in
the backend database so during the migrate, an additional 200 links are
created in the frontend. Access usually crashes on the second attempt.

I have narrowed the memory growth to the TransferDatabas e operation,
but it doesn't matter if I create the link, copy the data and then
delete it, or create all the links, use them and delete them as a
block. Generally it is in deleting the links that Access crashes.

Does anyone have any experience with this problem or any suggestions?

Watto
Oct 19 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1573
by: Dave Serrano | last post by:
I have a question about altering tables and growth of the database and transaction log. I have a database which is approximately 35GB. I had to make a change to a column in the largest table (approximately 7 million rows). I changed this column from varchar(30) to varchar(40). This column is not in any indexes or involved with any triggers. My database grew from 35GB to 56GB and my transaction log grew from 9GB to 25GB. Now all the...
10
2332
by: Generic Usenet Account | last post by:
I have worked out a very simple method for tracking the "memory growth" of a process at run time. It involves a header file and a shell script. Here's the header file: ////////// Header File Begin /////////////// #ifndef _VIRTMEMINFO_H_ #define _VIRTMEMINFO_H_ #include <stdio.h>
5
2182
by: Zambien | last post by:
Hi all, Here's my problem. I have tables that are using the menu/submenu idea for hiding rows. This works fine in IE (of course) and does show/hide correctly in netscape, but as soon as the shown method is called, the table gets skewed and the presentation of the data on the page goes horribly wrong. I don't think this is a table issue as I have spent alot of time staring at this code. Here is the html...
0
2249
by: gasturbtec | last post by:
please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database that is used to connect to other databases and generate reports. below is sample code of how the database does the linking i hope i give you enough info to help me but if not let me know and i will give more. Sub txtShipDataFileSub() Dim...
3
1204
by: Thomas F.O'Connell | last post by:
I'm helping manage a postgres installation that continually consumes a considerable amount of disk space, and I'm hoping to learn a bit more about both treating the symptoms and addressing the causes. Here are the basics: It's a pg 7.4.1 installation on a Debian stable GNU/Linux 2.6.2 box with 4GB RAM with 4 2.4 GHz processors and 36 GB of disk space. There are thousands of tables, many of which are object-relational
7
6937
by: Salvador | last post by:
Hi, I am using WMI to gather information about different computers (using win2K and win 2K3), checking common classes and also WMI load balance. My application runs every 1 minute and reports the status of the machines. Upon we follow the .NET object lifetime recommendations the application is constantly consuming more memory! The problem is on the ManagementObjectSearch, upon we Dispose the object it seems that is not releasing the...
74
4706
by: ballpointpenthief | last post by:
If I have malloc()'ed a pointer and want to read from it as if it were an array, I need to know that I won't be reading past the last index. If this is a pointer to a pointer, a common technique seems to be setting a NULL pointer to the end of the list, and here we know that the allocated memory has been exhausted. All good. When this is a pointer to another type, say int, I could have a variable that records how much memory is being...
81
4578
by: Peter Olcott | last post by:
It looks like System::Collections::Generic.List throws and OUT_OF_MEMORY exception whenever memory allocated exceeds 256 MB. I have 1024 MB on my system so I am not even out of physical RAM, much less virtual memory. Are other people experiencing this same problem?
4
1644
by: David C | last post by:
The w3wp.exe process' memory seems to go from below 200M to over 1G with no warning, causing Memory.Exception. I have searched around and read some answers, and most seem very vague. They say to "debug." Well duh, that is what I am trying to do, and there appears to be issues with my code or third party controls, but I need to pin point the culprits in my code. I can't use my Visual Studio.NET to "debug" obviously, so what are people...
0
9538
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10470
Oralloy
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...
0
10247
jinu1996
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...
1
10214
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,...
0
9067
agi2029
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...
0
6803
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4135
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
2
3751
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2935
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.