Prev: Recommended UK companies for migrating from Access to SQL
Next: Use TextBox on the main form to limit SubForm
From: clk on 6 Jul 2010 10:28
I have a mde database file developed for a client. This was
originally set up and run in Access 2003. Everything worked fine.
Recently this client purchased several new computers. These computers
came with Access 2007. Now whenever an Access 2007 user opens the
database, it locks the database for all other users. I have checked
all the Access settings I know to check. These new machines are also
running Windows 7. I am not sure if this is enough information or if
anyone has seen this behavior and may have some suggestions.

Any help is appreciated.
From: Jörn Bosse on 6 Jul 2010 10:42
Hello,

open the options -> clientsettings and scroll down to advanced and check if
the db opens exclusiv or approved.
If exclusiv is selected you have to change this.

--
Hope to Help - J�rn


From: clk on 6 Jul 2010 12:33
On Jul 6, 10:42 am, Jörn Bosse <joernbo...(a)gmx.de> wrote:
> Hello,
>
> open the options -> clientsettings and scroll down to advanced and check if
> the db opens exclusiv or approved.
> If exclusiv is selected you have to change this.
>
> --
> Hope to Help - Jörn

Thanks for the suggestion. I had already checked those settings and
it is set up to open shared not exclusive. Any other thoughts are
appreciated.
From: Jörn Bosse on 6 Jul 2010 12:52
Hello,

is your db compiled?
Did you split your app into front-/backend?


--
Hope to Help - J�rn


From: Douglas J. Steele on 6 Jul 2010 13:12
Where is the database located? Does the user have the necessary permissions
on that folder?

Does it make a difference if you right-click on msaccess.exe and select to
Run As Administrator? If so, try right-clicking on the shortcut and looking
at its Properties. Go to the Shortcut tab, click Advanced, and check the
"Run As Administrator" check box.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"clk" <c.kurutz(a)comcast.net> wrote in message
news:88a0f4ee-ef24-4ee4-891a-7ef41d1d1f03(a)q12g2000yqj.googlegroups.com...
>I have a mde database file developed for a client. This was
> originally set up and run in Access 2003. Everything worked fine.
> Recently this client purchased several new computers. These computers
> came with Access 2007. Now whenever an Access 2007 user opens the
> database, it locks the database for all other users. I have checked
> all the Access settings I know to check. These new machines are also
> running Windows 7. I am not sure if this is enough information or if
> anyone has seen this behavior and may have some suggestions.
>
> Any help is appreciated.


 |  Next  |  Last
Pages: 1 2
Prev: Recommended UK companies for migrating from Access to SQL
Next: Use TextBox on the main form to limit SubForm