Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #9346

Re: SQL Backend and other questions..

Show all headers | View raw

On 05/06/2014 12:06 PM, musicloverlch wrote:

> I have a database split into a front end and back end and I keep
> reading that it is better if the back end is in SQL.  Really?  Why?
> Is there a noticeable speed difference? That's the only reason I
> could think to switch.  I'm being pressured by mgmt to move the
> database out of Access and into something "more robust".

I like Access, but nearly everything is more robust than the Jet engine.


How many concurrent users will you have?

What row counts do you have in the main tables?

How 'complicated' is your db?  Lots of relationships and indexes?

How much updating/inserting/deleting is being done?


I lost a few records to Access table corruption over the years - there's
NO excuse for that.  Suddenly the columns are filled with gibberish, and
you can't get that data back except thru a backup.



> Has anyone
> tried the MS Access tools in SharePoint?
>
> What other mid-range database tools are there out there?


I've lately been looking at this powerful public domain filesystem db 
called SQLite
www.sqlite.org

There's an ODBC driver available.
http://www.ch-werner.de/sqliteodbc/

I can't say it will work better for you than Access, but it's capacities 
are much higher.

http://www.sqlite.org/limits.html


I've been trying to find someone who replaced a multi-user Access 
backend with SQLite (and ODBC links to the Access frontend), but no luck 
so far.



> Any comments would be appreciated.
>
> Thanks, Laura

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

SQL Backend and other questions.. musicloverlch <lhowey@gmail.com> - 2014-05-06 09:06 -0700
  Re: SQL Backend and other questions.. bobh <vulcaned@yahoo.com> - 2014-05-06 10:58 -0700
    Re: SQL Backend and other questions.. musicloverlch <lhowey@gmail.com> - 2014-05-06 14:14 -0700
      Re: SQL Backend and other questions.. DFS <nospam@dfs.com> - 2014-05-06 17:38 -0400
  Re: SQL Backend and other questions.. "Albert D. Kallal" <PleaseNOSpamkallal@msn.com> - 2014-05-06 15:54 -0600
    Re: SQL Backend and other questions.. Larry Linson <larry.linson@verizon.net> - 2014-05-19 21:50 -0500
      Re: SQL Backend and other questions.. DFS <nospam@dfs.com> - 2014-05-26 23:36 -0400
        Re: SQL Backend and other questions.. Larry Linson <larry.linson@verizon.net> - 2014-05-27 00:30 -0500
  Re: SQL Backend and other questions.. DFS <nospam@dfs.com> - 2014-05-06 19:46 -0400

csiph-web