My access database file just keeps getting bigger

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

  • Creating new Database with SQLDMO crashes
    ... We have a VB.Net app that creates a new SQL database based on the structure ... But on our Beta server it crashes and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access2k upsizing to SQL2k Automation
    ... Once I manually set the primary keys on two of the ... correctly against the SQL database. ... Upsize Wizard only marks some of the columns 'null'. ...
    (microsoft.public.access.conversion)
  • Re: too much OOP ?
    ... SQL database, ... You cannot say that without specifying what kind of requests are planned. ... nothing about inventory management, but in my area of interest relational ...
    (comp.object)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • .mdbs and windows file security - any gurus??
    ... an in-house VB app. ... The Access file is then transferred via flash media to an ... get an error to the effect "cannot build database file". ... If they login to the destination PC as local admin or give ...
    (microsoft.public.access.externaldata)