(Resolved) [Access] Access Database opening in design mode

[LittleNeutrino Veteran]

I have an Access Database that everyone was able to access last month. I then had an issue where one user was only getting what appears to be design mode, on the same PC she is able to login as another account and the database runs properly. Myself and another tested and we are not able to get it to run either. The user is on an XP machine x32 and I am on Windows 7 x64. there are still some users able to access this with no issue the last I checked. I tried copying the ODBC connections from the working user to me but it still opens the same way. Would appreciate any guidance as to what would cause this. The last time it was accessible was 7/30/2012.

Thanks,

Issue resolved, turns out there were two versions of the database a local and a lan. The LAN version was not the right version.

Edited September 26, 2012 by littleneutrino

[LittleNeutrino Veteran]

not a lot of Access users?

[Kami-]

Does this happen with all Access databases she is trying to access or just one in particular?

[LittleNeutrino Veteran]

Just this particular one.

[sc302 Veteran]

sounds like an update hosed you.

Check your macro security settings

[LittleNeutrino Veteran]

Other people can use the file just fine, (the file is hosted on a server that lots of people can access. there are currently 2 users that are unable to open it normally

[sc302 Veteran]

Ok, being that it is happening on certain profiles on certain machines but not on other profiles on the same machine, have you looked at the individual user settings like macro settings (like I mentioned before)?

[LittleNeutrino Veteran]

Yes, we have even uninstalled Office and put it back on with no resolution

[+BudMan MVC]

Do they have their shift key stuck? ;)

I believe you can open a database in design view by just holding the shift key.

[sc302 Veteran]

Uninstalling office unfortunately will not reset individual user settings in the user profile.

[LittleNeutrino Veteran]

how do you reset user settings on Access 2010?

[LittleNeutrino Veteran]

This issue is now resolved. Turned out there was a local and a lan version of the database and we were running the wrong one.

[Kami-]

  On 26/09/2012 at 20:03, littleneutrino said:

This issue is now resolved. Turned out there was a local and a lan version of the database and we were running the wrong one.

Oh dear :p