Re: Pragmatically compact and repair database

From: Bonj (a_at_b.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 19:12:50 +0100

Access needs to be installed on whatever computer is running the program
that does the compacting. Whether this is the server itself, or a client PC
accessing the server over a file share, it doesn't matter what actual hard
disk the .mdb is on. This is because you can't do it via SQL, you have to
use Access's automation objects.

"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:116A9947-2CF9-47F4-9E2B-37D0337E3E4E@microsoft.com...
> With my vb6 app, I want to send a command to compact and repair an
access2000 .mdb database stored on a server. Will this work if access is not
installed on the server or the client computers were the vb6 app resides on.
>
> Also, how or were can I find out how I can pragmatically add a data field
to a table in the access2000 database
>

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: What doesnt lend itself to OO?
    ... > rather than client code. ... no way to do that without also touching the object with clock semantics ... will not encapsulate both clock semantics and network semantics. ... The server can do whatever it wants ...
    (comp.object)
  • RE: Fax monitor incoming + outgoing calls?
    ... problem between the client computer and the SBS server. ... Client is using the internal IP address of the SBS server as the ... To the folder redirection GPO issue: ...
    (microsoft.public.windows.server.sbs)