Null Values or Wierd Behavior based on a user's profile

givlerj

I need some help. Here is a little background, I support a MS Access 2k
DB (SQL Server 2k backend) that has courses and students. The problem
form lets the user pick a course from a drop down and opens a report of
the students attending the course in the dropdown. A user can't view on
1 course in the dropdown list. He can view other courses but not this
one. Other users on other computers can view the course just fine.
Furthermore, I was able to view the course when I logged into his
computer. (FYI all users are using the same mdb from a network file
share.) I set a breakpoint in the code behind and the id the course
record in the combo box is returning a null but for others it isn't and
opens the report just fine. I opened the query for the combo box and
the problem course isn't returning a null value in any of it's columns.

I think is must have something to do with this user's profile in MS
Office or Access 2000. Is there some setting or bug in MS Access that
can make Nulls return erroneously or just cause crazy behavior? Thanks
in advance for any help.

Nov 13 '05 #1

Subscribe Reply

1764

pietlinden

everyone is using the same database on the network share? Ooooh...
dont do that. split and distribute the front end. You're asking for
trouble.

Tools->Split Database.
Put the Backend on the server (will be suffixed with _BE usually)
then distribute the front end. And move all the static tables to the
front end.

Nov 13 '05 #2

david epsom dot com dot au

Selecting based on a combo box can be problematic, but
I've never seen it associated with a user profile before.

The normal problem is that combo boxes sometimes return
garbage values. You can sometimes see this by doing a
copy and paste: from a cbo with this problem, you will
copy a garbage value. The garbage value is the same
that a query will see, so of course it won't match correctly.

There are several theories about why this might be
so: it might also be confused by the problems parameter
queries sometimes have with field type in A2K.

In my case, I solved my problem by changing the
CBO data source so that it did not need to use
"DISTINCT" (unique values/unique records).

(david)

<gi*****@medsch .ucsf.edu> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .

I need some help. Here is a little background, I support a MS Access 2k
DB (SQL Server 2k backend) that has courses and students. The problem
form lets the user pick a course from a drop down and opens a report of
the students attending the course in the dropdown. A user can't view on
1 course in the dropdown list. He can view other courses but not this
one. Other users on other computers can view the course just fine.
Furthermore, I was able to view the course when I logged into his
computer. (FYI all users are using the same mdb from a network file
share.) I set a breakpoint in the code behind and the id the course
record in the combo box is returning a null but for others it isn't and
opens the report just fine. I opened the query for the combo box and
the problem course isn't returning a null value in any of it's columns.

I think is must have something to do with this user's profile in MS
Office or Access 2000. Is there some setting or bug in MS Access that
can make Nulls return erroneously or just cause crazy behavior? Thanks
in advance for any help.

Nov 13 '05 #3

Similar topics

5089

Blank form processing: POST values lost?

by: dmcconkey | last post by:

Hi folks, I have a client with four websites. Each site has a contact form that is identical. They all have "required" fields validated through a JavaScript onSubmit() function. Upon validation, post values go to a PHP processing page that adds values to a database and generates an email to someone in marketing. For three of these sites, we have no problem, but the fourth keeps sending in blank forms.

by: junky_fellow | last post by:

Can 0x0 be a valid virtual address in the address space of an application ? If it is valid, then the location pointed by a NULL pointer is also valid and application should not receive "SIGSEGV" ( i am talking of unix machine ) while trying to read that location. Then how can i distinguish between a NULL pointer and an invalid location ? Is this essential that NULL pointer should not point to any of the location in the virtual address...

C / C++

5132

is NULL-checking redundant in accessor-functions?

by: Mikhail Teterin | last post by:

Hello! Consider the following simple accessor function: typedef struct { int i; char name; } MY_TYPE; const char *

C / C++

6989

problems with $_POST returning NULL values in php 4.4.2

by: RDizzle | last post by:

okay. so all i am doing is changing a registration script that uses $_GET to a script that uses $_POST, but the validation script now returns NULL values for all posted vars. What's the deal? NOTE: when i use $_GET the script just works. Thanks in advance for helping a noob.

PHP

3097

profile values sometimes empty?

by: Eric Falsken | last post by:

I've added a number of additional properties to my profile. Sometimes, the values are populated when the user is retrieved from the database, but sometimes the values are empty/default. How can I make sure that the values are always populated correctly? Further example, my website is working reliably enough, but I'm trying to access the user profiles from an offline application, and very few of the custom properties are being returned to...

ASP.NET

1949

Session state null in profile provider

by: ashish | last post by:

hi all, I am writing a custom profile provider to save my business object as one of the properties of the profile however i am facing a problem' the HttpContext.Current.Session property is valid in in the Get PropertyValues method,

ASP.NET

2477

Can't send back null class reference as SOAP Header?

by: Joseph Geretz | last post by:

We use a Soap Header to pass a token class (m_Token) back and forth with authenticated session information. Given the following implementation for our Logout method, I vastly prefer to simply code m_Token = null in order to destroy the session token when the user logs out. However, I'm finding that setting class instance to null results in no header being sent back to the client, with the result that the client actually remains with an...

.NET Framework

2001

listing users by profile values

by: kpg* | last post by:

Hi all, Trying to use the ASP.NET 2.0 membeship API to manage users and user profiles, and of course, to provide role based security to my web app. I have several attributes I want to users, companyID for example, so I'm using the profile feature to do this and it works great. Now the problem:

ASP.NET

2331

Null on property

by: shapper | last post by:

Hello, I created a custom Profile provider as follows: public class Profile : ProfileBase { public Bio Bio { get; set; }

C# / C Sharp

8345

Changing the language in Windows 10

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,...

Windows Server

8858

Problem With Comparison Operator <=> in G++

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...

C / C++

8548

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

8634

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7371

AI Job Threat for Devs

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...

Career Advice

6186

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5657

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4349

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1757

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General