Command Button Problem

[Carrie]

Hello

I have just created a database which is now in use. However there is one issue that keeps arising. I have set up a startup form and from this the user chooses an area of the database they wish to go to. For example if they wish to setup a job they go to the form Setup Job. Once finished they can press a command button called return to main menu, which should close the Setup Job form and return them back to the startup form. The problem is that sometimes it works fine, but it seems that most of the time when the user presses the return to main menu the database takes a long, long time to react or it crashes. Does anyone have any ideas?
The start up form will always be open until the user exits the database so all that should be happening is that the user is just closing the Setup job form.

I have compiled and saved all modules and eveything is ok. i just don't understand why it works one minute and not the next.

Any guidance would be much appreciated
Carrie

 

[SQL_Hell]

Hi Carrie,

Have you tried compacting and repairing the database?

Is this database split into a front and backend?

 

[Carrie]

Hello

Thanks for your reply!
Yes I've compacted and repaired but it makes no difference.

It is a split database. The table are on the network and eveyone has a copy on their C drive of the front end.

I was wondering if it was a server problem but I don't seem to have this problem on other similar forms used by other departments.

I use to have the same problem with the Exit database command button as well. It use to crash when people pressed the button but the coding was what had been provided by the access wizard!

Carrie

 

[SQL_Hell]

Just as a test,

create a new front end and import all the objects form the old front end into it, then see if this fixes the problem.


Also what version of Access, do all copies have the service packs applied?


I take it every user has their own log on and password? how many users?

 

[Carrie]

Hi thanks for your reply

I've already tried creating a new front end and it didn't work. Have just tried again and it still doesn't work!!

Everyone does have their own log in and password.

The only issue may be the service packs. I use Access 97 and I know that I am on SR1. I also know that other people are on SR2 as they have older computers. Will this make a difference? I did try and get my boss to update everyones computers as I am not allowed to. Unfortunately he thinks it's all a waste of time so did one computer and then gave up!

We have 9 users using the part of the database which is having problems- they don't use the database on a regular basis- maybe once a day if they need to book a job onto the system. In addition there are another 5 users using other parts of the database. They use it daily most of the time and they have not mentioned any problems.

Hope this helps and thanks for your time
Carrie