Re: access 2002 vba compact-repair permissions

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 12:08:51 -0500

madhouse wrote:
> Hi
> Am running application.compactrepair (source,dest,logfile) from VBA.
> This is available to users, however it appears that only the database
> owner user can run it successfully. Is this the case?

Give your user groups open exclusive permission on the database. 

-- 
Joan Wild
Microsoft Access MVP

Relevant Pages

  • Re: Merging content from access
    ... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
    (microsoft.public.word.docmanagement)
  • Re: Possible Project Bug: All Projects in Database are Deleted upon Save
    ... best practices and Project VBA ... > Only Project1 is saved into the database. ... >> prompts with Append or overwrite message. ... >> For Microsoft Project companion projects, ...
    (microsoft.public.project.vba)
  • Re: What happens when data in control is updated
    ... When I developed my concept database file I tended to look at what ... changes expected appearing on the form itself) and not going through the VBA ... > if the primary key field is Text data type, rather than numeric, the ... >>> make sure that a requery is necessary to achieve whatever your aim is. ...
    (microsoft.public.access.formscoding)
  • Re: Forms not saving
    ... I must have had some VBA code attached to these forms somewhere along the way ... Make sure the folder where your database reside is added to the trusted ... Office Button | Access Options | Trust Center | Trust Center Settings ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • RE: Each month for a query
    ... "madhouse" wrote: ... > You might like to take a look at the datediff function. ... >> I have a database with month,day,year. ... What do I put in my criteria? ...
    (microsoft.public.access.queries)
Loading