Re: My access database file just keeps getting bigger

Vassiliev,

Thanks for that. I'll give it a go.

Regards,

Andy
Vassiliev V. V. wrote:
You can compact MS Access database - import "Microsoft Jet and Replication Objects 2.X Library".

var
engine: IJetEngine;
src, dst: WideString;
begin
src := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + 'C:\SrcDB.mdb';
dst := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + C:\compacted.mdb';

engine := CoJetEngine.Create();
engine.CompactDatabase(src, dst);
end;

This will also repair database. You always compact into another database.
All users should be disconnected. After this you could copy compacted.mdb in
place of srcdb.mdb.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Andy Stephenson" <info2004@xxxxxxxxxxxxx> ???????/???????? ? ???????? ?????????: news:464dca75$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm using an access file to form a queue between my app and an sql database. If I can't connect, I send the data to the access database. Later, when I can connect, I send the data to the sql server, and delete it from the access database.

However, the access database file just keeps on getting bigger. If I use access to have a look at it, it contains no data. I am guessing that when I delete the data, it is being retained.

Is this really the case, and if so, how do I really get rid of it?

Thanks,

Andy


.

Relevant Pages

  • Re: I dont know how to link VB to database (ODBC) table.
    ... The Provider/Driver -> Uses a Connection String to access a Database engine ... The Jet engine -> Uses your data store. ... Under TextBox Property ...
    (microsoft.public.vb.general.discussion)
  • Re: Using python for a CAD program
    ... relational database models. ... While it might be possible to do this fast enough with Python, ... Basically what the retained mode engine does for you is it ... The retained mode engine will take care of things such as ...
    (comp.lang.python)
  • Re: I dont know how to link VB to database (ODBC) table.
    ... If you are using VB6 have you installed service pack for VB? ... Would try using ADO Data Control to check whether you can connect to ... whether I can connect to database or generate a connection string using this ... (In your case the "Jet Engine") ...
    (microsoft.public.vb.general.discussion)
  • Re: sorter script [was: Frustrated newbie question]
    ... was from the "perldoc -q sort" as a way of ... most 'elegant' of looking algorithms. ... that bogged the database engine down. ... was due to bad implementation on the db engine. ...
    (perl.beginners)
  • Re: Database Alternative
    ... We built our engine with C#, using the subset of functionality available ... convenient to use the databinding functionality available with .NET. ... a database file. ... What do your customers use "GT40" for? ...
    (microsoft.public.dotnet.framework.compactframework)