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, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
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
-
Netplwiz not working
by
RetiredGeek
38 minutes ago -
Windows 11 24H2 is broadly available
by
Alex5723
3 hours, 10 minutes ago -
Microsoft is killing Authenticator
by
Alex5723
1 hour, 44 minutes ago -
Downloads folder location
by
CWBillow
9 hours, 37 minutes ago -
Remove a User from Login screen
by
CWBillow
12 hours, 9 minutes ago -
TikTok fined €530 million for sending European user data to China
by
Nibbled To Death By Ducks
42 minutes ago -
Microsoft Speech Recognition Service Error Code 1002
by
stanhutchings
44 minutes ago -
Is it a bug or is it expected?
by
Susan Bradley
5 hours, 23 minutes ago -
Image for Windows TBwinRE image not enough space on target location
by
bobolink
15 hours, 56 minutes ago -
Start menu jump lists for some apps might not work as expected on Windows 10
by
Susan Bradley
23 hours, 55 minutes ago -
Malicious Go Modules disk-wiping malware
by
Alex5723
13 hours, 32 minutes ago -
Multiple Partitions?
by
CWBillow
14 hours, 12 minutes ago -
World Passkey Day 2025
by
Alex5723
1 day, 7 hours ago -
Add serial device in Windows 11
by
Theodore Dawson
1 day, 22 hours ago -
Windows 11 users reportedly losing data due forced BitLocker encryption
by
Alex5723
2 hours, 44 minutes ago -
Cached credentials is not a new bug
by
Susan Bradley
2 days, 3 hours ago -
Win11 24H4 Slow!
by
Bob Bible
2 days, 3 hours ago -
Microsoft hiking XBox prices starting today due to Trump’s tariffs
by
Alex5723
2 days ago -
Asus adds “movement sensor” to their Graphics cards
by
n0ads
2 days, 5 hours ago -
‘Minority Report’ coming to NYC
by
Alex5723
2 days, 2 hours ago -
Apple notifies new victims of spyware attacks across the world
by
Alex5723
2 days, 14 hours ago -
Tracking content block list GONE in Firefox 138
by
Bob99
2 days, 13 hours ago -
How do I migrate Password Managers
by
Rush2112
1 day, 21 hours ago -
Orb : how fast is my Internet connection
by
Alex5723
1 day, 23 hours ago -
Solid color background slows Windows 7 login
by
Alex5723
3 days, 2 hours ago -
Windows 11, version 24H2 might not download via Windows Server Updates Services
by
Alex5723
3 days ago -
Security fixes for Firefox
by
Susan Bradley
1 hour, 45 minutes ago -
Notice on termination of services of LG Mobile Phone Software Updates
by
Alex5723
3 days, 12 hours ago -
Update your Apple Devices Wormable Zero-Click Remote Code Execution in AirPlay..
by
Alex5723
3 days, 21 hours ago -
Amazon denies it had plans to be clear about consumer tariff costs
by
Alex5723
3 days, 12 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.