Re: Advice On How To Keep Data Please


I think to best answer your question you need to answer a few more questions yourself.
a.. How much data do you plan to store?
b.. How secure must it be?
c.. Where does the data come from? An existing database, an existing server, end-users, process-control systems or something else?
d.. What format is this imported or existing data? XML, JET database, SQL Server database or some other source?
e.. Do you plan to pass the stored data around? For example, do you plan to pass the database (or data) from person-to-person as an email attchment?
f.. How do you plan to share the data (or do you plan to share it at all)?
g.. Do you plan to expand the database or the number of users in the future?
h.. What tools do you plan to use? Are you familar with Visual Studio/VB.NET/C#?
i.. What DBMS tools do you plan to use?
j.. Do you need a consumer-grade database frontend like Access or do you plan to use the VS tools to build a UI?
k.. Are you planning an ASP (or ASP.NET) application, a Windows Forms or new advanced technology applications?
l.. And, most importantly, do you plan to upgrade your skills from DAO or ADO to ADO.NET?

There are (always) more questions, but these should give us a good idea about which DBMS engine is necessary.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Jeff Gaines" <whitedragon@xxxxxxxxxxxxxxxxx> wrote in message news:xn0fahue119q4e000@xxxxxxxxxxxxxxxxxxxxxxx
On 28/08/2007 in message <xn0faht3q3xdhdw000@xxxxxxxxxxxxxxxxxxxx> Jeff
Gaines wrote:

It's clear that I need to update my trusty Access 2007 so I am trying to
think in broad terms the best way to keep my data.

Sorry to follow up my own post, it's Access 97 I need to upgrade :-)

--
Jeff Gaines

Relevant Pages

  • Re: Adding another server instance to another hard drive?
    ... A disaster recovery plan will help you minimize data loss. ... If your computer crashes and/or you lose your SQL Server drive, ... get lucky with a successful attach of the database files if your database ... > drives to actively store data. ...
    (microsoft.public.sqlserver.server)
  • msdb refuses to back up w/ plan
    ... I've created a Mx plan for the system databases. ... Part of it is a complete backup. ... See the SQL Server error log for more ... Mx plan would fail for just this one database, when I can back it up ...
    (microsoft.public.sqlserver.server)
  • Re: DB Integrity Check
    ... You still have a database corruption issue that you need to address. ... Microsoft SQL Server MVP ... The Maintanence Plan must put the database ... SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan ...
    (microsoft.public.sqlserver.setup)
  • HELP on building web page content ????
    ... I need to develop an analysis tool which collects data from an SQL server ... I plan to build it as a web application because more that one user might ... which fields my custom,er would like to extract from the database, it could ...
    (microsoft.public.dotnet.framework.aspnet)
  • Strategy for a databse
    ... I have some experience with building a database of people, ... regular trips but often also charters of various lenghts. ... I need to plan ... For all these things, and many others I have reports, in Excel format, ...
    (microsoft.public.access.gettingstarted)