Re: Not enough Parameters?

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/25/05 

Date: Thu, 24 Feb 2005 21:52:34 -0600

>I have written the following function to compact & repair my
>MS Access database.
>
>My problem is that I keep getting the following exception on the
>V.CompactDatabase line saying "project blah.exe raised exception class EOleSysError with message 'Invalide number of parameters'"

> V.CompactDatabase('Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+DB+';Mode=Share Deny None;Persist Security Info=false;Jet OLEDB:Database Password=xxxxxxx' +
> 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+DB+'x;Mode=Share Deny None;Persist Security Info=false;Jet OLEDB:Database Password=xxxxxxx');

I don't see a coma separating the two parameters that compactDatabase requires 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Security exception while opening an OleDBConnection
    ... CyberLotus have you given it the right permissions? ... and i posted a similar solution for MS access database. ... Security Exception. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • How do I track down this error??? A first chance exception of type System.Runtime.InteropServices.C
    ... Back once again with a problem that prohibits me from adding records to an Access database. ... I get this error "A first chance exception of type 'System.Runtime.InteropServices.COMException' ... but I don't know how to access HRESULT. ... Private Sub BI_Process ...
    (microsoft.public.dotnet.languages.vb)
  • Syntax error with Access database
    ... Changes can be made to the dataset text boxes with no problems but I get a syntax error attempting to update or insert into a Access database. ... bLoading = True dsGRAD.GRADUATE.CleardaGRAD.Fill ... The syntax error generated is identical to the error message mentioned in the message from Dustin Wilson dated 12 Aug 2005 to this group with the exception of the different names and locations of the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: insert a data record into a data table of a access database(mdb)
    ... > Is there any better menthod to insert a data record into an access database> table? ... >> authorking, ... >> Does it give any more information than that in the exception? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: insert a data record into a data table of a access database(mdb)
    ... Is there any better menthod to insert a data record into an access database ... > Does it give any more information than that in the exception? ... > stack (for example, it was a COM error code that was returned, what is ...
    (microsoft.public.dotnet.languages.csharp)