News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Friday, July 29, 2005 preview

A very cool example of AJAX (or whatever it is called now) technology at Do not forget to click on "Start"

Thursday, July 28, 2005

One more utility to get database password

This one it freeware, could be useful if you forget your password. Here a procedure to do the same from Michael Kaplan.

Why I don't like tabs in IE

Recently I have downloaded a new MSN toolbar with Tabbed Browsing. Now you can switch between tabs using ctrl+Tab, which is ok, when you get used it and switch only between IE windows. But if I try to switch between IE and other windows application - I get confused. Perhaps better idea to allow switch IE tabs using Alt-Tab - this could solve this confusion.

Shareware Starter Kit

A sample Shareware application can be used as a template of .Net application

Tuesday, July 26, 2005

File Signature table

Quite useful page which list binary signatures of different file types. Could be used when you need to check if file extension match file type, of when you don't know what file type is it.

Sunday, July 24, 2005

How to perform a daily backups

As i promised - Backup solution now available at Point Limited site. Perhaps there are better solutions, but i use this for a long time, and it works really fine.

Monday, July 18, 2005

One more try to document MDB file

Perhaps someone can find it interesting

Dr. Watson & Alex at Baker str. 221b

Thursday, July 14, 2005

On London Eye

Tuesday, July 12, 2005

Steve Ballmer interview by Scoblizer

Worth to watch staff

Steve Jobs calls family of teenager killed for IPod

Back to Steve Jobs speech - look at Ed bott post

Monday, July 11, 2005

How to split database into BE and FE

The procedure actually is quite simple. Say you have a database MyCoolDB.mdb. First you create a new database MyCoolDBData.mdb, then you open it and import all table from MyCoolDB.mdb there. Do not forget to check "Import relationships" in Import dialog. Check that all tables are there and close it. Now open your MyCoolDB.mdb, delete all tables and run menu FileGet External DataLink tables. Select all tables from MyCoolDBData.mdb and click OK. Try to run your MyCoolDB.mdb to make sure everything is working as expected. Last thing is to add a routine to relink tables at startup, you can use one from Solutions.mdb sample database or use Dav Ashish code. Now you can move BE (MyCoolDBData.mdb) to a shared drive and relink tables.
Also you can look at article Split your MDB file into data and application by Allen Browne.

Split or not to split

Today I had a discussion in Microsoft Public Newsgroups about "how to backup a database where tables and forms and everything in one file?" Good answer is "spit your database into Backend (BE, database with tables) and Frontend (FE - database with the rest)". I know the only one reason to have everything in one file - when you develop database in early stage and you are the only user of it. In this case you can make backup any time you like, no problem. But once you gave it to users to enter data - you have to split it. Then I would recommend making a backup every day, at first start, when nobody logged into. In my routine I first make a copy of BE to specified folder, keeping 3 last backup and deleting older (by default) and then I make a compact of BE. I am planning to publish my routine soon, hope it will help somebody also.
Some useful links on splitting databases you can also find at Jeff Conrad site:
Database Splitting Information

Sunday, July 10, 2005

Autoexotica 2005

Few photos form Autoexotica

Friday, July 08, 2005

Carta Alfa Romeo

Счастливые итальянские любители Alfa Romeo (а также Fiat и Lancia) теперь могут себе заказать кредитную карту с символикой марки

Wednesday, July 06, 2005

Function to set Windows Clipboard text

Function is actually published at MAUG Tips section.
First I tried to publish it here, but all code indents are gone, so code become unreadable.

CountryCombo control beta

This control I made long ago for a VB application, recently I decided that to make a it public available, perhaps people find it useful. Now first beta is available at Point Limited site. Any comments and suggestions are welcome!

Tuesday, July 05, 2005

Bloglet does not understand Blogger?

Ed Bott have pointed to an interesting service - Bloglet. I tried to setup it, but reading my RSS (from FeedBurner) it found error there wrong date. Perhaps a FeedBurner problem... Anyway - error message was not helpful enough "ERROR: String was not recognized as a valid DateTime"

Commission Junction does not like Russia?

Once I tried to submit a CJ Marketplace Publisher application at Commission Junction - but there is no Russia in their country list. Why? Some exUSSR countries listed, some are not. For example Latvia, Uzbekistan -there, but no Ukraine and Lithuania. Perhaps they exclude countries of "bad" customers?

Monday, July 04, 2005

Query from Access update

New feature added to Query from Access - now you can choose where you want to import data - into a new sheet or active sheet. Current build is

you subscribe:rss became Attensa

I have used you subscribe:rss several months, can not say that I am 100% happy with it, but interesting to use something new. Now it is called attensa. At first glance works more stable, few new features. This post I publish using it. Will it work? Crossing fingers...
Does not work... Guys from Attensa have to work more on it. At least to build a help file which explains how to publish