Clip Logging In MS Access

Hannibal_ wrote on 1/30/2004, 4:22 PM

OK,
Being the impatient, impulsive person I am, and intrigued by Grazies Idea for a clip DB, I just couldn't contain myself. It probably doesnt contain all elements for some and too many for other. Probably not pretty enough for some but I tried. I needed to learn this relational DB stuff anyways and I did learn alot doing it. If even a few people find it useful then I will be gratified. Any tips or pointers from the pros would be appreciated. I dont have an upload site but will email to anyone who wants to try it. Size is 1.64 MB with one test record in place.

Comments

RexA wrote on 1/31/2004, 12:19 AM

>> Size is 1.64 MB with one test record in place.

That sounds a bit large to me. You might want to try compressing it. I still am running Office 97, but if the layout is still similar, Tools/Database Utilities/Compress Database might shrink it.

Liam_Vegas wrote on 1/31/2004, 12:42 AM

http://www.VegasUsers.com is a good place to upload this file to (but as of this moment in time the site appears to be down).

kirsol wrote on 1/31/2004, 12:45 AM

I still am running Office 97, but if the layout is still similar, Tools/Database Utilities/Compress Database might shrink it.

In Access 2000/XP, it's Tools-Database Utilities-Compact And Repair Database. Don't know about Access 2003 but I'm guessing it's the same as in 2000/XP.

Mitch K

Hannibal_ wrote on 1/31/2004, 4:11 AM

This has brought it down to 996Kb. Thanks!