I have just installed Office 2007 on several PCs in a remote office. They
are having issues with opening access databases on the server in the main
office. Nothing on the network has changed and the databases open up fine
when using Office 2000. Any ideas as to what could be causing this would be
greatly appreciated.

Jennifer

Define problems, have you setup security in 2007 so the database is in a
trusted location?
"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:ED639A29-1BA0-42CC-9417-06391CD38DCA@microsoft.com...
>I have just installed Office 2007 on several PCs in a remote office. They
> are having issues with opening access databases on the server in the main
> office. Nothing on the network has changed and the databases open up fine
> when using Office 2000. Any ideas as to what could be causing this would
> be
> greatly appreciated.
>
> Jennifer

Access quits responding and it takes up to five minutes for the database to
come up. Then it takes another five minutes to try to access something.
Even when closing, it takes forever... sometimes quits responding.

Yes, I have added the folder to the truste locations. It didn't help. We
do use .mdw files as this database was created in Access 2000.

If I copy the database and .mdw file to a server in the remote office, it
works fine. It also appears to be a problem with larger databases. The
smaller ones seem to work OK.

"Pete D." wrote:

> Define problems, have you setup security in 2007 so the database is in a
> trusted location?
> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> news:ED639A29-1BA0-42CC-9417-06391CD38DCA@microsoft.com...
> >I have just installed Office 2007 on several PCs in a remote office. They
> > are having issues with opening access databases on the server in the main
> > office. Nothing on the network has changed and the databases open up fine
> > when using Office 2000. Any ideas as to what could be causing this would
> > be
> > greatly appreciated.
> >
> > Jennifer
>
>
>

Make sure name autocorrect is turned off under datafile options, check that
all have read/right/execute to location on the server where file is stored.
Make sure when everyone exits the file the .ldb file goes away. Read
http://www.granite.ab.ca/access/perf...ldblocking.htm

Post back any changes. Pete

"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:9F437F9E-7E84-49AA-A473-78002AB7D0C5@microsoft.com...
> Access quits responding and it takes up to five minutes for the database
> to
> come up. Then it takes another five minutes to try to access something.
> Even when closing, it takes forever... sometimes quits responding.
>
> Yes, I have added the folder to the truste locations. It didn't help. We
> do use .mdw files as this database was created in Access 2000.
>
> If I copy the database and .mdw file to a server in the remote office, it
> works fine. It also appears to be a problem with larger databases. The
> smaller ones seem to work OK.
>
> "Pete D." wrote:
>
>> Define problems, have you setup security in 2007 so the database is in a
>> trusted location?
>> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>> news:ED639A29-1BA0-42CC-9417-06391CD38DCA@microsoft.com...
>> >I have just installed Office 2007 on several PCs in a remote office.
>> >They
>> > are having issues with opening access databases on the server in the
>> > main
>> > office. Nothing on the network has changed and the databases open up
>> > fine
>> > when using Office 2000. Any ideas as to what could be causing this
>> > would
>> > be
>> > greatly appreciated.
>> >
>> > Jennifer
>>
>>
>>

I have checked the security and the web site you suggested. The only thing
that has changed is Access 2000 vs Access 2007. When I open the database in
Access 2000, it works fine. When I open the database in Access 2007, it is
extremely slow. There must be some change in 2007 that is causing this.

"Pete D." wrote:

> Make sure name autocorrect is turned off under datafile options, check that
> all have read/right/execute to location on the server where file is stored.
> Make sure when everyone exits the file the .ldb file goes away. Read
> http://www.granite.ab.ca/access/perf...ldblocking.htm
>
> Post back any changes. Pete
>
> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> news:9F437F9E-7E84-49AA-A473-78002AB7D0C5@microsoft.com...
> > Access quits responding and it takes up to five minutes for the database
> > to
> > come up. Then it takes another five minutes to try to access something.
> > Even when closing, it takes forever... sometimes quits responding.
> >
> > Yes, I have added the folder to the truste locations. It didn't help. We
> > do use .mdw files as this database was created in Access 2000.
> >
> > If I copy the database and .mdw file to a server in the remote office, it
> > works fine. It also appears to be a problem with larger databases. The
> > smaller ones seem to work OK.
> >
> > "Pete D." wrote:
> >
> >> Define problems, have you setup security in 2007 so the database is in a
> >> trusted location?
> >> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> >> news:ED639A29-1BA0-42CC-9417-06391CD38DCA@microsoft.com...
> >> >I have just installed Office 2007 on several PCs in a remote office.
> >> >They
> >> > are having issues with opening access databases on the server in the
> >> > main
> >> > office. Nothing on the network has changed and the databases open up
> >> > fine
> >> > when using Office 2000. Any ideas as to what could be causing this
> >> > would
> >> > be
> >> > greatly appreciated.
> >> >
> >> > Jennifer
> >>
> >>
> >>
>
>
>

