JRO / Compact database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Michael Satterwhite (satterwh.XNOXSPAMX_at_weblore.com)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 11:52:22 -0600

I have an Access database that I need to repair compress programatically.
The database may be on a network drive, and I note that App.Path is
returning the UNC of the server, not the mapped drive name (this may or may
not be significant)

I'm getting an OLEDB error when I try to compress the database, and I'm not
sure how to get the system to tell me what it doesn't like. Here are the
Connection Strings:

Source: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\Photon\Project\Data\ProjData.mdb;Persist Security Info=False"

Destination: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\Photon\Project\Data\ProjCompressed.mdb;Persist Security
Info=False"

Would someone be so kind as to point me at a way to correct my error?

tia
---Michael

Relevant Pages

  • Database locking up ?
    ... OLEDB error: Desc:Could not find database ID 13. ... SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT COLUMN_NAME, ... because it occured with this query pretty often. ...
    (microsoft.public.sqlserver)
  • Concurrency Violation in DataSet Update ADO.NET
    ... Now I am developing Cheque Writing ... 'UPDATE DATABASE ... "TBKKTC") ... I use password to protect my Access database from ...
    (microsoft.public.dotnet.general)
  • Re: formatting columns
    ... This works for columns either to the left or right of the cell to be copied. ... >> I am preparing to set up a database in Access2002. ... >> have the time to set up the Access database so I must do ... >> my data entry into Excel. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Web Wiz Forums in New Subweb, Published with FP2003
    ... Whenever I download an Access database and prior to re-uploading I always do a compact and repair ... General rule once your forum is active, you should never download and then re-upload the ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Re: formatting columns
    ... >> I am preparing to set up a database in Access2002. ... He knows how to use Excel on a limited ... >> have the time to set up the Access database so I must do ... >> in the first cell, and then having to drap it down the ...
    (microsoft.public.excel.worksheet.functions)