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

database opening

Forum home » Delegate support and help forum » Microsoft Access Training and help » Database on opening

Database on opening

ResolvedVersion 2003

Sammie has attended:
Access Intermediate course
Access Advanced course

Database on opening

Hi,
When I open a database on our server, an error message pops up saying "The database has been placed in a state by user 'Admin' on machine 'HERRADURA' that prevents if from being opened or locked."
We've already identified the machine 'HERRADURA'. So whenever that machine has the database opened, the rest of us in the team just get this error message above and don't get access to the database...
Would be great if you could have a look. It's pretty urgent since we can't get into the database but HERRADURA needs to use the database.
Thanks,
Sammie

RE: Database on opening

Hi Sammie

Thanks for your question. You may find the following information from the Microsoft support website a helpful starting point. Do speak with your IT team to make sure it applies to your circumstances (as it is described as applying to Access 2000)
http://support.microsoft.com/kb/248967
It sounds like the problem you are encountering is likely to require more specialist technical support than we are able to provide on the forum. Take a look at the Microsoft product support pages at http://support.microsoft.com/selectindex/default.aspx

Kind regards,
Andrew

Wed 3 Dec 2008: Automatically marked as resolved.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown


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.