Re: Which database should I use?


Ahum sorry but you are wrong :-)

I wish MSDE or SQL Express could even come close to the security that
Access has with the combination Workgroup information file

>Everyone with MS-Access can basically enter
> and alter the database. That password protection thingy that they offer is
> a bit on the weak side.

That is exactly what is possible with SQL server and for a fact with all
other RDBMS systems but not with Access in combination with a Workgroup
information file ( this is not the same as the easy to break password
protected database )

if you ship a sql mdf file everyone with a Enterprise Manager or SMS
installed and administrator rights on his system can access the database


if you want to take up the challenge i can send you a workgroup protected
database of mine and you can see for yourself :-)

regards

Michel Posseth [MCP]





"Martin" <x@xxxxx> wrote in message
news:Ot9eUHcGGHA.3856@xxxxxxxxxxxxxxxxxxxxxxx
>I agree, the Jet engine is a great little engine, and highly reliable. It's
>only weak point is on security. Everyone with MS-Access can basically enter
>and alter the database. That password protection thingy that they offer is
>a bit on the weak side.
>
> However, if you like free and reliable and with more security options, I'd
> go for MSDE (SQL Server Desktop Edition, or I believe these days it's
> called SQL Server 2005 Express). It is free and downloadable from
> www.microsoft.com
>
> hth,
> Martin
>
>
> "m.posseth" <michelp@xxxxxxxxxxxxxxx> wrote in message
> news:%23E6%23DrbGGHA.1192@xxxxxxxxxxxxxxxxxxxxxxx
>>I am with Cyril ,,
>>
>>
>> if you need the described functionality Access stands all alone out there
>> , i have not yet found a good alternative ( although i would prefer a
>> RDBMS as i use databases of gigabytes in size ) however they all miss the
>> security thingy
>>
>>
>> about the multi user problem ,,,,, well you can tackle this with your
>> program design
>>
>>
>> regards
>>
>> Michel Posseth [MCP]
>>
>>
>> "Cyril Gupta" <nomail@xxxxxxxx> wrote in message
>> news:O3518EbGGHA.1192@xxxxxxxxxxxxxxxxxxxxxxx
>>> What reliability issues have you faced in MS Access? I have used MS
>>> Access for many of my commercial applications. Like you I too market my
>>> products widely and I have found that NOTHING beats Access for the
>>> particular requirements that you have mentioned.
>>>
>>> Do you really want to use an alternative database technology and not get
>>> all the benefits of wide-usage and tools that Jet offers.
>>>
>>> Most reliability issues that people report can be solved through
>>> workarounds, so do report the issues, maybe there's a solution.
>>>
>>> Regards
>>> Cyril Gupta
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Database Ruined
    ... I had no idea setting up security could cause so many ... In a properly secured database, only the owner of that database has ... last time you can view these VERY important settings. ... use the exact same settings when recreating the workgroup. ...
    (microsoft.public.access.security)
  • Re: Security disapears from menubar when I add a new user
    ... > user logon and created an administrative logon called "sysadmin". ... > database owner is "sysop" and was used for development. ... by creating a new workgroup information file with a unique workgroup ... Security FAQ, ...
    (microsoft.public.access.security)
  • Re: Sorting out security
    ... There is a link to it on the Security page of my website. ... > files and remote logins to a secured database. ... different name for the secure workgroup file. ... If the Admin user has no password then every user is ...
    (microsoft.public.access.security)
  • Re: Turn off Access security--no password provided
    ... Open Access (no database). ... see what workgroup you are currently joined to by default. ... > played around with the security settings in Access and long ago ...
    (microsoft.public.access.security)
  • Re: User and Workgroup was screwed
    ... system.mdw file after he implemented the security on the database. ... we tried to create a new mdw file by using those info in the text ... password in the workgroup. ...
    (microsoft.public.access.security)