Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

accessing access

ResolvedVersion 2007

Nancy has attended:
Access Introduction course
Access Intermediate course

Accessing access

Today we have had a problem with more than one person being able to access the database.
When I am in the database, and my colleague tries to look something up he gets a message saying something like 'the administrator has put this database into a state where it cannot be accessed' (or words to that effect).
Why is this happening? We have been able to have more than one person in it before, just that no changes can be made. In fact today my colleague was in it and then I went in fine, although I couldn't save any changes until he came out.
Please enlighten!
Thanks!

RE: Accessing access

Hi Nancy

Before I make suggestions for solving this problem could you please answer some questions.

How are accessng the database, through a desktop icon or opening the database from within access?

Do I nderstand correctly that if you are not the first one into the database you can both open the database?

Do you have login or security on the database?

Regards

Laura GB

RE: Accessing access

Hi Nancy,

As this question has been left unanswered for over a month, the system will automatically mark this query as resolved in the next 5 days if we don't hear from you.

If you still require assistance with this query, please post a reply and we will assist you further.

Thank you.

Rich

RE: Accessing access

Hi Rich,
we access the database from within Access. I'm not sure whether it makes a difference whether I am in first or not.
Thanks
Nancy

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.