[mdlug] MS Access CRM

[Michael Mikowski]

FYI, from my KB wiki
To set up OOBase on your local box on Ubuntu 9.04:
	* Install libmyodbc, openoffice.org-base
	* Update /etc/odbc.ini to contain text from below
	* Run oobase, and select the pzbase ODBC data source

[localhost]
Driver       = /usr/lib/odbc/libmyodbc.so
Description  = MyODBC 3.51 Driver DSN
SERVER       = localhost
PORT         = <my_port> # usually 3306
USER         = <my_user>
Password     = <my password>
Database     = <my_crm>
OPTION       = 3 # do not recall what this means off-hand
SOCKET       = /home/pz/var/run/mysqld/mysqld.sock

# See https://help.ubuntu.com/community/ODBC



----- Original Message ----
From: David Lane <dcl400m at yahoo.com>
To: MDLUG's Main discussion list <mdlug at mdlug.org>
Sent: Tue, November 24, 2009 11:17:35 AM
Subject: Re: [mdlug] MS Access CRM

I am, I'm not sure about Andrew.

I preffer Mysql because it is so manageable.

David C. Lane




________________________________
From: Michael Mikowski <z_mikowski at yahoo.com>
To: MDLUG's Main discussion list <mdlug at mdlug.org>
Sent: Tue, November 24, 2009 2:05:16 PM
Subject: Re: [mdlug] MS Access CRM

Here's a thought:

OObase.  Tie to default database, or tie into an enterprise database like JET^H^H^H MySQL using ODBC.

Really easy to set up, and you are not locked-in, and a nice RAD environment.

And, assuming you use MySQL, you can expand it to the web or other interface if/when you need.

Cheers, Mike




----- Original Message ----
From: David Lane <dcl400m at yahoo.com>
To: MDLUG's Main discussion list <mdlug at mdlug.org>
Sent: Mon, November 23, 2009 11:06:40 AM
Subject: Re: [mdlug] MS Access CRM

You can also use Acces JUST for the frount end and use an open source Database on the back end and tie the Data to client accounts.

David C. lane 





________________________________
From: "gib at juno.com" <gib at juno.com>
To: mdlug at mdlug.org
Cc: mdlug at mdlug.org
Sent: Mon, November 23, 2009 2:00:06 PM
Subject: Re: [mdlug] MS Access CRM


This looks like a good discussion topic for our regular meeting on December 12th.

---------- Original Message ----------
From: "Andrew Koper" <akoper at ameritech.net>
To: "'MDLUG's Main discussion list'" <mdlug at mdlug.org>
Subject: Re: [mdlug] MS Access CRM
Date: Mon, 23 Nov 2009 13:43:20 -0500

Thanks for the advice, everyone.  I know there are other CRM's and I
researched several.  As an open source guy, my first choice was Sugar CRM.
I downloaded it, installed it, and printed out the documentation; found the
user interface cluttered, confusing, and unclear and the documentation
poorly written; and I feel like I wasted dozens of hours on a bad app.  Out
of frustration, I've started to "roll my own" to get the straightforward app
it should be.  One of the things that intimidates some is the tens of
thousands of records I will be importing into it from different sources that
are laid out slightly differently.  I am looking deeper at Salesforce.com,
and I know there are other development frameworks.

- Andrew Koper


-----Original Message-----
From: mdlug-bounces at mdlug.org [mailto:mdlug-bounces at mdlug.org] On Behalf Of
Andrew Koper
Sent: Sunday, November 22, 2009 4:52 PM
To: mdlug at mdlug.org
Subject: [mdlug] MS Access CRM

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.



Thanks in advance,

-          Andrew Koper

_______________________________________________
mdlug mailing list
mdlug at mdlug.org
http://mdlug.org/mailman/listinfo/mdlug

_______________________________________________
mdlug mailing list
mdlug at mdlug.org
http://mdlug.org/mailman/listinfo/mdlug

____________________________________________________________
Become a Paralegal
Start your paralegal career with an online degree. Free info packs!
http://thirdpartyoffers.juno.com/TGL2131/c?cp=qmZDQXLOQmDjhQaOI9-s5AAAJz07QkQODMrtXujsdlflQzfUAAQAAAAFAAAAAD86Ej8AAAMlAAAAAAAAAAAAAAAAAAVlMAAAAAA=
_______________________________________________
mdlug mailing list
mdlug at mdlug.org
http://mdlug.org/mailman/listinfo/mdlug



      
_______________________________________________
mdlug mailing list
mdlug at mdlug.org
http://mdlug.org/mailman/listinfo/mdlug

_______________________________________________
mdlug mailing list
mdlug at mdlug.org
http://mdlug.org/mailman/listinfo/mdlug



      
_______________________________________________
mdlug mailing list
mdlug at mdlug.org
http://mdlug.org/mailman/listinfo/mdlug