[AccessD] AC 2007/2010 - Help...this is turning into a research project

jwcolby jwcolby at colbyconsulting.com
Thu Aug 4 12:29:41 CDT 2011


Amen!



John W. Colby
www.ColbyConsulting.com

On 8/4/2011 11:36 AM, William Benson wrote:
> I guess i would try to sell them on a complete new design and a split
> database. Split it. Use automation to bring data into access where you can
> manipulate it more cleanly. I think if you work in a sandbox someone else
> has left their filled diapers all around you might come out with not just
> sand on your feet.
> On Aug 4, 2011 11:31 AM, "Mark Simms"<marksimms at verizon.net>  wrote:
>> Long story short:
>> Got a call from an agency....for a "short term" contract to "clean-up" an
> AC
>> 2007/2010 application.
>>
>> I've finally looked into the plumbing....
>> All of the usual....some tables have no keys, some tables have client
>> descriptions as keys, etc, etc.
>> It was all designed by non-professionals.
>>
>> It gets better: Most of the work is done in Excel....it acts as a giant
>> "dashboard"....investment/portfolio management application.
>>
>> They are using all of the new Table features with OLEDB connections from
>> Excel to Access.
>> A million calculations are being performed against this linkages in
>> Excel.....25 worksheets total.
>>
>> My first task of creating some VBA to update the OLEDB connections took
> over
>> 8 hours.....and quite a bit of research. I kept on getting 1004 errors for
>> one of the connections. Here, it turns out that connection was to a Pivot
>> Table that went directly to an Access table.
>> Any attempts to update the DataSourceFile property failed via VBA.
>> However, get this: it could be done thru the GUI.
>> So once again, I tried researching this....to no avail.
>> It appears this whole project might become a research project.....and
>> the client wants a defined time-line.
>>
>> What do I do ?
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list