Database suddenly stops allowing updates ! For no apparent Reason.

Big mystery for me this one.

I do a lot of work with Access. In fact i usually use access to add on
functionality to other programmes which have ODBC connections.

I have a database created with linked tables to Sage (a british accounting
package) using ODBC system DSN's.

Now this all works fine and daddy. Up until a few days ago when in resposnse
to the slowing down of the system due to too many updates i made a new copy
(for the older data) and repaired and compressed the existing one.

At that point the compressed database will no longer allow updates. All the
queries have suddenly become unupdatable recordsets.

So i want back to the copy and Voila it worked. This was three weeks ago.

Unfortunately i needed to reformat the machine. So i backed up all the data.
Reinstalled the whole lot. Suddenly once again the new database (with current
additions) is unupdatable. BUT the old one which i backed up in the same way
is still allowing updates.

Strange thing is that i made no changes in access to either database.

I cannot understand how this is happening.

BTW the tables are still accepting updates. Just not the queries.
.

Relevant Pages

  • Re: Database has gigantic size
    ... > reopen the recordset a few dozen times, but 1000 updates and a few ... If you don't do queries, where does your 'rs' come from? ... > is getting orphaned inside the database for some unfathomable reason. ... your recordset by an unindexed field, the DB has to do work (which uses ...
    (microsoft.public.vb.database)
  • Re: No. of Users and Data Security
    ... and all the users are doing queries (not updates), and the network is ... Conversely, if the database is not structured correctly, or the code is ...
    (microsoft.public.access.security)
  • Re: Updates to Access design
    ... Data and Queries should be kept ON THE DATABASE SERVER ... a dependable technique to add-in updates to an installed application. ...
    (microsoft.public.access.setupconfig)
  • Circular relationship nightmare
    ... that the database requires only 5 tables, ... deployment involves several tasks. ... I don't know how to set up my queries so that only ... RegionA receives dataset updates for Dataset1 and Dataset4 ...
    (comp.databases.ms-access)
  • DataSet.Designer.cs
    ... How do you updates the designer.cs file to reflect any changes you have made to the database WITHOUT losing all the queries etc you have put in. ...
    (microsoft.public.dotnet.languages.csharp)