Did you turn off autocorrect? This is a big hit and 2007 default is on.
See Allen Brown response in

Re: Access 2007 kills Access 2003

In

microsoft.public.access


"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:DEC55418-DC0D-49F4-819E-293E3AF9EDA5@microsoft.com...
>I have checked the security and the web site you suggested. The only thing
> that has changed is Access 2000 vs Access 2007. When I open the database
> in
> Access 2000, it works fine. When I open the database in Access 2007, it
> is
> extremely slow. There must be some change in 2007 that is causing this.
>
> "Pete D." wrote:
>
>> Make sure name autocorrect is turned off under datafile options, check
>> that
>> all have read/right/execute to location on the server where file is
>> stored.
>> Make sure when everyone exits the file the .ldb file goes away. Read
>> http://www.granite.ab.ca/access/perf...ldblocking.htm
>>
>> Post back any changes. Pete
>>
>> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>> news:9F437F9E-7E84-49AA-A473-78002AB7D0C5@microsoft.com...
>> > Access quits responding and it takes up to five minutes for the
>> > database
>> > to
>> > come up. Then it takes another five minutes to try to access
>> > something.
>> > Even when closing, it takes forever... sometimes quits responding.
>> >
>> > Yes, I have added the folder to the truste locations. It didn't help.
>> > We
>> > do use .mdw files as this database was created in Access 2000.
>> >
>> > If I copy the database and .mdw file to a server in the remote office,
>> > it
>> > works fine. It also appears to be a problem with larger databases.
>> > The
>> > smaller ones seem to work OK.
>> >
>> > "Pete D." wrote:
>> >
>> >> Define problems, have you setup security in 2007 so the database is
>> >> in a
>> >> trusted location?
>> >> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>> >> news:ED639A29-1BA0-42CC-9417-06391CD38DCA@microsoft.com...
>> >> >I have just installed Office 2007 on several PCs in a remote office.
>> >> >They
>> >> > are having issues with opening access databases on the server in the
>> >> > main
>> >> > office. Nothing on the network has changed and the databases open
>> >> > up
>> >> > fine
>> >> > when using Office 2000. Any ideas as to what could be causing this
>> >> > would
>> >> > be
>> >> > greatly appreciated.
>> >> >
>> >> > Jennifer
>> >>
>> >>
>> >>
>>
>>
>>

Yes, autocorrect is turned off. Where is Allen Brown's response located?

"Pete D." wrote:

> Did you turn off autocorrect? This is a big hit and 2007 default is on.
> See Allen Brown response in
>
> Re: Access 2007 kills Access 2003
>
> In
>
> microsoft.public.access
>
>
> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> news:DEC55418-DC0D-49F4-819E-293E3AF9EDA5@microsoft.com...
> >I have checked the security and the web site you suggested. The only thing
> > that has changed is Access 2000 vs Access 2007. When I open the database
> > in
> > Access 2000, it works fine. When I open the database in Access 2007, it
> > is
> > extremely slow. There must be some change in 2007 that is causing this.
> >
> > "Pete D." wrote:
> >
> >> Make sure name autocorrect is turned off under datafile options, check
> >> that
> >> all have read/right/execute to location on the server where file is
> >> stored.
> >> Make sure when everyone exits the file the .ldb file goes away. Read
> >> http://www.granite.ab.ca/access/perf...ldblocking.htm
> >>
> >> Post back any changes. Pete
> >>
> >> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> >> news:9F437F9E-7E84-49AA-A473-78002AB7D0C5@microsoft.com...
> >> > Access quits responding and it takes up to five minutes for the
> >> > database
> >> > to
> >> > come up. Then it takes another five minutes to try to access
> >> > something.
> >> > Even when closing, it takes forever... sometimes quits responding.
> >> >
> >> > Yes, I have added the folder to the truste locations. It didn't help.
> >> > We
> >> > do use .mdw files as this database was created in Access 2000.
> >> >
> >> > If I copy the database and .mdw file to a server in the remote office,
> >> > it
> >> > works fine. It also appears to be a problem with larger databases.
> >> > The
> >> > smaller ones seem to work OK.
> >> >
> >> > "Pete D." wrote:
> >> >
> >> >> Define problems, have you setup security in 2007 so the database is
> >> >> in a
> >> >> trusted location?
> >> >> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> >> >> news:ED639A29-1BA0-42CC-9417-06391CD38DCA@microsoft.com...
> >> >> >I have just installed Office 2007 on several PCs in a remote office.
> >> >> >They
> >> >> > are having issues with opening access databases on the server in the
> >> >> > main
> >> >> > office. Nothing on the network has changed and the databases open
> >> >> > up
> >> >> > fine
> >> >> > when using Office 2000. Any ideas as to what could be causing this
> >> >> > would
> >> >> > be
> >> >> > greatly appreciated.
> >> >> >
> >> >> > Jennifer
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

