Re: Access (office 2003) will not let me save any designs to reports / forms

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 01/19/05 

Date: Tue, 18 Jan 2005 23:51:23 -0800

Hi, Phil.

Do you have VBA code that opens another database file in the default
workspace? This will cause your database to migrate to shared mode (even if
you opened it exclusively), preventing the temporary promotion to exclusive
mode necessary for saving major changes.

You may want to use Microsoft's LDB Viewer to examine at what point the
database becomes shared (i.e., at open, after a certain form is opened,
after a certain command button is clicked, et cetera). Most likely the
"other user" is you, so this tool will confirm the current user name and the
computer name of all users connected to the database file. Please see the
following Web page for links to the LDB Viewer and other free diagnostic
tools in the "Free Microsoft Access Troubleshooting Tools" section:

http://www.Access.QBuilt.com/html/links.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Phil" <phillip@pmassociates.com.au> wrote in message
news:lv2su09ooghq45goevtt0dfoe7d6sijvf2@4ax.com...
> HI, thanks for reply and info.
> No I didn't name them the same, now this gives me something to work
> on.
>
> Cheers
> Phil
> On Tue, 18 Jan 2005 01:06:09 -0800, "'69 Camaro"
> <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SPAM> wrote:
>
> >Hi, Phil.
> >
> >> I cannot design or
> >> change any reports / forms, I can change them, just that Acess tells
> >> me off saying I do not have exclusive access. (database is not open by
> >> anyone else while I'm doing this)
> >
> >Did you name the workgroup information file with the same base name as
the
> >database file and place it in the same directory? (For example,
> >Employees.MDB and Employees.MDW.) Both files will open their own locking
> >database (*.LDB) files if they are located in different directories. If
> >located in the same directory, there will be two users listed in the same
> >*.LDB file, indicating that the database is shared, not exclusive.
> >
> >If this is the case, either rename the workgroup information file
(perhaps
> >Secured.MDW) or place it in a different directory.
> >
> >HTH.
> >
> >Gunny
> >
> >See http://www.QBuilt.com for all your database needs.
> >See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> >
> >(Please remove ZERO_SPAM from my reply E-mail address, so that a message
> >will be forwarded to me.)
> >
> >
> >"Phil" <phillip@pmassociates.com.au> wrote in message
> >news:toipu05pfs6b600lkm8hounucageprk5bp@4ax.com...
> >> Hi, is there a quick fix around this.
> >>
> >> I have a database which I have on a Windows 2003 server
> >> I created an admin user / workgroup in it by what I feel is now the
> >> wrong thing to do.
> >> As server user's permissions will control who gets access to what on
> >> the database.
> >>
> >> Now even if I log into server as administrator, I cannot design or
> >> change any reports / forms, I can change them, just that Acess tells
> >> me off saying I do not have exclusive access. (database is not open by
> >> anyone else while I'm doing this)
> >> Same thing happens if I put database on my xp system.
> >>
> >> What should I be looking for or what should I do to fix this?
> >>
> >> Thanks in advance
> >>
> >> Phil
> >>
> >> phillip(nospam)@pmassociates.com.au
> >> remove (nospam)
> >>
> >
>

Relevant Pages

  • RE: Exclusivity
    ... Omitting the command line switch /excl opens the Access database file in ... shared mode. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.modulesdaovba)
  • Re: GT.M V5.3-004 released
    ... Documentation tab to get to a page from which all user documentation ... data in database and journal files. ... On UNIX/Linux platforms, the database file size limit has been ... size, the largest database file that can be created is 1,792GB. ...
    (comp.lang.mumps)
  • Re: FrontPage security / writing to an Access database file
    ... I think if you do tools/ web settings/ database ... > database etc) I need to be able to write data to the database file. ... > script is by using the control panel to set the following IUSR permissions ... > POST commands from annonymous users but have contacted the hosting company ...
    (microsoft.public.frontpage.client)
  • RE: "Exclusive Access" (or lack thereof) suddenly an issue
    ... Via Windows Explorer navigate to the folder where your database file ... Microsoft Access Support ...
    (microsoft.public.access.gettingstarted)
  • Re: Converting from 2003 to 2007
    ... making changes to the structure of the database, like I would see in 2003 ... The other is the switchboard opens to be full screen in size rather than ... One is when I double click the database file it opens in the mode for ... Open the code window ...
    (microsoft.public.access.formscoding)