A friend of mine who programs in SQL Server and C++ told me that I should not use Nulls in my Access database and related code. He says that if I link to other Dbs that I may run into problems. I can understand that there may be problems if I set a value to Null. But if I test for Null (IsNull), will that cause a problem? Also, when would IsEmpty be used? Any suggestions?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Using Nulls
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Using Nulls
- This topic has 9 replies, 4 voices, and was last updated 24 years, 3 months ago.
Viewing 1 reply threadAuthorReplies-
WSBCKessinger
AskWoody Lounger -
WSBart
AskWoody LoungerJanuary 30, 2001 at 7:11 pm #512303If you stick to Access, working with Null values is no problem. If you want to migrate to other DBMS-es, you may bump into a DBA who is only implementing fields that do not allow NULLS.
Also there are (not much) some database systems that won’t allow NULL values into their fields.Then you will have problem….
But: hey, what’s wrong with Access, works fine for me and my clients!
-
WSwtl3
AskWoody LoungerJanuary 30, 2001 at 7:24 pm #512306Hi Bart,
I’ve made an Access database for product testing results. My boss would like me to find a way to link to the SQL server inventory maintenance database to read and write material usage allocations. I’m just trying to find out how I might avoid problems before they occur.
I like to investigate all the angles before I tackle a new problem. But I’m still new to all this. -
WScharlotte
AskWoody LoungerJanuary 31, 2001 at 2:32 am #512368SQL Server doesn’t have anything against nulls per se. However, you can’t include null values in indexes, so you aren’t allowed to create a primary key with a field that might be null. If you create a unique key in Access with a field that can be null, you’ll discover that any record that contains a null in one of the fields in that key can be entered over and over again.
From that perspective alone, it isn’t a good idea to allow null values in an indexed field or a field that’s part of an index. It’s a better idea to use a default value that means[/] no value has been assigned, rather than allowing a null. For example, I usually append a record that contains a zero for the autonumber field and things like “(Unknown)” for text fields to tables with autonumer keys . Then you can still enforce referential integrity if you make the default for the connecting field in another table insert a zero for that field until the user actually enters a value.
-
WSwtl3
AskWoody LoungerJanuary 31, 2001 at 1:28 pm #512431Thanks Charlotte,
That is the kind of info I need. So I would imagine that to be on the safe side, I need to be sure that any blank field I send back to the SQL Server Db would need to contain an empty field marker of some sort. Will the SQL Server automatically do this or will I need to know the specific way it was done for that particular Db? -
WScharlotte
AskWoody LoungerJanuary 31, 2001 at 3:11 pm #512460When you send a Null field back, you are sending an “empty field” marker. There is no such things as an empty field, really. There are populated fields and unpopulated fields, and the unpopulated fields are Null by definition. SQL Server translates them that way. If you want to be doubly sure, set the default property for all fields to Null for text and date fields and 0 for numeric fields.
-
WSwtl3
AskWoody Lounger -
WSBart
AskWoody LoungerJanuary 31, 2001 at 7:47 pm #512505You can have SQL server do this for you. You can put a trigger on the table and have a stored procedure checking whether a particular field is empty or not. If empty then the stored procedure can set the empty field marker.
This is very save way of working with SQL server because it also works if data is changed by another application then you Access application.Oh boy, triggers, stored procedures, I realy hope they will come available in the next version of MS Access…..
-
WScharlotte
AskWoody LoungerFebruary 1, 2001 at 3:08 am #512584
-
-
-
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Login screen icon
by
CWBillow
3 hours, 47 minutes ago -
AI coming to everything
by
Susan Bradley
15 minutes ago -
Mozilla : Pocket shuts down July 8, 2025, Fakespot shuts down on July 1, 2025
by
Alex5723
11 hours, 15 minutes ago -
No Screen TurnOff???
by
CWBillow
11 hours, 37 minutes ago -
Identify a dynamic range to then be used in another formula
by
BigDaddy07
12 hours, 10 minutes ago -
InfoStealer Malware Data Breach Exposed 184 Million Logins and Passwords
by
Alex5723
23 hours, 46 minutes ago -
How well does your browser block trackers?
by
n0ads
10 hours, 4 minutes ago -
You can’t handle me
by
Susan Bradley
2 hours, 32 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
2 hours, 41 minutes ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
1 day, 11 hours ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
14 hours, 39 minutes ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
1 day, 11 hours ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
1 day, 11 hours ago -
Lumma malware takedown
by
EyesOnWindows
23 hours, 54 minutes ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
1 day, 20 hours ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
1 day, 20 hours ago -
Meet Gemini in Chrome
by
Alex5723
2 days ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
2 days ago -
Trump signs Take It Down Act
by
Alex5723
2 days, 8 hours ago -
Do you have a maintenance window?
by
Susan Bradley
13 hours, 13 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
1 day, 10 hours ago -
Cox Communications and Charter Communications to merge
by
not so anon
2 days, 11 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
3 hours, 58 minutes ago -
hibernate activation
by
e_belmont
2 days, 20 hours ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
3 days ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
3 days, 3 hours ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
3 days, 3 hours ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
1 day, 23 hours ago -
Out of band for Windows 10
by
Susan Bradley
3 days, 8 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
3 days, 15 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.