Search results

I believe this observation of reduced file size is due to the format of your JET database. Is it in the Access 2002-2003 file format? See this KB article: Database bloat is not stopped by compacting database with Access 2002 format http://support.microsoft.com/?id=810415 Note also...

Hi SARK666, Sorry, I just saw your reply, when I decided to return to this thread. For whatever reason, I did not receive a notification email when you, Simon or Rx posted back. I have never witnessed a persistent connection causing a degradation in performance. How exactly did you implement...

Yes, we understand the main complaint is when subsequent users attempt to open the application, after the first user has opened the application. Trust me, this is abundently clear. A persistent connection will allow faster relinking, AND generally faster performance while using the...

Hi Gina, I would just add some to your analogy: Without a persistent connection, lock the door after each trip, and reset the security alarm system. Then, when returning with the second bag of groceries, disable the security system and unlock the door. Repeat this laborious sequence until you...

Hi Chris, Didn't you report some success?: A persistent connection is *very helpful* in speeding up shared Access applications, including relinking tables. You can run a simple experiment, timing how long it takes to relink tables with and without a persistent connection, and you should see...

Perhaps it is time to rebuild all of your BE database(s). I don't know if this will help at all, but it can't hurt to try. For each BE database that you need to rebuild, create a brand new database, then immediately disable Name Autocorrect. Then import all tables and relationships from the...

A persistent connection means that each client computer will maintain it's connection to the BE database. One easy way of doing this is to open a form, in hidden mode, that is bound to a very small table in the BE database. I think it is worth trying with a new FE/BE, such as a split Northwind...

Here is something else to try, from http: // support . microsoft . com/?id=889588: Turn off the sharing violation notification delay You can turn off the sharing violation notification delay to improve file server performance. To do this, follow these steps on the file server that stores the...

Do you have admin rights on the server box, to verify that this setting is the same as it was a year ago? It is not clear to me if you are quoting historical information, or if you have very recently verified that Oplocks has not somehow been re-enabled on this server. Sorry to sound like Mr...

Hi Chris, You made the above registry change on the server, right? Yes, this is my understanding as well, that you don't need to disable on both the server and all clients. That said, I don't think it would hurt anything to go ahead and disable the client's attempt to make the request. I...

Hi Gina, I'm actually quite interested in this thread, especially since Chris used Wireshark to do some packet sniffing. My new focus, after Access, is network troubleshooting, including wired and wireless networks. The next time you come to Seattle, I'd like to show you some "gently-used"...

Hi Chris, Try disabling OpLocks, per this KB article: Configuring opportunistic locking in Windows h t t p : / / support . microsoft . com / kb / 296264 Note: This system made me remove links, since I have less than 10 posts to this forum. So, just remove the spaces in the above URL...

Please show the entire procedure that you are using. Do you have any On Error Resume Next statements in this procedure? If so, comment these out and try running the code again. Have you tried adding similar code to output to a Snapshot file in the Northwind sample database? Does this work...

Hi Russell, The new report layout view in Access 2007--I think that's what they call it--does not run any code associated with the report's class module. Is this the view that you might have used? In addition, is your database in a trusted folder? Dealing With The Trust Center...