accessing access

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Accessing access

Accessing access

resolvedResolved · High Priority · Version 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:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips


Server loaded in 0.09 secs.