Re: insert or append / Access-Reorganisation

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/07/04 

Date: Fri, 06 Feb 2004 21:45:25 -0600

> in the MS-Access itself) I think, there may be something wrong in the
>way, my Delphi-App
> uses this Database. But what could it be ?
> Could it be, that one of those two alternatives - insert or append -
>could cause more need to
> re-organisation than the other one ? Or does'nt it make any difference

I guessing that when you say reorganizing you really mean you have to compact
and repair the database frequently.
Access databases tend to act that way when they get too large or have too many
users. Best solution would be to migrate to SQL server 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: About Entity-Relationship Diagram in BDS 2007
    ... generate a database to support an object model; ... need for an E-R tool as the entities and relationships are described ... All the great TeamB service you've come to expect plus ...
    (borland.public.delphi.non-technical)
  • Re: DBGrid and DBNavigator question
    ... The simple solution is to create a unique index on the serial number ... The database will prevent the update and ... display an error message. ... TeamB cannot answer questions received via email ...
    (borland.public.delphi.database.ado)
  • Re: how do you name the controls?
    ... Wayne Niddery [TeamB] wrote: ... I think I need to start a list (Possibly a web site somewhere) which contains: ... "He who treats the database as a flat-file repository of data is doomed to burn in Hell. ...
    (borland.public.delphi.non-technical)
  • Re: MySQL, ADO and ODBC
    ... value in your database. ... ADO must be able to find the record to update in your ... >> Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: deleting a record and doing changes in table
    ... database. ... I suggest you look at this method in Delphi Help ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)