Results 1 to 9 of 9

Thread: Database Question

  1. Jul 30th, 2007, 01:16 PM #1
    ravininave
    ravininave is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2006
    Posts
    243

    Database Question

    Hi Friends,
    I'm using VB & Access 2000. My problem is this that anyone can open Access Database even it's protected by password as there are so many tools to know the Access database password. My application is not so big to use Sql Server or Oracle. So plz suggest me any other Back-End which could not be opened by end user and it could not occupy so much space as Oracle.

    Thanks.

    Ravikant
    Reply With Quote Reply With Quote
  2. Jul 30th, 2007, 01:25 PM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Database Question

    Moved to the Database section

    Have you looked at MySQL?
    Reply With Quote Reply With Quote
  3. Jul 30th, 2007, 01:35 PM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Database Question

    There are several editions of SQL Server, including two 'lightweight' ones, that you can freely download direct from Microsoft (and can install on a standard PC).

    If you are just using Access to store data (on a single PC), SQL Server CE is the recommended replacement.

    If you also have queries etc (or users on multiple PC's), SQL Server Express is the recommended replacement.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  4. Jul 30th, 2007, 01:43 PM #4
    ravininave
    ravininave is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2006
    Posts
    243

    Re: Database Question

    Does it takes too much space? And what about run time files. Yes I'm using it in LAN also.
    Reply With Quote Reply With Quote
  6. Jul 30th, 2007, 01:52 PM #5
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Database Question

    I think that Express is best suited to your needs (but haven't used CE at all, let alone with multiple computers).

    I'm not sure how big it is when installed (CE is much smaller), but the download is 36.5MB (here).

    Unfortunately you do need .Net Framework 2, which increases the size of the download (if you aren't installing it already for other parts of your system).
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  7. Jul 30th, 2007, 02:01 PM #6
    ravininave
    ravininave is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2006
    Posts
    243

    Re: Database Question

    But .Net Framework 2 itselft takes too much space. Is there any other Database.
    Reply With Quote Reply With Quote
  8. Jul 30th, 2007, 02:05 PM #7
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Database Question

    Is it a multi-user database???

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  9. Jul 31st, 2007, 12:59 PM #8
    ravininave
    ravininave is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2006
    Posts
    243

    Re: Database Question

    Is there any other Database.???
    Reply With Quote Reply With Quote
  11. Jul 31st, 2007, 01:00 PM #9
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Database Question

    Quote Originally Posted by szlamany
    Is it a multi-user database???
    Can you answer this question please.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width