Document Management

Access Corruption Issues

I figured it out!! What a pain in the a**. - the speed issue with the Data Entry screen. I just couldn't stand the mystery!!

Basic details. When I do development on my computer is will almost always corrupt the Order Entry Screen. Why I don't know. The corruption however is very very small and will allow the system to continue functioning without any problems besides the speed being slower on a Access 2002 computer. To fix it the Order Entry screen must be rebuilt manually on your computer (possibly just Access 2002 but I don't have a copy) this involves much manual work just to get it working again. Then once it's fixed the speed is back to it's speedy self and I can transfer the file back to my computer, run it with my copy of Access 2003 and transfer it back to you without corruption. It is yet to be determined how much if any development can be done before it is corrupt and speed is comprimised.

When you run the program the new version will be delivered and your speed should be good. Addtional enhancements:

        Billing will work everywhere.
        Client dropdowns are in order
        and of course speed enhancements.

Also a problem. Access 2003 compiled program seems to require a recompile for 2002. If the DB was converted to 2002 format would the errors/corruption/recompile go away?

Imaging

Requirements

Input

Formats

TIFF
PDF

Functions Needed

Split out pages
Combine from other files
Crop (take off top fax info)

Output

Formats

TIFF
PDF

Access Reports Directly to Image File
Directly to Email
Upload to website
Directly to File

Areas to Address

Direct Fax Files

Orders
Completion

Email Completion Docs
Tie Doc Images to Orders

Could have multiple files

Manipulate Images to return to Client

crop
combine
Put Cover sheet on (Completion Page)

Possible Issues

File naming conventions
Maximum File Storage per directory
Archiving old docs

Other Notes

Ranking system for Vendors/Clients?

Price
Friendliness
Copertive
Intelligence
Aptidude
Comprehension

The idea would be to develop an algorithm to rate the above to deterime proper vendor. Might be a little over the top.

SQL Stuff

: My SQL

Front Page \| Recent Changes \| Title Index \| User Preferences \| Random Page \| Help
Edit this page \| View other revisions \| Attachments (0)
Print this page \| View XML Find page by browsing, searching or an index Edited June 2, 2005 (diff)