Been using Access 97 for years. I use a statistics add-on (Total
Access Statistics) which is kind of expensive and I haven't found
anything to be gained by upgrading. But I'm now told I probably should
because of memory issues with Access 97 which are getting increasingly
fussy.
I'm told that, at best, Access 2007 isn't really very good, that the
better memory management came with 2003.
Any thots? Also, is Vista really that bad?
6  2299 
On Apr 14, 6:33*pm, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
Been using Access 97 for years. *I use a statistics add-on (Total
Access Statistics) which is kind of expensive and I haven't found
anything to be gained by upgrading. But I'm now told I probably should
because of memory issues with Access 97 which are getting increasingly
fussy.
I'm told that, at best, Access 2007 isn't really very good, that the
better memory management came with 2003.
Any thots? Also, is Vista really that bad?
I like Vista.
Before we recommend replacement, perhaps you could review the
diagnosis for us.
What symptoms does the Access 97 application display?
Why would memory issues with Access 97 become increasingly fussy?
Why do you think an updated version of Access will help?
On Apr 14, 5:16 pm, lyle <lyle.fairfi... @gmail.comwrote :
On Apr 14, 6:33 pm, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
Been using Access 97 for years. I use a statistics add-on (Total
Access Statistics) which is kind of expensive and I haven't found
anything to be gained by upgrading. But I'm now told I probably should
because of memory issues with Access 97 which are getting increasingly
fussy.
I'm told that, at best, Access 2007 isn't really very good, that the
better memory management came with 2003.
Any thots? Also, is Vista really that bad?
I like Vista.
Before we recommend replacement, perhaps you could review the
diagnosis for us.
What symptoms does the Access 97 application display?
Why would memory issues with Access 97 become increasingly fussy?
Why do you think an updated version of Access will help?
Thanks Lyle
The temp file constantly maxes out.
Since Access's max file size hasn't really changed in 12 years (why's
that, anyway?), I'm warehousing the data in SQL server, and ODBC
linking to Access 97.
I'm now having to chop queries into manageable chunks, doing multiple
statistical runs.
So you think Vista is OK, eh?
I appreciate your input!
JK
On Apr 15, 12:27*am, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
On Apr 14, 5:16 pm, lyle <lyle.fairfi... @gmail.comwrote :
On Apr 14, 6:33 pm, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
Been using Access 97 for years. *I use a statistics add-on (Total
Access Statistics) which is kind of expensive and I haven't found
anything to be gained by upgrading. But I'm now told I probably should
because of memory issues with Access 97 which are getting increasingly
fussy.
I'm told that, at best, Access 2007 isn't really very good, that the
better memory management came with 2003.
Any thots? Also, is Vista really that bad?
I like Vista.
Before we recommend replacement, perhaps you could review the
diagnosis for us.
What symptoms does the Access 97 application display?
Why would memory issues with Access 97 become increasingly fussy?
Why do you think an updated version of Access will help?
Thanks Lyle
The temp file constantly maxes out.
Since Access's max file size hasn't really changed in 12 years (why's
that, anyway?), I'm warehousing the data in SQL server, and ODBC
linking to Access 97.
I'm now having to chop queries into manageable chunks, doing multiple
statistical runs.
So you think Vista is OK, eh?
I appreciate your input!
JK
I'm guessing this temp file is actually a temp table, the child of the
Statistics Add-In and that you have no control over its location?
If you did have control, you could create the temp table in a separate
JET MDB file.
But you would still be limited to a nominal one gigabyte file size.
My experience is that when one is not enough, it's quite possible that
two won't be enough for very long.
You already have used SQL-Server. Descriptions of the last two
versions of Total Access Statistics say that it can use an ADP (ADPs
are OLEDB linked to SQL Server, not ODBC linked; SQL-Server's
strengths are exposed in this way). So you could use any Access ADP-
Compliant version, 2000, 2002 or 2003 with X.7, or the newest 2007
version with Access 2007; in my opinion SQL-Server is much more likely
to accommodate your storage needs than any version of JET or ACE.
If you're going to an Access/JET/ACE only solution, you may have check
the implications of unicode. My hazy recollection of JET storage is
that it was Ansi only, then a choice of Ansi or Unicode, then Unicode.
A two gigabyte Unicode file might not hold exactly twice as much data
(as we see the data) as a one gigabyte Ansi file. Of course, your data
may be largely floats, in which case Unicode or not Unicode might not
be of much consequence.
On Apr 15, 3:19 am, lyle <lyle.fairfi... @gmail.comwrote :
On Apr 15, 12:27 am, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
On Apr 14, 5:16 pm, lyle <lyle.fairfi... @gmail.comwrote :
On Apr 14, 6:33 pm, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
Been using Access 97 for years. I use a statistics add-on (Total
Access Statistics) which is kind of expensive and I haven't found
anything to be gained by upgrading. But I'm now told I probably should
because of memory issues with Access 97 which are getting increasingly
fussy.
I'm told that, at best, Access 2007 isn't really very good, that the
better memory management came with 2003.
Any thots? Also, is Vista really that bad?
I like Vista.
Before we recommend replacement, perhaps you could review the
diagnosis for us.
What symptoms does the Access 97 application display?
Why would memory issues with Access 97 become increasingly fussy?
Why do you think an updated version of Access will help?
Thanks Lyle
The temp file constantly maxes out.
Since Access's max file size hasn't really changed in 12 years (why's
that, anyway?), I'm warehousing the data in SQL server, and ODBC
linking to Access 97.
I'm now having to chop queries into manageable chunks, doing multiple
statistical runs.
So you think Vista is OK, eh?
I appreciate your input!
JK
I'm guessing this temp file is actually a temp table, the child of the
Statistics Add-In and that you have no control over its location?
If you did have control, you could create the temp table in a separate
JET MDB file.
But you would still be limited to a nominal one gigabyte file size.
My experience is that when one is not enough, it's quite possible that
two won't be enough for very long.
You already have used SQL-Server. Descriptions of the last two
versions of Total Access Statistics say that it can use an ADP (ADPs
are OLEDB linked to SQL Server, not ODBC linked; SQL-Server's
strengths are exposed in this way). So you could use any Access ADP-
Compliant version, 2000, 2002 or 2003 with X.7, or the newest 2007
version with Access 2007; in my opinion SQL-Server is much more likely
to accommodate your storage needs than any version of JET or ACE.
If you're going to an Access/JET/ACE only solution, you may have check
the implications of unicode. My hazy recollection of JET storage is
that it was Ansi only, then a choice of Ansi or Unicode, then Unicode.
A two gigabyte Unicode file might not hold exactly twice as much data
(as we see the data) as a one gigabyte Ansi file. Of course, your data
may be largely floats, in which case Unicode or not Unicode might not
be of much consequence.
I do get the Total Access Statistics generated error message, but I
also get it straight out of Access 97.
In the old dBase days I could set temp in the environment. I can't
seem to do that anymore...
Just a passing thought, but have you had a look at using Postgres and
implementing the R statistical package with it (PL/R)? Both are very
capable products, and both are open source. I am not entirely sure of
your needs here, but it might be worth a look.
Just my two cents
Cheers
The Frog
On Apr 15, 9:36 am, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
On Apr 15, 3:19 am, lyle <lyle.fairfi... @gmail.comwrote :
On Apr 15, 12:27 am, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
On Apr 14, 5:16 pm, lyle <lyle.fairfi... @gmail.comwrote :
On Apr 14, 6:33 pm, "jkmo...@gmail. com" <jkmo...@gmail. comwrote:
Been using Access 97 for years. I use a statistics add-on (Total
Access Statistics) which is kind of expensive and I haven't found
anything to be gained by upgrading. But I'm now told I probably should
because of memory issues with Access 97 which are getting increasingly
fussy.
I'm told that, at best, Access 2007 isn't really very good, that the
better memory management came with 2003.
Any thots? Also, is Vista really that bad?
I like Vista.
Before we recommend replacement, perhaps you could review the
diagnosis for us.
What symptoms does the Access 97 application display?
Why would memory issues with Access 97 become increasingly fussy?
Why do you think an updated version of Access will help?
Thanks Lyle
The temp file constantly maxes out.
Since Access's max file size hasn't really changed in 12 years (why's
that, anyway?), I'm warehousing the data in SQL server, and ODBC
linking to Access 97.
I'm now having to chop queries into manageable chunks, doing multiple
statistical runs.
So you think Vista is OK, eh?
I appreciate your input!
JK
I'm guessing this temp file is actually a temp table, the child of the
Statistics Add-In and that you have no control over its location?
If you did have control, you could create the temp table in a separate
JET MDB file.
But you would still be limited to a nominal one gigabyte file size.
My experience is that when one is not enough, it's quite possible that
two won't be enough for very long.
You already have used SQL-Server. Descriptions of the last two
versions of Total Access Statistics say that it can use an ADP (ADPs
are OLEDB linked to SQL Server, not ODBC linked; SQL-Server's
strengths are exposed in this way). So you could use any Access ADP-
Compliant version, 2000, 2002 or 2003 with X.7, or the newest 2007
version with Access 2007; in my opinion SQL-Server is much more likely
to accommodate your storage needs than any version of JET or ACE.
If you're going to an Access/JET/ACE only solution, you may have check
the implications of unicode. My hazy recollection of JET storage is
that it was Ansi only, then a choice of Ansi or Unicode, then Unicode.
A two gigabyte Unicode file might not hold exactly twice as much data
(as we see the data) as a one gigabyte Ansi file. Of course, your data
may be largely floats, in which case Unicode or not Unicode might not
be of much consequence.
I do get the Total Access Statistics generated error message, but I
also get it straight out of Access 97.
In the old dBase days I could set temp in the environment. I can't
seem to do that anymore...
What exactly is the error message you are getting?
Bruce This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: deko |
last post by:
Do I get more scalability if I split my database? The way I calculate
things now, I'll be lucky to get 100,000 records in my Access 2003 mdb.
Here some math:
Max mdb/mde size = 2000 x 1024 = 2,048,000k
Let's say on average each record in the database consumes 15k
2,048,000/15 = 136,533 records
|
by: Paul H |
last post by:
Most of my projects are developed in Access 2003. I have not even installed
Office 2007 yet!
I need to buy VSTO to get the run-time licence for Access 2003. No doubt I
will soon need a run-time licence for Access 2007. Is there a version of
VSTO that has the Access run-time licence for both version of Access? Or
will I need to buy VSTO 2003 now and then VSTO 2007 at a later date?
Thanks,
|
by: Wayne |
last post by:
I've been having a click around Access 2007 this afternoon and have
discovered some things that range from annoying to alarming. My
Access 2003 menu bars, which I, like many others, use extensively, are
now hidden behind an "Add Ins" tab on the Ribbon. Hardly an intuitive
place for a user to find them. Unless my memory is failing me, I'm
sure that Access 2003 menus displayed normally in the 2007 Beta.
The other thing I've discovered...
|
by: prn |
last post by:
Hi folks,
I'm relatively new to Access, but I seem to have drawn the short straw, so I have the assignment for my workplace of looking for problems/inconsistencies in migrating applications to Access 2007 from previous versions. We don't have a lot of Access applications, but even a dozen or so can be an interesting challenge. I have loaded a few that were created in Access 2003 into Access 2007 and all of the ones I have tried have come up...
|
by: Neil |
last post by:
A client of mine likes some of the new bells and whistles in Access 2007,
and is thinking about converting our A03 format MDB to an A07 format file.
However, while some of the users have A07, many do not, and it's not clear
when they would get it. His thought was to use the upcoming Access 2007
runtime to allow the users who are still running Office 2003 to be able to
run the database.
While I use multiple versions of Access on my...
| | |
by: elias.farah |
last post by:
Hello Everyone,
I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).
The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.
Under Access 2007, a couple of forms are now taking 60 seconds to
|
by: raylopez99 |
last post by:
10 years ago, the below was written (see very end, after my signature
RL).
What, if anything, has changed?
I have Access 2003 and soon Access 2007 on a Windows XP Professional
or Windows Vista Ultimate machine, with SQL Server Express running on
it, and I want somebody, with a password (which I will provide) to be
able to log onto a A03 or A07 dB from the internet. Now that I type
this I realize that unless I put the database onto a...
|
by: tony.abbitt |
last post by:
I have recently installed Office 2007 (SP1) retaining the previous
installation of Office 2003.
I have converted an Access 2003 database to Access 2007. The database
contains the VBA code 'DoCmd.RunCommand acCmdLinkTables' to initiate
the dialog box to rebuild links to tables held in a back-end Access
database (which has also been converted from Access 2003 to Access
2007).
The code runs without problem in the original Access 2003...
|
by: prakashwadhwani |
last post by:
Hi !! I'm about to develop a new project for a client.
Should I go about it in Access 2003 or 2007 ? Purchasing it either
for me or for my client is not a major consideration here ... what I'd
like to know is the stability, speed & ease of use of both the
products.
I believe Access 2007 has a new file format too and that it may be
slower.
|
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: 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: 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
| |
