AccessBlog.net

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

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Saturday, December 31, 2005

SQL Scripter

SQL Scripter - very useful and free program to script SQL Server data into T-SQL format

Thursday, December 22, 2005

Ken Getz: MS Word and Visual Studio 2005

Ken Getz, well known author of best Access books, wrote a new article at MSDN: Understanding the Word Object Model from a Visual Studio 2005 Developer's Perspective

Wednesday, December 21, 2005

Web Services and Access

Web Services are "native" for any .Net application, but not for Access. This article "Consume Web Service from Access" at Dabase Journal goes through entire process.

Tuesday, December 20, 2005

Do Access Junkie in the house at Christmas time?

Jeff Conrad, Access Junkie and MVP, has published a Top 10 ways to tell you have an Access Junkie in the house at Christmas time

Wednesday, December 14, 2005

OLE Field Extractor

Long awaiting library from MVP Stephen Lebans – ExtractInventoryOLE. This version saves the entire contents of a table containing OLE Objects to disk. Does NOT require the original application that served as the OLE server to insert the object. Supports all MS Office documents, PDF, All images inserted by MS Photo Editor, MS Paint, and Paint Shop Pro.

Sunday, December 11, 2005

Where your visitor came from?

Mark Berck published an article describing this: How to retrieve your visitor's country information

Concurrent Remote Desktop Sessions

There is an article in Sig9.com blog Concurrent Remote Desktop Sessions in Windows XP SP2, which could be useful for developers also. Setup for patch is located at Sala Source.

UDF string functions

A big list of T-SQL string functions by Igor Nikiforov, which makes life of T-SQL programmer much easy (via Pinnacle Publishing).

Wednesday, December 07, 2005

Image processing libraries from VintaSoft

VintaSoft offers number of libraries and controls (Com and .Net) to control scanner, camera or any other TWAIN device from your program, and one more to create, update and view multipage TIFF files. According to VintaSoft – ActiveX controls are tested in Access 2000.

Tuesday, December 06, 2005

Be careful using CurrentDB

As we all know CurrentDB returns a reference to currently opened database, so we can open recordsets just using CurrentDB.OpenRecordset(). In most cases this works fine, but in complex and recursive procedures you can easy reach a limit of open references (or instances) CurrentDB can hold. Code below shows this:
Sub TestCurrentDB()
Dim i As Long, rst(1000) As DAO.Recordset
For i = 1 To 1000
Set rst(i) = CurrentDb.OpenRecordset( _
"Select * from Table1", dbOpenDynaset)
rst(i).MoveFirst
Next i
End Sub



Code will stop at i=250 with error message 3048:
“Can’t open any more databases”
The workaround – is to declare a public variable dbs as dao.database, set it to CurrentDB at program startup and then use it instead of CurrentDB.

Friday, December 02, 2005

Instant answers via Messenger

Try to add encarta@conversagent.com as a contact to your MSN Messenger – and you can ask it whatever questions you have. My first try:
Alex Dybenko says:
What is Access?
Encarta® Instant Answers says:
Access (computer): Access (computer), in relation to computers, to obtain entry to, or to locate, read into memory, and make ready for, some operation. Access is used....

Thursday, December 01, 2005

What Access version are you using?

Please take a survey! I just thought to make the same survey for Access MVPs, interesting what versions they are using. But ok, let us see first what other developers and users have in hands. Will publish a link to results here.