I am using Access97 in a Novell environment.
I created a mde database called Projects.mde that resides on our network and all the users access it from there. (the database is NOT a front end_back end db)
Then i created a different database called Manager.mdb on a Windows NT server. The Manager database is only for managers, but the employees need to see some data for their use, so i went into the Projects.mde database and created a link to about 5 tables in the Managers database.
Users of the Projects database are now complaining that the whole database is VERY slow now.
Will just having the linked tables cause the whole database to be slow even if the users don't open the form that use the linked tables?
For example, all users for the Projects database use a form called Day1 whose recordsource is a local table. But, at the bottom of Day1, there are two combo boxes whose recordsources come from queries that come from the linked tables. There is also a command button on Day1 that opens a form whose recordsource is based on the linked tables and displays data based on the values of the two combo boxes.
Will just opening the Day1 form cause the database to slow down even if the user doesn't touch the combo box or the command button?
if so, how can i speed up the database. now it is taking about 2 minutes for a form to open!
yikes!
thanks,
Ruth
I created a mde database called Projects.mde that resides on our network and all the users access it from there. (the database is NOT a front end_back end db)
Then i created a different database called Manager.mdb on a Windows NT server. The Manager database is only for managers, but the employees need to see some data for their use, so i went into the Projects.mde database and created a link to about 5 tables in the Managers database.
Users of the Projects database are now complaining that the whole database is VERY slow now.
Will just having the linked tables cause the whole database to be slow even if the users don't open the form that use the linked tables?
For example, all users for the Projects database use a form called Day1 whose recordsource is a local table. But, at the bottom of Day1, there are two combo boxes whose recordsources come from queries that come from the linked tables. There is also a command button on Day1 that opens a form whose recordsource is based on the linked tables and displays data based on the values of the two combo boxes.
Will just opening the Day1 form cause the database to slow down even if the user doesn't touch the combo box or the command button?
if so, how can i speed up the database. now it is taking about 2 minutes for a form to open!
yikes!
thanks,
Ruth