Serious slow down issues Access 2003

[mrgreen]

Hi All,

Awesome forum I'm in here all the time browsing for goodies and getting help so for that THANKS! I created a FE/BE db in Access 2003 for my work and when 1 person opens it shazaam no problems as soon as another person opens it the forms open slow and the time for reports is increased significantly.

Things I've tried

1. Placed the BE file on top folder of the network
2. Changed all the tables Subdata sheet to None
3. Created a bound form to a linked table that stays open until the file is closed - read that somewhere on the internet
4. Compacted both FE and BE files (FE is about 5.5 mb BE is about 1.5mb)
5. Disabled Track name Auto Correct info

I have made a few split databases with past emplooyers with 6 or 7 users and this has never been an issue. I need someone to talk me down from the ledge please!
What else am I missing or how can I determine if it's the network?

Thanks a bunch

 

[vbaInet]

Have a quick read. This might enlighten you:

http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[gemma-the-husky]

you have done item 3 - which often fixes the problem

the other thing is a registry entry

"sharing violation notification"

=======
look at MS knowledge base article 889588 - sorry i cant post thel ink for information. Try that.

 

[mrgreen]

Hi guys,

Thanks for the comments. I checked out both articles and for the most part I'm doing all of those things. The only things I'm not doing is creating a shortcut on the user's desktop. I'm using a .bat file to grab the updated FE on the network and pasting it the user's Desktop then it opens so he/she never really knows it updated. I have a Timer form that runs in the background that I have bound to a linked table but the field is numeric not text (not sure that makes a difference). In the article (889588) it said Use forms instead of tables when multiple users connect to the database for data entry. This was referencing the bound form to a linked table. Is this suggesting I somehow bind a form in my FE to a form in the BE? I'm certainly no Access MVP so I may need some help on that one. Thanks for the help guys I'll keep looking into it.

 

[mrgreen]

Sorry after reading the article a few more times it's just saying in a multi-user environment use forms to input data not tables. LOL I at least understand that.

 

[gemma-the-husky]

the connection to the backend works better if you maintain a permanent connection. I just declare a recordset in code, and kepp that open until the app closes. Opening a hidden form will do the same thing. However, you said it is a timer form. You may find that having a timer running is the culprit. Try it without the timer function.

That was what I meant when i referred to you doing item 3 in your list.

------------
the other thing that may make a difference is the sharing violations registry entry.

------------
other than those, i can think of what would slow the app down.