Category Archives: Access

2toria Access Downloadable content Visual Basic For Applications (VBA)

A very basic chat program in MS-Access

I‘ve just come across this little plaything I developed a year or so ago and thought I’d share it with you guys.  It’s a very basic chat program that you can use with your colleagues if you all have access to a shared network.  If you all open the MDB file you can chat with each other.

The code uses your network log-in name to define who you are and saves the ‘chat’ to a table within the database.  I’ve left everything open so you can look at the code etc, although there isn’t a great deal really – I’m actually surprised in hindsight just how simple it really is!

You will need to clear ‘tblConversation’ each time you’re done with the application, otherwise it will show the whole previous conversation.

I might someday develop this further, but for now as I said just thought I’d share with you.  If you can think of any uses for it, or if you want to have a go at amending it yourself please do and let me know how you get on.

Access Visual Basic For Applications (VBA)

DAO vs ADO?

I’ve been programming with Access for a good ten years or so now and I’ve always used DAO when manipulating tables through VBA.  I seem to recall a while ago (and this could well be years) somebody talking about how ADO was the way to go and that DAO would soon become extinct and, at the time I thought I should learn it.  I never did.

Anyway, for some reason today the thought popped up in my mind as I was working on a project – should I replace my DAO code with ADO and start using it from now on?  I thought I’d ask Mr Internet what he thought.

Turns out that the majority of Access experts out there still recommend using DAO if you’re only working with mdb files, as DAO was designed for Jet databases.  As the bulk of my work is still with mdb’s that gives me no big reason to change over, unless I start querying SQL server or other ODBC-compliant databases, which I doubt I’ll be doing any time soon.

Thank you Mr Internet!!  I might still learn ADO at some point, but for the work I currently do, DAO it is…