10 reasons to turn your Access applications into Web-based applications

By Susan Sales Harkins and Drew Wutka
An Access database often outgrows its original purpose. When that happens, you face applying band-aid technology or upgrading to a more powerful database system, such as SQL Server Express or even SQL Server. But before you toss Access out the window and start signing purchase orders for consultants, developers, licensing, and new hardware, consider one more option—turning your Access application into a Web-based application. Let’s look at some reasons why this might make sense.
Shameless disclaimer: If you truly need a more powerful database system and can afford its trappings, spend and grow!

Client versus server
A server-side database, such as MySQL, SQL Server, and Oracle, evaluates requests on the server side (sent in the form of a SQL statement) and then returns data to the client. Jet, on the other hand, lets the client do all the work. Jet is the database engine behind Access. Even if the database (.mdb) is on a network server, the client still does all the work. The server simply responds to client file requests.
This arrangement retrieves more then just the data across the network. As a result, indexes and unused data clog the network and slow things down. An alternative is to place the Access database on your Web server’s local drive and then build the interface on the Web server. Doing so creates an ad hoc server-side database that handles transactions on the server (using your code). Requests from the client are in Hyper Text Transfer Protocol (HTTP) format instead of SQL.
Recommendation: Put the Access database (the .mdb file) in a folder that isn’t shared. That way, users won’t have direct access to the database. Their only access will be via the Web server. Your code will serve as the layer that allows users to interact with the actual data.
Continue reading

Advertisements

10+ tips for getting the best performance out of your SQL Server data types

By Susan Sales Harkins
Data integrity and performance are the driving force behind almost every decision you make during the design and development process. Defining appropriate data types is one of the easiest ways to let SQL Server help you help yourself.
Size matters
Always use the smallest data size that will accommodate the largest possible value. If a column is going to store values between 1 and 5, use tinyint instead of int. This rule also applies to character columns. The smaller the data size, the less there is to read, so performance, over all, benefits. In addition, smaller size reduces network traffic. With newer technology, this tip seems less relevant, but don’t dismiss it out of hand. You’ll won’t regret being efficient from the get-go.
Continue reading

Licensing Terminal Server in Windows Server 2003 R2

From :http://www.microsoft.com/windowsserver2003

Terminal Services functionality in Windows Server 2003 R2 lets you remotely execute applications on a Windows-based server from a wide range of devices over virtually any type of network connection. A server running Terminal Services can be referred to as a Terminal Server (TS).

Terminal Server Licensing Requirements
Windows Server License

The Windows Server 2003 R2 licensing model requires a server license for each copy of the server software installed. Terminal Services functionality is included in the Windows Server license.
Windows Server Client Access License

In addition to a server license, a Windows Server Client Access License (CAL) is required. If you wish to conduct a Windows session, an incremental Terminal Server Client Access License (TS CAL) is required as well. A Windows session is defined as a session during which the server software hosts a graphical user interface on a device. For Windows sessions, a TS CAL is required for each user or device.
Device-based versus User-based Terminal Server CALs
Continue reading

Installation Citrix MetaFrame Presentation Server 4.0

From : http://azhardino.co.nr/

  • Insert the Presentation Server 4.0 Server CD and click the Product Installation and updates button.
  • Click the Install MetaFrame Presentation Server 4.0 and its components button to launch the setup program
  • Scroll to the bottom of the license agreement and click the I accept the license agreement radio button and click Next to continue. Continue reading

Installation Checklist for Citrix® MetaFrame® Presentation Server, Version 4.0

From : http://azhardino.co.nr/

Citrix® MetaFrame® Presentation Server is the easiest way to manage enterprise applications from a central location and access them from anywhere. The foundation of the MetaFrame Access Suite, Citrix MetaFrame Presentation Server is the world’s most widely deployed presentation server for centrally managing heterogeneous applications and delivering their functionality as a service to workers, wherever they may be.

This checklist includes only the basic requirements for installing and running MetaFrame Presentation Server for Windows and its components. For important information to consider before installing Citrix products, please review the readme files and administrator guides for components you plan to install. The readme files and administrator guides are available through the Document Center. Continue reading

Setting Up Windows Apache HTTP Server – Testing DHTML Menu

Setting up a web server is easier than you think and allows you to experiment with the menu in a testing environment. The operating system you are running will determine which web server you will use. Those using Windows XP Professional will have access to Microsoft’s Internet Information Services (IIS), for all other Windows systems (including XP Home Edition) we recommend using Apache 1.3 HTTP Server. Continue reading

Microsoft Excel tips

From : http://www.computerhope.com

Auto sum shortcut key

Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .

Create hyper links in Excel

Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing “CTRL + K”.

Close all open files at once Continue reading