- Software Like Access
- Free Software Like Access
- Database Software Like Microsoft Access
- Free Database Software Like Access
- Database Software Like Access
- Remote Access Software
Anyone who deals with SQL and Access queries is probably familiar with the LIKE statement and the use of the standard wildcards (% or *).
Less documented however is the additional wild cards that you should be aware of if you are building queries that will be run against your database when constructing more complicated LIKE statements.
Looking for examples of common use case that database software/apps like access could help us with. Then could see what common things these software/apps can help us with. For example, can see if airtable does it. What things does the free version do that would help us that all other free spreadsheet options do not do? Parallels RAS provides access to desktop applications as if they were native apps on mobile devices. Boost your mobile employees' productivity by supporting iOS, Android and Chromebook. Employees can utilize native mobile-device gestures—such as zoom in, tap to click and more—to interact seamlessly with desktop applications.
The following describes the wildcard’s that are available in Microsoft SQL.
Microsoft T-SQL LIKE statement wildcards | ||
Wildcard character | Description | Example |
% | Any string of zero or more characters. | SELECT*FROM [myTable] WHERE [title] LIKE‘%computer%’This will find all the entries the column ‘title’ from ‘myTable’ contains the word ‘computer’ anywhere in the field. |
_ (underscore) | Any single character. | SELECT *FROM [myTable] WHERE [surname] LIKE‘sm_th’ This will find all five-letter last names that start with ‘sm’ and end with ‘th’ (for example Smith, Smeth, etc). |
[…] | Any single character within the specified range ([a-f]) or set ([abcdef]) or a numeric range [0-9]. | SELECT *FROM [myTable] WHERE [surname] LIKE‘[C-P]arsen’ This will find all the last names ending with arsen and starting with any single character between C and P, for example Carsen, Larsen, Karsen, Paresen, etc. |
[^] | Any single character not within the specified range ([^a-f]) or set ([^abcdef]). School apps for macbook. | SELECT *FROM [myTable] WHERE [surname] LIKE‘de[^l]%’ This will get all the last names starting with de and where the following letter is not l, for example it will return Desmond, but not Delimetry. |
Microsoft Access, part of the Microsoft Office Suite, is a database management system for Windows that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access stores data in its own format based on the Access Jet Database Engine. Remote access software allows local users to establish a connection with a remote device or network. The software can be installed directly onto a device and accessed over the internet at any time. Widely used by employees at large and medium-sized companies who run on a corporate network, remote access facilitates improved processes for IT support workers and enables more streamlined. The software is split into two main products: Tiles and Slate. Each of these is built to scale to the business needs. Tiles is a sales analytics tool built specifically for Salesforce data. Access ready-made reports populated with historical Salesforce data that easily manipulate for sales insights.
In addition after an MS SQL LIKE statement you can include an additional definition of an escape character, which can be placed in front of a wildcard character so that it is treated as a regular character or you could the square brackets as escape characters for your query, for example: –
SELECT*FROM [discounts] WHERE [discount] LIKE’30[%]’
or
SELECT*FROM [discounts] WHERE [discount]
LIKE’30!%’ESCAPE‘!’
or
SELECT*FROM [discounts] WHERE [discount]
LIKE’30!%’ESCAPE‘!’
This will select any discounts that are 30%.
Reference: – http://msdn2.microsoft.com/en-us/library/ms179859.aspx
In Microsoft Access the wildcards and syntax is slightly different but similar
The following describes the wildcard’s that are available in Microsoft Access.
Microsoft Access Query LIKE statement wildcards | ||
Wildcard character | Description | Example |
* | Any string of zero or more characters. | SELECT *FROM [myTable] WHERE [title] LIKE‘*computer*’ This will find all the entries the column ‘title’ from ‘myTable’ contains the word ‘computer’ anywhere in the field. |
? | Any single character. | SELECT*FROM [myTable] WHERE [surname] LIKE‘sm?th’ This will find all five-letter last names that start with ‘sm’ and end with ‘th’ (for example Smith, Smeth, etc). |
[…] | Any single character within the specified range ([a-f]) or set ([abcdef]). | SELECT *FROM [myTable] WHERE [surname] LIKE‘[C-P]arsen’ This will find all the last names ending with arsen and starting with any single character between C and P, for example Carsen, Larsen, Karsen, Paresen, etc. |
[!…] | Any single character not within the specified range ([!a-f]) or set ([!abcdef]). | SELECT *FROM [myTable] WHERE [surname] LIKE‘de[!l]*’ This will get all the last names starting with de and where the following letter is not l, for example it will return Desmond, but not Delimetry. |
# | Any single numeric character. | SELECT *FROM [myTable] WHERE [postcode] LIKE‘eh## #??’ This will get all the postcodes starting with EH followed by two numeric characters a space another numeric character and a further two characters, for example it would return EH54 6LY, EH55 8TZ, etc but not EH4 1NJ. |
In Microsoft Access there is no ESCAPE definition so you must use square brackets, for example: – Macbook pro how to use usb.
SELECT
*FROM [discounts] WHERE [discount] LIKE’30[%]’
This will select any discounts that are 30%.
Query Syntax in Microsoft Access on Linked SQL tables
Now as anyone who has worked with Microsoft Access linked SQL tables will likely know, performing like queries can be complicated… this is because it can sometimes be difficult to determine where a SQL statement/query might be executed (on the SQL Server or my the local Microsoft Access engine).
As a general rule of thumb, if you are running the statement (Microsoft Access query or Access DAO Recordset) directly against the linked table, it will use the SQL Server syntax. For example: –
SELECT
*FROM tblContacts
WHERE Firstname LIKE‘Pa%’–[WILL WORK]
WHERE Firstname LIKE‘Pa%’–[WILL WORK]
![Software Software](https://i.ytimg.com/vi/7M-Vir_sQL4/maxresdefault.jpg)
If however your WHERE clause is in a join query or your query runs some kind of function on some of the data. For example : –
[a bad example at that, yes I would never recommend a statement like this]
SELECT Nz(contactid,–1),*FROM tblContacts
WHERE Firstname LIKE‘Pa%’–[WILL NOT WORK]
SELECT Nz(contactid,–1),*FROM tblContacts
WHERE Firstname LIKE‘Pa%’–[WILL NOT WORK]
This statement would not return the correct results and would have to be modified to the following: –
SELECT
Nz(contactid,–1),*FROM tblContacts
WHERE Firstname LIKE‘Pa*’–[WILL WORK]
WHERE Firstname LIKE‘Pa*’–[WILL WORK]
A more likely scenario would be where you are joining two tables within your Microsoft Access query and you needed to perform a like statement against it. For example: –
SELECT
*FROM tblContacts
LEFTJOIN tblCompanies ON
tblContacts.CompanyID = tblCompanies.CompanyID
WHERE Firstname LIKE‘Pa%’–[WILL NOT WORK]
LEFTJOIN tblCompanies ON
tblContacts.CompanyID = tblCompanies.CompanyID
WHERE Firstname LIKE‘Pa%’–[WILL NOT WORK]
In MS Access this statement would not return the correct results, as the join is performed by MS Access and would have to be modified to the following: –
![Free software like access Free software like access](https://i.ytimg.com/vi/M5lNUNXPYgY/hqdefault.jpg)
SELECT
Software Like Access
*FROM tblContacts
LEFTJOIN tblCompanies ON
tblContacts.CompanyID = tblCompanies.CompanyID
WHERE Firstname LIKE‘Pa*’–[WILL WORK]
LEFTJOIN tblCompanies ON
tblContacts.CompanyID = tblCompanies.CompanyID
WHERE Firstname LIKE‘Pa*’–[WILL WORK]
This also applies to any MS Access Queries based other queries, even if the other Query is a direct Query against a linked SQL table.
Something to remember when generating queries from code
Now you are most likely writing code that will generate your LIKE statements based on a user’s selections. This applies whether you are coding from MS Access or through ASP, ASP.NET, VB, etc… but not if you are running through parameterised objects, for example a .NET 2.0 dataset query.
If you have to code in your SQL you need to remember to change key characters, this means these reserved wildcards as well as the standard single quotes. For example (in VBA): –
SET
myRS = CurrentDB.OpenRecordset( _
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘' & _
Replace(someVariable, '’','”',1,-1,1) & '%’', _
dbOpenDynaset, dbSeeChanges) ‘[WILL NOT WORK]
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘' & _
Replace(someVariable, '’','”',1,-1,1) & '%’', _
dbOpenDynaset, dbSeeChanges) ‘[WILL NOT WORK]
Though this will work in most situations, if 'someVariable' contained any of the wildcard characters, you will experience unexpected results. So you should really do something more like: –
SET
myRS = CurrentDB.OpenRecordset( _
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘' & _
Replace( _
Replace( _
Replace( _
Replace( Replace( _
Replace(someVariable, '’','”',1,-1,1) _
, '%','[%]',1,-1,1), '#','[#]',1,-1,1) _
, '[','[[]',1,-1,1) _
, ']','[]]',1,-1,1) _
, '_','[_]',1,-1,1) & '%’', _
dbOpenDynaset, dbSeeChanges)
‘[WILL WORK IF RAN AGAINST SQL LINKED TABLE]
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘' & _
Replace( _
Replace( _
Replace( _
Replace( Replace( _
Replace(someVariable, '’','”',1,-1,1) _
, '%','[%]',1,-1,1), '#','[#]',1,-1,1) _
, '[','[[]',1,-1,1) _
, ']','[]]',1,-1,1) _
, '_','[_]',1,-1,1) & '%’', _
dbOpenDynaset, dbSeeChanges)
‘[WILL WORK IF RAN AGAINST SQL LINKED TABLE]
Apple file explorer for windows. Or if ran against MS Access table or situation described above: –
SET
myRS = CurrentDB.OpenRecordset( _
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘' & _
Replace( _
Replace( _
Replace( _
Replace( Replace( _
Replace(someVariable, '’','”',1,-1,1) _
, '*','[*]',1,-1,1), '#','[#]',1,-1,1) _
, '[','[[]',1,-1,1) _
, ']','[]]',1,-1,1) _
, '?','[?]',1,-1,1) & '*’', _
dbOpenDynaset, dbSeeChanges)
‘[WILL WORK IF RAN AGAINST ACCESS TABLE/QUERY]
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘' & _
Replace( _
Replace( _
Replace( _
Replace( Replace( _
Replace(someVariable, '’','”',1,-1,1) _
, '*','[*]',1,-1,1), '#','[#]',1,-1,1) _
, '[','[[]',1,-1,1) _
, ']','[]]',1,-1,1) _
, '?','[?]',1,-1,1) & '*’', _
dbOpenDynaset, dbSeeChanges)
‘[WILL WORK IF RAN AGAINST ACCESS TABLE/QUERY]
As with any form of coding it is usually a good idea to extract out common functions into a small library that can be used throughout your applications.
As such if you do build queries based on user input I’d recommend using a standard function to tidy up any users data and prevent possible conflicts or security flaws. The function could look something like (VBA): –
Function
fnTidyLikeQuery(ByVal myString AsObject) AsString
OnErrorGoto ExitHere
‘as it does no harm to escape all characters
‘(SQL or Access specific) this function can
‘take care if both).
‘as it does no harm to escape all characters
‘(SQL or Access specific) this function can
‘take care if both).
If isNull(myString) Then
Goto ExitHere
Else
fnTidyLikeQuery = _
Replace( Replace( _
Replace( Replace( _
Replace( Replace( _
Replace( Replace( _
myString _
, '’','”',1,-1,1), '#','[#]',1,-1,1) _
, '*','[*]',1,-1,1), '[','[[]',1,-1,1) _
, '%','[%]',1,-1,1), '_','[_]',1,-1,1) _
, ']','[]]',1,-1,1), '?','[?]',1,-1,1)
EndIf
Goto ExitHere
Else
fnTidyLikeQuery = _
Replace( Replace( _
Replace( Replace( _
Replace( Replace( _
Replace( Replace( _
myString _
, '’','”',1,-1,1), '#','[#]',1,-1,1) _
, '*','[*]',1,-1,1), '[','[[]',1,-1,1) _
, '%','[%]',1,-1,1), '_','[_]',1,-1,1) _
, ']','[]]',1,-1,1), '?','[?]',1,-1,1)
EndIf
Exit Funtion
ExitHere:
fnTidyLikeQuery = '
EndFunction
ExitHere:
fnTidyLikeQuery = '
EndFunction
Function
fnTidyQueryString(byVal myString asVariant) asString
OnErrorGoto ExitHere
If isNull(myString) Then
Goto ExitHere
Else
fnTidyQueryString= Replace(myString, '’','”',1,-1,1)
EndIf
Goto ExitHere
Else
fnTidyQueryString= Replace(myString, '’','”',1,-1,1)
EndIf
Exit Funtion
ExitHere:
fnTidyQueryString = '
EndFunction
ExitHere:
fnTidyQueryString = '
EndFunction
A sample query based on the above functions would look something like: –
SET
myRS = CurrentDB.OpenRecordset( _
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘*' & _
fnTidyLikeQuery(someVariable) & '*’ AND Surname = ‘' & _
fnTidyQueryString(someOtherVariable) & '’', _
dbOpenDynaset, dbSeeChanges)
‘[WILL WORK IF RAN AGAINST ACCESS TABLE/QUERY (uses * as wildcard)]
'SELECT * FROM tblContacts WHERE FirstName LIKE ‘*' & _
fnTidyLikeQuery(someVariable) & '*’ AND Surname = ‘' & _
fnTidyQueryString(someOtherVariable) & '’', _
dbOpenDynaset, dbSeeChanges)
‘[WILL WORK IF RAN AGAINST ACCESS TABLE/QUERY (uses * as wildcard)]
Some more samples of LIKE statements
SQL Clause | Access Equivalent | Result |
Like ‘%’ | Like ‘*’ | All except blanks |
Like ‘A%’ | Like ‘A*’ | Starting with ‘A’ |
Like ‘%A%’ | Like ‘*A*’ | ‘A’ somewhere in the field |
Like ‘[A,B,D]’ or Like ‘[ABD]’ | Like ‘[A,B,D]’ or Like ‘[ABD]’ | One character an ‘A’ or ‘B’ or ‘D’ |
Like ‘[A-C]%’ | Like ‘[A-C]*’ | One character ‘A’ through ‘C’ as the first character |
Like ‘[A-C][A-H]%’ | Like ‘[A-C][A-H]*’ | ‘A’ through ‘C’ as the 1st character and ‘A’ through ‘H’ as the 2nd character |
Like ‘SM_TH’ | Like ‘SM?TH’ | Starting with ‘Sm’, ending with ‘th’, and anything for the 3rd character |
Like ‘[0-9]%’ | Like ‘[0-9]*’ or Like ‘#*’ | Digit for the 1st character |
Like ‘[^a-c]’ | Like ‘[!a-c]’ | Not in a range of letters ‘a’ through to ‘c’ |
Like ‘[^a-c]%’ | Like ‘[!a-c]*’ | Not start with a range of letters |
Like ‘[^0-9]%’ | Like ‘[!0-9]*’ | Not start with a number |
Download Free KMFMS Stuff--Email @KMFMS.COM What's So Bad About Microsoft?--Microsoft Alternatives--KMFMS Bookstore Forums--KMFMS Links--Contact Us About KMFMS--KMFMS FAQ--What's New |
|
Where to start?Are you aWindows user and want to gradually wean yourself off of a dependenceon Microsoft? Download, make a copy from a friend (yes, it'slegal), or order TheOpenCDwhich is a fantastic CD packed with a ton of great opensource software that will give you a taste on Windows of what'savailable on open source operating systems like Linux.You will be getting a fully featured, free office suite, a powerfulphoto editor, a cutting edge web browser, and so much more.Start usingthese very high quality, non-Microsoft applications today onWindows and you can gradually decrease your dependence on Microsoftat your own pace. Every Microsoft alternative you use helps tokeep choice and innovation in the software industry alive and itmoves you one step closer to being free fromeverything that is wrong with Microsoft. |
If you're sick of the unreliability, the bloat, the insecurity, andthe perpetual upgrading associated with Microsoft products you'll behappy to know that there are some excellent alternatives out there.The list below is meant as an introduction to Microsoft alternativesand as such it is by no means comprehensive.
The KMFMS recommendedproducts are products that we here at KMFMShave personally used with great satisfaction. The recommended list doesnot necessarilyreflect the value of other alternatives, it is simply a list of productsthat we can personally vouch for. Just because a product isn't recommendedby KMFMS doesn't mean it isn't a great product - it may just mean that wehaven't had a chance to extensively use it yet. You may also beinterested in what other users have to recommend in the'alternatives' section ofour discussion forums.
Legal disclaimer: all product names below are trademarks of theirrespective owners.
Category | Microsoft Product(s) | Alternative(s) | KMFMS Recommends |
---|---|---|---|
Desktop Operating System | Windows | Linux,Mac OS X,and many, many more | Fedora (Linux),Mac OS X |
Web Browser | Internet Explorer | FirefoxNetscape,Opera,Lynx,ELinks,iCab, andmany, many more | Firefox |
Office Suite, Word Processor, and Spreadsheet | Microsoft Office, Word, and Excel | OpenOffice.org,StarOffice,Corel Office,Lotus Smart Suite,Appleworks,KOffice,GNOME Office,WaveMaker | OpenOffice.org |
Email Client | Outlook | Thunderbird,Eudora,Pine,and many, many more | Thunderbird* |
Web Based Email | Hotmail | Gmail,Yahoo! Mail,Hushmail,KMFMS Email | Yahoo! Mail |
Server Operating System | Windows | BSD,Linux,Mac OS X,Solaris,and many, many more | RHEL,OpenBSD |
Web Server | IIS, Frontpage | Apache,Tomcat,lighttpd,Zeus,Boa,thttpd,Enhydra,and many, many more | Apache,Tomcat,lighttpd |
Game Console | Xbox | Sony PlayStation,Nintendo | Sony PlayStation* |
Internet Service Provider (ISP) | MSN | AOL,Earthlink, | Within the USA:Earthlink for dial-up, |
Email Server | Exchange | Sendmail,Qmail,Exim,Steltor's Outlook Connector | Evaluation not complete |
Operating Systems
Did you realize that older computers which can't satisfactorily runthe latest version of Windows can be given a second lease on life byinstalling an operating system that better manages resources? Are youa home or businessuser who is tired of the instability of Windows or who could use theperformance increase that a well written OS would offer? You may be interestedto know that there is an OS out there calledLinux which offers much better performancethan Windows and without the overhead. Linux will breathe new life intohardware that you thought was obsolete and it will unleash the real powerin newer hardware. Even Microsoftcan't help but give Linux a glowing review as you can read in theirinternal memo that wasleaked in October 1998. Oh yeah - Linux is free too.
Another excellent option to consider if you are buying a new desktop or laptop isMac OS X. OS Xcombines the legendary ease of use and stylishness of Apple'sMacintosh operating system with the rock solid stability and power ofBSD. It easily outflanks Windows in ease of use, style, stability,security, and power. Mac OS X comes included with new Macs.
Are you an administrator who uses Windows as a server? If so, you should be awarethat the alternatives are more reliable, much more secure, andmuch less expensive.Linux makes an excellent server withits stability and excellent performance. It's also easy to install andeasy to administer if you get a distribution such asRed Hat's.If security is a concern (as it should be) you may also be interested inthe OpenBSD operating systemwhich is perhaps the most secure operating system in the world.It makes a great server and it completely blows away Windows (as well as mostother operating systems) when it comes to security.
Linux and BSD (including Mac OS X) are our favorites here at KMFMS because they have proven to be excellentsolutions for various projects. There are, however, several other non-Microsoft solutionsthat we haven't tried so those of you wishing to get a broad overview of what's out therecheck out the review ofoperating systems at tunes.org,the KMFMS forum on alternatives, orYahoo's listof operating systems (by the way - Yahoo, one of most heavily used sites on the internet,also runs on BSD).
Editor's note: the following information on the Mac OS was accuratewhen it was first published in August 1999. Some information,such as current version numbers, has since changed.
A KMFMS Reader writes: For those of who want a professional-level OS, but don't want to spend all your time learning it, MacOS X Server is good. (It's ideal for a small network.) OS X Server is only at version 1.0, but is quite comparable to Linux. With your help, it can grow into something that'll make Microsoft shake in their boots. It sits upon the Mach microkernel and BSD.
Web Browsers
The best choice in web browsers for nearly all people isFirefox(although, Safari is also agood choice for Mac users). If you are on Windows you should use itbecause it has nowhere near the number of security exploits asInternet Explorer, it is packed with a lot of powerful features whileretaining a very clean feel, it is quite stable, it won't bring downyour operating system if it does happen to crash because it hasn'tbeen forcefully shoved into the OS like Internet Explorer, andit properly supports Java (unlike IE). If you're not using Windows (goodfor you) then you're probably already using something else becauseMicrosoft can't strong-arm you into using IE. Although Microsoft doeshave a version of IE for the Mac, they have no loyalty and you woulddo well to not rely on it being there going forward since they havealready pulled the rug out from under users on other operating systems.Microsoft initially released a version of IE for Solaris so that theycould claim that IE was 'cross platform', but it didn't take them verylong after IE gained a majority market share to drop the Solarisversion entirely.
There are a ton of other browsers out there, some of which may be better than Firefoxfor certain situations. Several people considerOpera the ultimate lightweight browserand its speed and small size are very impressive if you're into that sort of thing.Also, Lynx andELinks are both text only browserswhich can be extremely useful for remote administration, but chancesare if you have a use for them you probably already knew what theywere. Finally, there's a whole slew ofbrowsers at Yahoothat fit into other niche markets.
Office Suites, Word Processors, and Spreadsheets
Why would anybody spend several hundred dollars on Microsoft Officewhen there are high quality, free equivalents available? Saveyourself some money by trying the free, high-quality, open sourceOpenOffice.org today.Not only will you save yourself a bundle now, but you'll save yourselfeven more on upgrades in the future as you will no longer be lockedinto Microsoft's viscous cycle of forcing MS Office upgrades by changingthe 'doc' and 'xls' file formats (OpenOffice.org does a good job of keeping up withthe newer MS Office file formats).
OpenOffice.org providesalternatives to many of the applications which make up the MicrosoftOffice suite including Microsoft Word, Microsoft Excel, MicrosoftPowerPoint, Microsoft Access, and more.
If you work in a (physical) officethat uses office suite softwareand you are worried about potential compatibility issues, try this: limityour MS Office installation to a single machine and install OpenOffice.orgeverywhere else. For internal documents and documents which you print(or otherwise distribute in hardcopy form) you can standardize on theOpenOffice.org format (which is an open standard and not proprietary). For the few documents that you want toelectronically distribute outside your company, you can use OpenOffice.orgto write the document in MS Office format and then use your singleinstallation of MS Office to touch up anything that may not haveconverted perfectly. For incoming documents in MS Office format,OpenOffice.org will read most without a problem. If there ever are anyproblems, simply use your single installation of MS Office. Thissimple strategy could save even a small office several thousanddollars.
Email Client
There's a very goodreason why Outlook has come to be nicknamed LookOut by seasoned users.Microsoft Outlook has a notorious security history with many a virusowing its ability to spread to Outlook's 'features'.Help slow the spread of email viruses and support software diversity byusing another email program, such as the free and excellentThunderbird.
Perhaps you use Outlook for more than just email and an address book. If you use Outlook for scheduling as well, you may also want to consider using Yahoo! Calendar in conjunction with Thunderbird or a web based email solution. This can provide quite a bit more convenience and versatility than using Outlook by itself.
Do you want to further explore combining alternatives to replace how you use Outlook? If so:
- Post your own question in the KMFMS forum on alternatives.
Web Based Email
When selecting a web based email service, you absolutely do not want touse Hotmail. Forget for a moment the large number of security holesthat have been uncovered in the Hotmail service (including one thatallowed anybody to read the email from any Hotmail account without using a password). An even bigger problem is that by using Hotmailyou are very likely to become victim of Microsoft's typical lock-intactics at some point in the not-too-distant future. MSN has lockedout non Microsoft browsers before, forcing people to use InternetExplorer, so what happens if Hotmail starts doing this too? Don't thinkfor a second that it doesn't matter because you use IE anyway - whathappens when you're traveling and you stop to check your email viathe web? What if you're visiting a friend who uses Firefox or you'reat a web kiosk that uses Linux underneath for security purposes? Youwon't be able to use IE, which means you won't be able to use servicesthat require IE.
Free Software Like Access
Yahoo! Mail is an excellentalternative to Hotmail. It features exceptional functionality whichmany people consider superior to Hotmail (having never used Hotmailourselves, we are relying on third party comparisons). Mostimportantly, it is not produced by a company that has a vestedinterest in forcing users to use a particular browser. In fact,Yahoo! has an excellent track record of making their content availableto the widest possible audience. Yahoo! Mail is a good way to protectyourself against the software lock-in and incompatibility that yourisk by using Hotmail.
Web Servers
If you're running a web server it's tough to beatApache.Over half the web servers on the internet are running Apache(Source: Netcraft), it hasthe largest number of developers developing for it(Source: Netcraft), and it offers far more performancethan most websites could ever dream of needing. It's also open source and freein all senses of the word which means it is more secure (because it is subject topeer review and doesn't rely on security through obscurity), it rapidly incorporatesnew standards, it is feature rich while at the same time capable of being entirelystripped down for maximum performance,it is well modularized for easy expandability, and it is guaranteed tohave long term viability because it is not being used to drive a perpetual upgradecycle. Add the PHP module onto Apachewhich makes dynamic content a lot easier to generate than with the CGI of daysgone by, and you have a first class web server for no money down and no payments ever.For an even more elegant and highly scalable dynamic content system, check outthe Tomcat servlet containerfor serving JSP and servlet content from Apache or other servers.
If you are fortunate to hit the performance limitations of the Apacheweb server, lighttpd is acompelling upgrade option. It combines the incredible scalability ofnext generation web servers with a high degree of customizability andthe ability to serve dynamic content in many of the same ways asApache. Like Apache, it too is free and open source, so youautomatically get the benefits of peer review and long term viability.
Game Consoles
The PlayStation platform has a much larger library of games availablethan the Xbox. Furthermore, current incarnation of the PlayStationare still capable of playing games made for older PlayStations, whichexpands the available library even more given that the PSOne was oneof the most successful systems in history.
Please note: this recommendation is under consideration for possible reconsideration. You may want to consider other alternatives as well, such as Nintendo.
Internet Service Providers (ISPs)
You should definitely avoid using MSN because it will force you intousing Microsoft's software. As of this writing (November, 2001) youmust use Microsoft Outlook or Microsoft Hotmail to retrieve your MSNmail and the MSN website portal recently made headlines by blockingmost users who weren't using Internet Explorer (earning Microsoft amuch deserved rebuke from Tim Berners-Lee, the creator of the WorldWide Web). You would be much better off with a non-Microsoft ISP andthere is practically no reason to go with Microsoft in this case asISPs are all very standardized and Microsoft doesn't wield monopolypower in that industry (yet).
Your physical location will have a great impact on your choices ofISPs. 'The List' is a verycomprehensive list of ISPs which should help you find an ISPregardless of your location. If you are in the United States, youmight want to considerEarthlink for dial-up access orSpeakeasy for broadbandaccess. Earthlink has a very large number of dial-up numbersthroughout the US, which is good if you travel at all and have alaptop, and it is very easy to set up Linux to use an Earthlinkaccount. Speakeasy is an exceptionally good DSL company (absolutelyworlds apart from the Baby Bells, if you've had any experiences withthem) with a surprisingly clueful technical support staff whichactually supports Speakeasy on Linux.
Email Servers
The KMFMS evaluation of email servers is not complete enough to make arecommendation because expectations vary widely on what an emailserver is meant to do. Here at KMFMS we actually have considerableexperience with email servers within the context of sending andreceiving email. The problem is that enterprises might also want theemail server to handle ancillary tasks, such as calendaring, and weonly have experience using email servers for email.If you want a best of breed email server that outshines Exchangeon what email servers are supposed to do (transfer email) look nofurther than the staples of the internet,Sendmail andQmail.For email servers that handle more than email,we will reserve recommendations for a later date. For now, we willpass along the following pitch from arepresentative at Steltor who has informed us thatSteltor's Outlook Connectoris a 'piece of client-side middleware (MAPIservice providers) that allows you to replace Exchange with astandards-based offering consisting of a mail server offered bySteltor partners such as Sendmail, directory servers (offered bySteltor partners) and a best-of-breed calendar server offered bySteltor.'
A KMFMS reader wrote in to highly recommendExim writing that he stronglyprefers it over Sendmail and that it has easy to use spamfiltering.
Database Software Like Microsoft Access
Another KMFMS reader also wrote in to tell us aboutEMWAC IMS. He said that ifyou are stuck using Windows, EMWAC IMS is an excellent, free choicefor a mail server.He used it at his own ISP which handled over 100,000 email messages aday on a Pentium 100 and he claims that it is very well supportedin the community.
Free Database Software Like Access
Do you want to further explore Exchange alternatives? If so:
- Post your own question in the KMFMS forum on alternatives.