Tags: access, application, checkbook, database, doesntrequire, installed, microsoft, mysql, oracle, register, self-contained, sql, user

Checkbook Register in Access

On Database » Microsoft Access

4,697 words with 3 Comments; publish: Wed, 04 Jun 2008 01:46:00 GMT; (25093.99, « »)

The only way to have a self-contained Access application that doesn't

require that the user already have Access installed is to use the

royalty-free Access run-time. The only version Microsoft currently sells is

for Access 2003, and it's part of Visual Studio Tools for Office.

See http://msdn2.microsoft.com/en-us/library/d2tx7z6d(VS.80).aspx

Tony Toews has a good introduction to this at

http://www.granite.ab.ca/access/developereditionfaq.htm

Doug Steele, Microsoft Access MVP

http://I.Am/DougSteele

(no e-mails, please!)

"Joe" <jdj.ms-access.todaysummary.com.nospam.com> wrote in message

news:OXeD0sUHHHA.816.ms-access.todaysummary.com.TK2MSFTNGP06.phx.gbl...

> I'm interested in an open source, self-contained MDB file (MS Access) of a

> checkbook register complete with splits and paycheck break out, etc.

> Transfer to a secondary account (i.e. savings) within the same file would

> also be a plus.

> By self-contained MDB file, I mean no VB front end.

> If something like this exist as freeware or commercial, let me know.

> Thanks.

>

All Comments

Leave a comment...

  • 3 Comments
    • It's a pretty simple application but you might look at

      http://www.databasecreations.com/prod_checkwriter.htm

      jwm

      Joe wrote:[vbcol=seagreen]

      > Doug,

      > You misunderstood me. I want the mdb file to run within MS Access,

      > but I don't want any ancillary front-end required. It is assumed a

      > licensed version of MS Access is already available. In fact, I want

      > it open-source, so it is important that it is not a run-time instance.

      > I am trying to maintain portability without having to install dll's,

      > ocx, or other files that would be required for a front-end.

      > Bob

      >

      > "Douglas J. Steele" <NOSPAM_djsteele.ms-access.todaysummary.com.NOSPAM_canada.com> wrote in

      > message news:%23cdiF1UHHHA.3780.ms-access.todaysummary.com.TK2MSFTNGP02.phx.gbl...

      #1; Wed, 04 Jun 2008 01:48:00 GMT
    • I have no idea what you mean by "ancillary front-end".

      Doug Steele, Microsoft Access MVP

      http://I.Am/DougSteele

      (no private e-mails, please)

      "Joe" <jdj.ms-access.todaysummary.com.nospam.com> wrote in message

      news:OCZIg0gHHHA.4760.ms-access.todaysummary.com.TK2MSFTNGP03.phx.gbl...

      > Doug,

      > You misunderstood me. I want the mdb file to run within MS Access, but I

      > don't want any ancillary front-end required. It is assumed a licensed

      > version of MS Access is already available. In fact, I want it

      > open-source, so it is important that it is not a run-time instance.

      > I am trying to maintain portability without having to install dll's, ocx,

      > or other files that would be required for a front-end.

      > Bob

      >

      > "Douglas J. Steele" <NOSPAM_djsteele.ms-access.todaysummary.com.NOSPAM_canada.com> wrote in message

      > news:%23cdiF1UHHHA.3780.ms-access.todaysummary.com.TK2MSFTNGP02.phx.gbl...

      >

      #2; Wed, 04 Jun 2008 01:49:00 GMT
    • If all of your users have Access installed, I don't understand what issue

      you're concerned about.

      As long as you're using Access "out of the box" (i.e.: no additional

      controls than the default ones), you should have no problem.

      Doug Steele, Microsoft Access MVP

      http://I.Am/DougSteele

      (no private e-mails, please)

      "Joe" <jdj.ms-access.todaysummary.com.nospam.com> wrote in message

      news:evJOC1QJHHA.2456.ms-access.todaysummary.com.TK2MSFTNGP06.phx.gbl...

      >A front end that stands outside of the mdb file is what I mean by ancillary

      >front-end. Many times VB or VC++ will be used to create a front end GUI

      >with access being the backend for the database tables. I was looking for a

      >complete, self-contained mdb file where Access forms are used rather than

      >VB code to access the access tables.

      > My goals was to have a portable mdb file that can moved from computer to

      > computer on a thumb drive, rather than installing an app with addition

      > dll's, registry settings, etc. The PC's I have access to already have MS

      > Access 2003 loaded, so that is a given.

      >

      > "Douglas J. Steele" <NOSPAM_djsteele.ms-access.todaysummary.com.NOSPAM_canada.com> wrote in message

      > news:e4qrj0jHHHA.1248.ms-access.todaysummary.com.TK2MSFTNGP02.phx.gbl...

      >

      #3; Wed, 04 Jun 2008 01:50:00 GMT