Re: Recovering from an updatebatch error with a clone

Brian Bushay TeamB <BBushay@xxxxxxxxx> wrote:
> Loadfromfile and Open are incompatible.
> LoadfromFile opens the dataset using the contents of the file.
> Open opens the dataset using records retrieved from the database
> connection. So with the above code you loose all the previous edits
> that you saved with saveTofile because you over write them with the
> records in the database.

Well no I don't lose the data... It is there, only that the edits cannot be
saved.
I looked at the BetterAdodataset.LoadFromFile and it does:

Close;
CommandType := cmdFile;
LockType := ltBatchOptimistic;
CommandText := FileName;
Open;

And Open if it's already open won't do anything... Only idea that I have
left is to create another dataset in memory and copy the data there as
backup
but it's really overkill.

--
Have you seen Marillion's Marbles? Visit www.marillion.com and get in
touch with the most amazing music...


.

Relevant Pages

  • Re: Tracking Log In and Log Out times of Users
    ... The fact that the database is on the server should be irrelevant. ... Type mismatch and then highlights Set rst = ... On my startup form, (that opens every time the database is open, ... I then went to the load ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • Re: Code causes error 2486 in access 2000, IPF in 2002
    ... Compact the database to get rid of this junk: ... Allen Browne - Microsoft MVP. ... Windows 98 machine. ... update queries and opens another form - ...
    (microsoft.public.access.formscoding)
  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)