[mdlug] MS Access CRM

[Jeff Hanson]

On Sun, Nov 22, 2009 at 4:51 PM, Andrew Koper <akoper at ameritech.net> wrote:
> I am making a basic CRM in MS Access.  It should be pretty simple - three
> tables and a couple of forms.  I am not an Access person, but I am taking a
> stab at it.  I was hoping there was somebody on this list with MS Access
> experience.  I would like for us to meet at Panera or someplace like that
> sometime soon, sit down with our laptops, and finalize it over dinner and an
> hour or two.  I'll pay for the food.
>

Why Access and not a web form?

Are you using the default Jet/ACE garbage DB?  At the very least, use
SQLite or SQL Sever for the DB.  Jet/ACE was deprecated by the SQL
team but the Office team forked it:
http://blogs.msdn.com/access/archive/2005/10/13/access-12-s-new-data-engine.aspx

I'm not offering to help - that would be akin to assisted suicide.  I
use Access at a customer site for an in-house inventory control system
and it is horribly unreliable.

There has to be dozens free CRM solutions in the world.