DTP


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


Go Back   Desktop Publishing Forum > General Discussions > Software

Reply
 
Thread Tools Display Modes
Old 05-19-2011, 05:09 AM   #1
dthomsen8
Member
 
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
Old 05-19-2011, 06:29 AM   #2
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,712
Default

This is probably the best place to get a reasonably quick answer to your questions:

http://answers.microsoft.com/en-us/o...-access?page=1

If you checkmark the "Notify me" box at the bottom of your post there, you'll (usually) get email right away when someone responds, so you don't have to keep trundling back to the forum checking to see if you've been noticed.

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Old 05-19-2011, 07:08 AM   #3
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default

This looks like a great idea, but I am caught in a trap trying to create a Windows Live ID. I filled out their forms, and it sent me an email for verification, but there are no instructions on how to verify my email address. Every attempt to login, including attempts to get help, are met with a statement that I must verify my email address. I would if I could, but I cannot figure out how to do it. <sigh>
dthomsen8 is offline   Reply With Quote
Old 05-19-2011, 07:15 AM   #4
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default

Oh, oh, they send two emails, the second one says how to verify. Great, except the link that does the verify says they have a problem, try again later. <two sighs!>
dthomsen8 is offline   Reply With Quote
Old 05-19-2011, 07:17 AM   #5
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default Meanwhile, maybe answers?

Meanwhile, maybe you or someone else could answer my questions, which I think are rather elementary.
dthomsen8 is offline   Reply With Quote
Old 05-19-2011, 07:51 AM   #6
ktinkel
Founding Sysop
 
ktinkel's Avatar
 
Join Date: Oct 2004
Location: In Connecticut, on the Housatonic River near its mouth at Long Island Sound.
Posts: 11,189
Default

Quote:
Originally Posted by dthomsen8 View Post
Meanwhile, maybe you or someone else could answer my questions, which I think are rather elementary.
They may be elementary, but I don’t know the answers, and I did not see those particular issues queried at the web site. Sorry.

   
__________________
[SIZE=2][COLOR=LemonChiffon]::[/COLOR][/SIZE]
[SIGPIC][/SIGPIC]
ktinkel is offline   Reply With Quote
Old 05-19-2011, 08:59 AM   #7
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default

I am in now, and have asked my questions.
dthomsen8 is offline   Reply With Quote
Old 05-19-2011, 11:43 AM   #8
ktinkel
Founding Sysop
 
ktinkel's Avatar
 
Join Date: Oct 2004
Location: In Connecticut, on the Housatonic River near its mouth at Long Island Sound.
Posts: 11,189
Default

Quote:
Originally Posted by dthomsen8 View Post
I am in now, and have asked my questions.
Oh, good.

   
__________________
[SIZE=2][COLOR=LemonChiffon]::[/COLOR][/SIZE]
[SIGPIC][/SIGPIC]
ktinkel is offline   Reply With Quote
Old 05-19-2011, 12:04 PM   #9
terrie
Staff
 
Join Date: Oct 2004
Posts: 8,918
Default

Quote:
dthomsen8: Oh, oh, they send two emails, the second one says how to verify. Great, except the link that does the verify says they have a problem, try again later. <two sighs!>
I have moved your previous post which had your email addy and other WinLive account info out of public view. Would you like me to delete it?

Terrie
terrie is offline   Reply With Quote
Old 05-19-2011, 05:09 PM   #10
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,712
Default

You can tell whether it's a real Microsoft communication or a fake. If it's simple to accomplish and goes as expected, it's not the real thing, beware. If it all takes ten or fifteen more steps (to say nothing of the fiery hoops and rolling across racetracks between speeding cars, under machine gun fire, it's The Real Thing.

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Reply

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 07: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 10: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 02:25 AM.


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