Hello,
This problem has been a little unusual for me. I have an Access
database, and, on several forms, I've seen this issue occur wotj
listbox and combobox controls.
Basically, I'm just putting either control on a form to serve as a
look-up to a table for a field on that form. It seems that, very
intermittently, the controls will not populate with data.
Sometimes you'll open the form, and no data will be displayed. When
it does not display, closing and re-opening the database and/or form
will sometimes fix the issue.
I've tried using the Access wizards to create the controls, and I
tried setting the properties manually.
From what I can tell, this only seems to occur on older PC's. The
OS's I've witnessed this on are Windows 95, 98SE, and NT 4.0 Terminal
Server. These PC's were at least 4-5 years old, running Pentium
(original) and AMD processors.
This database is in Access 2000 format running on PC's with Access
2000. During the development of this database, it has been created on
my PC with Windows 2000, Windows XP Pro, Access 2000, Access XP, and
Access 2003. I have yet to see this occur on my PC.
I've applied all Office and Windows service packs and updates I can
find. The only updates I'm thinking I have not tried yet are the
latest MDAC.
Any ideas on this?
Thanks.
3  1739 
I don't think the latest MDAC is going to be of any help.
I don't know what is causing the problem, but perhaps it is that the older
computers just don't have the computing power to keep up with everything,
or, even more likely, there just isn't enough memory.
If yours is an environment like many, the company may have quite a number of
unused Access 97 licenses. If that is the case, you might try reinstalling
Access 97 on those machines, saving the database in Access 97 format, and
seeing if that does not run better. Access 97 did not make as strong demands
on system resources as later versions, and was a stable, solid release of
Access.
If you did not use any Access-2000-specific functions in the application,
saving in Access 97 format will be easy; if you did, then you'll need to
replace those Access-2000-specific functions with alternatives compatible
with Access 97.
Larry Linson
Microsoft Access MVP
"Kenneth Courville" <kr*********@ms n.com> wrote in message
news:e4******** *************** **@posting.goog le.com... Hello,
This problem has been a little unusual for me. I have an Access
database, and, on several forms, I've seen this issue occur wotj
listbox and combobox controls.
Basically, I'm just putting either control on a form to serve as a
look-up to a table for a field on that form. It seems that, very
intermittently, the controls will not populate with data.
Sometimes you'll open the form, and no data will be displayed. When
it does not display, closing and re-opening the database and/or form
will sometimes fix the issue.
I've tried using the Access wizards to create the controls, and I
tried setting the properties manually.
From what I can tell, this only seems to occur on older PC's. The
OS's I've witnessed this on are Windows 95, 98SE, and NT 4.0 Terminal
Server. These PC's were at least 4-5 years old, running Pentium
(original) and AMD processors.
This database is in Access 2000 format running on PC's with Access
2000. During the development of this database, it has been created on
my PC with Windows 2000, Windows XP Pro, Access 2000, Access XP, and
Access 2003. I have yet to see this occur on my PC.
I've applied all Office and Windows service packs and updates I can
find. The only updates I'm thinking I have not tried yet are the
latest MDAC.
Any ideas on this?
Thanks.
Thanks for the response.
I'm not so sure it has to do with memory. I've seen this occur in a
session on a Win NT 4.0 terminal server with plenty of spare hard drive
space and a 1/2 Gb of RAM... usually a least a 100 Mb or so of that RAM
was available.
I am pretty convinced, though, that it has to do with older OS's
somehow.
They do not have any licenses for Office 97, and I have already
recommended that they replace their PC's with current technology, but
that seems to be out of the question at the moment.
I'm thinking I'll try to convince them to just add some RAM to one of
their PC's (assuming it's still sold) and see if it helps. They are all
running on 64 Mb, so it couldn't hurt.
Otherwise, they'll have to just live with it. I didn't charge them for
the database solution, so they have nothing to complain about if they
don't follow my recommendations .
---------------------------------------- http://members.tripod.com/kcourville0/
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Well, as far as Access and memory, "more is better" (within reasonable
bounds), so that may well help. As a matter of fact, as I look at miniumum
processor and memory requirements stated on the Office XP box, they appear
laughably low both for processor and memory.
You might also look at the O/S requirements... e.g., for Win NT 4.0, it
specifies SP 6. Could be that different things are causing the same problem
in different environments.
Larry Linson
Microsoft Access MVP
"Kenneth Courville" <krcourville@-nospam-msn.com> wrote in message
news:3f******** *************@n ews.frii.net... Thanks for the response.
I'm not so sure it has to do with memory. I've seen this occur in a
session on a Win NT 4.0 terminal server with plenty of spare hard drive
space and a 1/2 Gb of RAM... usually a least a 100 Mb or so of that RAM
was available.
I am pretty convinced, though, that it has to do with older OS's
somehow.
They do not have any licenses for Office 97, and I have already
recommended that they replace their PC's with current technology, but
that seems to be out of the question at the moment.
I'm thinking I'll try to convince them to just add some RAM to one of
their PC's (assuming it's still sold) and see if it helps. They are all
running on 64 Mb, so it couldn't hurt.
Otherwise, they'll have to just live with it. I didn't charge them for
the database solution, so they have nothing to complain about if they
don't follow my recommendations .
----------------------------------------
http://members.tripod.com/kcourville0/
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Hal Davison |
last post by:
I have read that most people do not like bound controls?
What is the reasoning for this point of view?
--
Hal Davison
Davison Consulting
|
by: kaborka |
last post by:
I have a WinForm with controls bound to a typed recordset that was generated
by the Dataset Designer. There are several ComboBox controls with their
DataSource bound to different lookup tables. Everything is working fine,
except when I need to handle a null default value in the data record coming
from the database. I want the combo whose SelectedValue is bound to that
field to display the "default" entry in the combo in this case. I...
|
by: Alfredo Barrientos |
last post by:
Hi,
I have been reading information about asp.net webcontrols, and i have
found a term "List bound controls".
What are "List Bound Controls"?? Which are the differences between
these controls and the others?? how many webcontrols are list bound
controls?? any url in microsoft.com talking about lista bound
controls??
|
by: Rick Mogstad |
last post by:
In VB6 it seemed as though bound controls (textboxes, etc) were kind of the newbie way to do
things, but were generally not good coding practice. Is this something that is different with
..NET? With the new data access methods is this the general way to display data? It seems easier,
but I guess i have some residual VB6 feelings about using bound controls.
Thanks
--
-Rick
|
by: yma |
last post by:
Hello,
I tried to display a column in MS Access 2000 nwind.mdb using 3 data
controls. But I got "It is
already opened exclusively by another user, or you need permission to view
its data." I put ole DataAdapter, Connection and dataset controls and fill
in the properties of the listbox. The only code I have is
OleDbDataAdapter1.Fill(DataSet11, "employees") in page_load sub.
| | |
by: gmccallum |
last post by:
I have a data entry screen using controls bound through a bindingSource,
TableAdaptor and a BindingNavigator to move through the records.
When I have an data entry error (such as Null for a value) I get the
following error raised all the way to the App.Run command.
This is not a dataGridView, so I can not use that DataError event to catch it.
I have tried the BindingSource_DataError event, but that does not seem to
get fired.
There is...
|
by: firozb |
last post by:
Good day to you,
I am using ASP.Net 2.0 with VS 2005. I have created a template page, with a Gridview, Formview, 2 objectdatasources linked to the views, as well as a multiview and a drop-down list for searching.
I have also written a base class that implements all the events that need to be handled. So when I create a new page, I just point to my template, configure the datasources, drop a few textboxes in the formview templates, and there...
|
by: cr113 |
last post by:
I'm trying to convert a windows app to ASP.NET using VS2005. I have
some web experience, but not much. 99% of the time if I need to
display data in a table in my windows apps I use a ListView object and
populate it manually using code like this:
ListView1.Items.Add("Jones")
ListView1.Items(ListView1.Items.Count - 1).SubItems.Add("123")
The result of this code would be a row added to the ListView like
this:
|
by: DaveRook |
last post by:
Hi
I am connecting to an Access database (using C# / ADO.net). All is going well!
However, I can not customise the lay out with grid view. It lays it out (as the name suggests) as a grid (yes, I can change colours of the boxes etc, but cannot add any formating/images).
I've been told not to use Repeater (by an MCTS) as it's now becoming out-dated. However, I know repeater did allow custom lay outs.
Websites like Play.com which show...
|
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: 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,...
| | |
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: 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: 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...
| |
