Re: SQL or Access DB

Well ,,,,,,,

sorry to throw some gassoline on this firy thread

But as far as i know ,,,, ms Access , MSDE and SQL express are all free for
a Visual studio programmer

file security lets me stick to MS Access 2000

MSDE , SQL express , firebird , interbase etc etc all great databases
however they lack one key functionality that keeps me from using it in my
deployable apps
and that is security ,,,,, everyone with admin rights can look in your
database files and see your data , with access you can create a workgroup
file , encrypt the database and only your program can access the data

This is no problem if your users own the data , in my situation the data is
the core business ( this is were the value of the app is ) so you do not
want to have the concurency steal your data and create there own gui aropund
that data and sell this as there own product

i wish i could switch over to a reall RDBMS as our database files are
growing to gigabytes ,,,, however i must say about access it isn`t so bad as
people are telling here because our products are beeing used by thousands of
users throughout Europe and are even used on server farms with more as 50
users using the same program ( thus same DB ) however we are talking about
mostly read data with once in a while a price update

Also the ease to deploy your app with a Access DB,, well ,,, its just a
mather of xcopy and make sure Mdac is installed on the target system

I have once made a deploy package for MSDE and found myself coding in C++
to get everything how i wanted it ( check if there is already an instance,
naming etc etc ) , i understood that this is now much better with sql
express however now you should investigate Installer technology as eveything
is now in a Merge module that can be customized with these options ( MSDE
had also a MM but this lacked these options )

If i am truly honest ,,,,,,,, i must say that if file security was not an
issue i would probably now use the Firebird DB as it performs superb, is
free and is much easier to deploy , (XCOPY deployable , and it is multi
platform ),, there is even an embedded version , that can be scaled up to
the reall server version . and again i must say that this hurts me as i am a
true MS fanatic


regards

Michel Posseth [MCP]








"Earl" <brikshoe@xxxxxxxxxxxxxxxxx> schreef in bericht
news:%23RFWxN9nFHA.420@xxxxxxxxxxxxxxxxxxxxxxx
> If the database design is normalized, then it's less likely that size will
> become an issue. A non-normalized database will grow exponentially.
>
> JET ("Access") could be used, as I have in the past for a small system
> with less than 10 users, but in time, you will sooner or later hit a
> locking issue and/or possible corruption.
>
> As noted by Cor, MSDE is a real bitch to deploy (the cynic in me says that
> was by design), so the best "free" choice for a networked solution would
> be SQL Express 2005. I'm not sure about the licensing issues in your
> scenario.
>
> Otherwise, for a small business, if you don't already have a server
> installed and plan to build a small network, you might consider buying
> Small Business Server Premium. It comes with SQL Server 2000 Standard.
>
> "DaveG" <newsgroup@xxxxxxxxxxxxxxx> wrote in message
> news:O9mdnbY3z-GFdWHfRVnzvA@xxxxxxxxxxxxxx
>> Hi all
>>
>> I am planning on writing a stock and accounts program for the family
>> business, I understand this is likely to take close to 2 years to
>> accomplish. The stock is likely to run into over a thousand items and
>> the accounting side will be used for hopefully many years so the
>> entries are likely to be vast.
>>
>> The delema is what is best to use ase the DB engine, Access I have as
>> part of Office 2002 or should I really be looking at SQL server??
>>
>> What are the pros and cons between the two??
>>
>> The DB will only be accessed by one client at this time but never more
>> than 2.
>>
>> If the choice is SQL Server is there a version available just for
>> single clients. I remember using MSDE when I did my ASP.Net book can
>> this be used to create the initial DB???
>>
>> Thanks for taking the time to read this, any advice would be very
>> helpfull to me at this planning stage.
>>
>> --
>> DaveG - Learning VB.Net slowly.
>> Skøyen - Oslo - Norway
>
>


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
Loading