Page Crazy

During my last development, I had a little bit of information about working with the free base of the MSSQL Server 2000 MSDE. This information, I would like to share with you, it can not remain without attention and someone to come in handy. For First you need to download a free version of this very MSSQL server, you can do with my site. or type in a search engine query: 'Download MSDE 2000', 'download MSDE', etc. The installation of a free server, you must perform parameters. Run the setup. Exe c parameters shown below.

Here are the options available, but personally, I run with only one sapwd = 'mssql'. Options sapwd = 'mssql', securitymode = SQL, DISABLENETWORKPROTOCOLS = 0 With these settings, you set the login and password for the SQL system Administrator mssql. Installing the server is almost blind. After installing the server you need to restart the system. After a successful installation in the system tray near the clock should appear running SQL Server. If the server does not start automatically, you can start it manually by right-clicking the icon for the server. Now that the server is installed we can create the database, but it's extremely uncomfortable without using a visual manager, and there is no such a free version of MSDE. Personally, I use free download manager 'DbMgr2k'.

If it does not suit you, you can find another. After installing the manager you will have the opportunity to create databases and manage them using the visual editor. Limitations of MSDE 2000, 1. The first and most noticeable limitation, in my opinion, is the number of simultaneous connections to the database, no more than two * 2. Second, it limit on the size of your database. Base size should not exceed 2 GB. ** * – If you want to install MSDE 2005, then there is no limit to the number of simultaneous connections ** – The size of the database in MSDE 2005 is 4 GB.

Windows ME was an attempt to create a hybrid of WinNT and "Nine." But nothing good came of it. System was unstable, and something revolutionary to give users also failed. But the really good products, Microsoft has started producing since 2000. Windows 2000 does not differ revolutionary interface. Outwardly, it looked like a Windows ME, but that's all the similarities end. Win2k was built on the NT kernel and used it to maximum. It was written completely new boot that will get rid of legacy MS-Dos. But support for the command line was maintained and was implemented as a virtual machine NTVDM (NT Virtual Dos Machine).

In Windows 2000, seriously raised the level of security through HAL (Hardware Abstract Layer). From now on, the program was denied direct access to the disk and the hardware at all, and it secured the users from a large number of viruses written for Windows 9x and MS-Dos (was defeated by the infamous "Chernobyl"). Windows 2000 was originally designed as a network operating system, and its level of security enabled by Microsoft to extend the sphere of influence. Began to appear a large number of ATM machines, terminals, payment and other embedded devices running Win2k. The system is constantly updated with the fourth service pack (SP4) is considered one of the most universal and secure systems available today. With the success of Win2k already in 2001 there Windows XP. Combined an XP security of Windows 2000, but with a more attractive graphical user interface and expanded set of standard applications.

Almost all programs have a function of viewing history. In some History is preserved in part, that not all events are recorded. Very useful opportunity to celebrate the history of events such as repairs, MOT, breakdown and so on. Naturally, the program should search tools equipment on certain events. Otherwise, the meaning of the history of a few lost. Most programs offer only a view of history a particular device.

All three of the above criteria are closely related to implementation of the reporting system. The absence of convenient data retrieval tool can negate the benefits of a program. Reports – this is your primary tool. It should be simple, fast and multifunctional. Typically, the programs offered a range of accounting standard reports. In some programs, you can manually edit the printed report forms that might be useful. It should be noted attention to the ability to export the report data – not always a means of data sampling can meet your needs and may require post-processing of data. The basis of any accounting system – a database.

Of its choice depends on security, performance, multi-user ability and ease of administration. Before you decide on the choice of accounting system, find out whether it is possible to back up databases, how long spent on its restoration in case of failure, how to migrate the database to another computer, can there be a multiplayer mode. Here is an example of the practice. Was chosen as the accounting system in an organization where there is many branches and taking into account the dozens of people involved.

Application for permit to empower contact on site and enjoy all its benefits. Catch the OpenID program designed to download music and videos on the site. She also sends alerts when a new letter from a friend. It allows you to download files from any pages of Contact: walls, partitions, video and audio. The program works this way: next to the audio and video files appears "Download", download speed is 500 kbps. Lovi vkontakte program saves time and money.

No more long search over the Internet, music and video. All that is required, we can find on the site. After all, OpenID has an extensive collection of audio and video content. Applications for Touch VKSaver allows downloading of music, contact, audio and video files – quickly and conveniently. The program is free, when the plugin is installed at the site below each video and audio file appears in the button "Download". The program 'Vkontakte DJ' is unique in terms of features and is designed specifically for the contact.

It is also designed to download music files to OpenID, but shall not download individual songs and entire albums of music. It finds for you all the songs from an album artist, you need no additional software for the contact, because not only Vkontakte DJ plays downloaded music, but also makes playlists. This will allow you to become a real DJ, make your own playlists and shuffle at a party different compositions. You can stream songs in order, randomly or looped. Is a function of displaying charts – more than two dozen Russian and world rankings show the most popular songs that can be downloaded with one click of contact. Programs VKPicture Contact different intuitive and simple interface designed to load on a wall or other groups of their own images, pictures and graffiti. Done everything two clicks – select another and then Pictures. Do not forget to click only on the site OpenID 'to publish on the wall. " The program allows VKPaint draw on the wall OpenID, and download a special picture for a contact. Painted graffiti you can edit, You can move the image on the wall completely. VKPaint supports two modes: download pictures directly, as well as "pererisovalku" graffiti. The program is used to spin ArxVkontakteGroup VKontakte groups. It allows you to automatically send an invitation to the group. In her many options. Important! If there is a lot of "spam", the group is removed. And so we talked about the most popular free programs. Choose under their specific purpose and use for pleasure.

Between the lines Sub and End Sub type operators vba, which should be included in the macro. To make the code easier to read, for each operator should indent. To do this at the beginning of the line, press the ‘Tab’. (But do not do this for strings Sub and End Sub). It is convenient that the editor saves the indentation for subsequent lines, so the need to manually indent only the first line.

Every time when you press the button to start a new line, the editor checks the input string and performs three steps: 1. Each word in a string formatted color: default vba keywords are highlighted in blue, Comments – green, red bugs, and any other text is black. 2. Keywords vba converted into the appropriate register. For example, if you enter the end sub, then after pressing ‘Enter’ editor converts this entry End Sub. 3.

Editor checks the line for syntax errors. These errors are misspelled, entered incorrectly functions, etc. Editor notifies such error. It either displays a dialog box that shows error, or simply does not translate the words in a register does not change the text color. If you enter all keywords vba only lowercase letters, it is possible to detect errors. To do this, after the transition to a new line look at the previous – whether on her key words that the editor did not recognize (ie keywords that are left in lowercase). Perform a simple example: 1. Enter the sub Privet_Mir and press ‘Enter’. 2. Press ‘Tab’ and enter the msgbox ‘Hello, world vba!’ and press ‘Enter’. From any application of Office macro can be run in several ways, but below are two ways: 1. In the module, place the cursor anywhere in the macro, and then click Run => Run Sub / UserForm (Run> Run subroutine / custom form), or press F5. 2. In Office command Tools => Macro => Macros (or press the key combination ‘ALT + F8’), a dialog box “macro”. If necessary, Use the drop-down “Macros” to select the document that contains the macro and click Run. If you run a macro that we created earlier, then you will see a dialog box which will contain the text “Hello world vba Click ok to close this window.