• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Replication problems with MS Access

I am working with a database, let's call it "X" that is saved on the network. I wanted to make some changes to the design of the main form in the database. Because I am new to Access, I copied this database onto my hard drive to have a copy to play with before making changes to the "master" that still resides on the network. Unfortunately, now I open up the copy of the database now on my hard drive, let's call it "y", and I can look at the form but I can't get into design view. I don't know what the problem is. When I use the "Database X" on the network, I am able to get into the design view of the form; sometimes I get the error that I don't have exclusive database at this time and that changes could not be saved. Does this have anything to do with the problem? Please advise. Why can't I get into design view for the main form of database y on my hard drive. Thanks.
1 Solution
arainaAuthor Commented:
Please let me know if there is additional information needed to answer this question.
Is the database part of a replica & part of a replica-set? If so, you won't be able to edit any of the design unless you're working from the Design Master.

Is security setup on the database? If so, copy the Workgroup Information file (*.mdw) to your local disk, join the workgroup & logon as normal. If you still can't edit the design, you don't have rights to do so - get your Database Administrator to assign you those rights.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now