Error - Please Help!

[Textatello]

Good afternoon guys,

So, I am currently working on a project with a fellow colleague and we are close to completion but have just encountered a strange error. Please take into consideration that we are both learning and fairly new to Access. Only now is my knowledge starting to broaden outside the basics.

BARE IN MIND: The database is sitting on a network drive and is shared by multiple users.

So, we have a form acting as a Main Menu. On this form we have a button called 'Add'. This button has a Macro assigned OnClick to open the form. The error pops up when multiple users are using the database.

This is the error I receive:
"You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later."

Now this is very strange to me, as I'm purely guessing but Access is thinking that I'm opening this form in design view, when I'm not. I'm simply opening the form to begin inputting as if I am a normal user.

Any ideas? When I am the only user connected to the database, the error message does not pop up and opens the form first time. If someone else is connected to the database and I try and open the form, I receive the above error message. After clicking OK on the error multiple times the form will eventually open up and allow the user to input. Which will in fact function and save perfectly.

Any help will be greatly appreciated! I have ran out of ideas and am unable to find anyone with a similar problem.

Thanks in advanced!

 

[missinglinq]

BARE IN MIND: The database is sitting on a network drive and is shared by multiple users.

Therein lies your problem! Having multiple users sharing a single, non-split database, sitting on a network drive, is the sure way to repeated episodes of corruption, as well as speed and timing problems, such as you're now experiencing! Multiple users simply have to work off of a split database, with each user having their own copy of the Front End, which contains everything except the data/tables, on their respective hard drives, and a Back End with only the Tables on a shared drive.

Being in forced retirement, I spend 8-10 hours a day here and on other Access forums/newsgroups, and over the past ten years have seen literally hundreds of reports of non-split apps causing these kind of problems! The really insidious thing is that a non-split app can work for extended periods of time before the troubles begin! But once it does, they become chronic, which is to say they occur over and over and over again!

Here are two tutorials on Splitting a Database:

https://www.fmsinc.com/microsoftaccess/DatabaseSplitter/

http://www.hitechcoach.com/index.php?option=com_content&view=article&id=35:split-your-access-database-into-application-anddata&catid=24:design

This is not a 'this is the 'best way,' this is the only way if you want to avoid major problems, including those you've already experienced!

Linq ;0)>

 

[Textatello]

I mean no harm in saying this but...

I'm sure I have seen this message before when searching this error. I have successfully split the database but am still interested in knowing 'why' the error occurred.

Also, a quick question...

"Show All Actions" is greyed out in the Macro Designer. Does anyone know why? This is only happening in my current database, if I open a new database and try it works fine?

Thanks in advanced.

 

[arnelgp]

have you set the (BE) Open Mode of the database to Shared, Default Record Locking: No Locks.
On Client setting, Options of Ribbon.

 

[Textatello]

have you set the (BE) Open Mode of the database to Shared, Default Record Locking: No Locks.
On Client setting, Options of Ribbon.

It was automatically setup like that.

Default open mode:
SHARED

Default record locking:
NO LOCKS


This is very frustrating as I need to access the extra action commands as I am yet to learn VBA. For now I am forced to deal with Macros. I'm aware that you are able to use SetProperty which is initially the same as SetValue.

What would you recommend doing if when I am inputting the expression for example txtDropDown but it's not automatically showing up? As if it doesn't exist?! Sorry for all these questions.

 

[arnelgp]

What would you recommend doing if when I am inputting the expression for example txtDropDown but it's not automatically showing up? As if it doesn't exist?! Sorry for all these questions.

what do you mean. please clarify the steps.

 

[Textatello]

Apologies for the confusion.

When creating an IF function in the Macro Designer. Normally, as you input an Object or Field name, before completing said name, Access 2010 will automatically finish the rest of the expression.

Let's say I have a fieldname called "Brand". When inputting the name "Brand" I could get half way with "Bra..." and Access will nicely give me the option to press ENTER and it will fill in the rest and even close the [ ] for me.

Unfortunately, along with my "Show All Actions" this feature also seems to be disabled. Access should auto-populate it for me, but doesn't. Do you have any ideas on why this feature is no longer happening?

Please advise me if my explanation is not brief enough.

 

[arnelgp]

is the database you are working on made from previous version that you have?
do you marked the location of the db on Trusted Location?
Is it .accde or .accdr?
Have you tried Saving As... to new .accdb (2007-and up)?