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

Groups > comp.lang.basic.visual.misc > #531

Re: Getting inside an .accdb file

Show all headers | View raw

On Wed, 23 Nov 2011 18:10:00 -0000, R C Nesbit <spam@ukrm.net> wrote:
  
>Nothing personal - I've developed lots of apps using Access - but only as a 
>back-end database engine with a separate VB Executable front-end.
>
>It is perfect for small databases with limited users and record counts, and 
>using a separate .exe front end the user doesn't have to have Access 
>installed on every desktop.

Although of course you can install the free Access runtime.  Also I've
done a lot of work in VB6, although entirely in utilities such as the
Auto FE Updater and for a database centric app, Access is considerably
easier to work with, than VB.

I've had several clients hit 160 tables, 300 Mb Access backend files
and 15-25 active users before they migrated to SQL Server.

>But we also use other RDBMS's, MySQL, SQL-Server etc. and migrating data from 
>an Access file with spaces all over the place is a pain in the bum, to be 
>honest.

It sure is.

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files 
  updated see http://www.autofeupdater.com/

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-17 09:48 +0000
  Re: Getting inside an .accdb file H-Man <Spam@bites.fs> - 2011-11-17 14:37 -0700
    Re: Getting inside an .accdb file H-Man <Spam@bites.fs> - 2011-11-17 16:23 -0700
      Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-18 09:46 +0000
        Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-18 12:10 -0700
  Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-17 16:08 -0700
    Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-18 09:46 +0000
      Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-18 12:09 -0700
        Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-19 10:29 +0000
          Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-21 13:05 -0700
            Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-23 18:10 +0000
              Re: Getting inside an .accdb file ralph <nt_consulting64@yahoo.net> - 2011-11-23 15:10 -0600
              Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-24 17:12 -0700
        Re: Getting inside an .accdb file Jason Keats <jkeats@melbpcDeleteThis.org.au> - 2011-11-19 22:23 +1100
          Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-20 12:30 +0000

csiph-web