http://www.microsoft.com/communities...xp=&sloc=en-us

"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:F166A662-617D-4456-9896-E10245B2DA63@microsoft.com...
> Yes, autocorrect is turned off. Where is Allen Brown's response located?
>
> "Pete D." wrote:
>
>> Did you turn off autocorrect? This is a big hit and 2007 default is on.
>> See Allen Brown response in
>>
>> Re: Access 2007 kills Access 2003
>>
>> In
>>
>> microsoft.public.access
>>
>>
>> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>> news:DEC55418-DC0D-49F4-819E-293E3AF9EDA5@microsoft.com...
>> >I have checked the security and the web site you suggested. The only
>> >thing
>> > that has changed is Access 2000 vs Access 2007. When I open the
>> > database
>> > in
>> > Access 2000, it works fine. When I open the database in Access 2007,
>> > it
>> > is
>> > extremely slow. There must be some change in 2007 that is causing
>> > this.
>> >
>> > "Pete D." wrote:
>> >
>> >> Make sure name autocorrect is turned off under datafile options, check
>> >> that
>> >> all have read/right/execute to location on the server where file is
>> >> stored.
>> >> Make sure when everyone exits the file the .ldb file goes away. Read
>> >> http://www.granite.ab.ca/access/perf...ldblocking.htm
>> >>
>> >> Post back any changes. Pete
>> >>
>> >> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>> >> news:9F437F9E-7E84-49AA-A473-78002AB7D0C5@microsoft.com...
>> >> > Access quits responding and it takes up to five minutes for the
>> >> > database
>> >> > to
>> >> > come up. Then it takes another five minutes to try to access
>> >> > something.
>> >> > Even when closing, it takes forever... sometimes quits responding.
>> >> >
>> >> > Yes, I have added the folder to the truste locations. It didn't
>> >> > help.
>> >> > We
>> >> > do use .mdw files as this database was created in Access 2000.
>> >> >
>> >> > If I copy the database and .mdw file to a server in the remote
>> >> > office,
>> >> > it
>> >> > works fine. It also appears to be a problem with larger databases.
>> >> > The
>> >> > smaller ones seem to work OK.
>> >> >
>> >> > "Pete D." wrote:
>> >> >
>> >> >> Define problems, have you setup security in 2007 so the database
>> >> >> is
>> >> >> in a
>> >> >> trusted location?
>> >> >> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>> >> >> news:ED639A29-1BA0-42CC-9417-06391CD38DCA@microsoft.com...
>> >> >> >I have just installed Office 2007 on several PCs in a remote
>> >> >> >office.
>> >> >> >They
>> >> >> > are having issues with opening access databases on the server in
>> >> >> > the
>> >> >> > main
>> >> >> > office. Nothing on the network has changed and the databases
>> >> >> > open
>> >> >> > up
>> >> >> > fine
>> >> >> > when using Office 2000. Any ideas as to what could be causing
>> >> >> > this
>> >> >> > would
>> >> >> > be
>> >> >> > greatly appreciated.
>> >> >> >
>> >> >> > Jennifer
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

I do have the same problem here. No problems with Office 97, 2000, XP, 2003.
With Access 2007 everything is acceptable when the database is local, but
painfully slow over network. Nothing change in the settings of the server!
They changed Access 2007 jet engine and probably screw it! Stop taking us for
newbie and saying that our computer is broken! If I switch back to Office
2003 everything is fine. Autocorrect is turn off, I've tried all the things
on granite web site. Everything that will come into your mind, I've tried!!!
We want a fix for Microsoft access 2007 slowness over network :@

novacrash <novacrash@discussions.microsoft.com> wrote:

>I do have the same problem here. No problems with Office 97, 2000, XP, 2003.
>With Access 2007 everything is acceptable when the database is local, but
>painfully slow over network. Nothing change in the settings of the server!
>They changed Access 2007 jet engine and probably screw it! Stop taking us for
>newbie and saying that our computer is broken! If I switch back to Office
>2003 everything is fine. Autocorrect is turn off, I've tried all the things
>on granite web site. Everything that will come into your mind, I've tried!!!
>We want a fix for Microsoft access 2007 slowness over network :@

Does this involve Windows Vista systems?

http://msmvps.com/blogs/access/archi...-database.aspx

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/