Re: Compacting an Access database with DAO

John L. wrote:
We have a few databases with linked tables to SQL Servers and when we
attempt to compact these databases by programmatically, it fails due
to SQL Server login information. I understand that you cannot use
Microsoft Access to compact and repair a SQL Server database

True. there is no such thing as compacting a SQL Server database. Sure,
a database can vbe shrunk, but it's not a recommended action to perform.
Databases should be allowed to grow to the size they need to be.

, but we
do have some native Access tables + forms/reports etc within the
database; which we would like to compact and repair. Is there a work
around for this?

You may have noticed that this is an ADO group, not a DAO group, so we
probably won't be able to provide as indepth help as you would like. You
might try the VBADAO group in the Access hierarchy under Office
Solutions.

I'm not sure what you are actually trying to do. Are you saying that
compacting the Access database fails because you haven't provided login
information for linked tables? If so, I'm at a loss - you should run
this by the Access experts.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)
  • Re: Multiuser Interface on shared servicer with SQL Backend
    ... I agree with Tony that this doesn't look like a SQL Server issue at ... The database has been placed in a state by user 'Admin' on machine [computer ... file present in the same folder as the FE MDB/MDE with the same name. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: data connection of .net Framework & .net Compact Framework
    ... I've created an SQL Server database and I've created a smart device ... the SQL Express database directly from the mobile device. ... PC app that reads from data from Express and creates the SQL Compact ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Multiuser Interface on shared servicer with SQL Backend
    ... front-end, and that they have only ONE intance of it open on their pc. ... I agree with Tony that this doesn't look like a SQL Server issue at ... The database has been placed in a state by user 'Admin' on machine [computer ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem on acces database
    ... Try compacting the database by using the ISQLWCE tool that should be ... you can compact the database from managed code or from eVB ... SQL Server CE Query Analyzer is a graphical tool included in Microsoft® SQL ... see Installing SQL Server CE Query Analyzer. ...
    (microsoft.public.sqlserver.ce)