Lively discussions on the graphic arts and publishing — in print or on the web

Go Back   Desktop Publishing Forum > General Discussions > Software

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 05-19-2011, 05:09 AM   #1
dthomsen8's Avatar
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default Microsoft Office Access 2010

I am considering Microsoft Office Access 2010 for a new database application, but I have a few questions. Probably it is suitable, but I want to know before purchase.

1) Will Access 2010 handle a database of a million records, 300 bytes per record?

2) The older Access tried to prevent bad data from entering the database by checking on linked fields. Can that feature be circumvented or somehow used to flag bad fields, rather than rejecting the records?

3) When development is done, the database would be distributed with the run-time module on a CD or DVD for users. Any difficulties there?

4) The database would be loaded from a comma delimited or fixed field text file of a million records. This should be easy, but then there would be linking to other records for validation after loading, for example, zip codes, or correcting street names to match USPS standards. Any difficulties with doing that?

These kinds of things I once did easily with MS Foxpro, but MS Access is more user friendly, or at least I think so. My hope is that the development I want would be quicker with Access. Any other advice would be welcome.

Last edited by dthomsen8; 05-19-2011 at 05:11 AM. Reason: Added a question.
dthomsen8 is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2003 coexist with Office 2007? terrie Software 20 02-08-2011 08:53 PM
Office 2010 release is soon Michael Rowley Software 18 04-23-2010 10:01 AM
Office 2010 & OpenType Michael Rowley Fonts & Typography 56 10-03-2009 07:19 AM
Microsoft Office Home & Student ktinkel Software 35 11-29-2008 11:39 AM
TIF to Microsoft Office Document Imaging File??? Ashlie Images 16 06-02-2008 01:01 AM

All times are GMT -8. The time now is 06:11 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2023, vBulletin Solutions, Inc.
Contents copyright 2004–2019 Desktop Publishing Forum and its members.