Hi,
First time on the forums - so please correct me if I'm posting in the wrong place etc.
I have constructed an Access 2010 database on windows 7 used by 5 people in a corporate environment. I split the database into a front end and back end to enable users to write the queries on their front end located on the desktop. This also enable easier updates to the back end tables.
This works extremely well in the office, but when people are working remotely over VPN, we start to get the much dreaded "system resource exceeded" on our front end databases.
I have broken all connections and loaded all of the tables locally on my front end DB, and my queries run without issue. This led me to believe the database structure is not the problem, it's the fact I have split the database for use over VPN.
I have a few ideas - none of them terrific for dealing with this issue. I am loathe to get corporate IT involved. Has anyone else encountered this problem?
Thanks in advance.
First time on the forums - so please correct me if I'm posting in the wrong place etc.
I have constructed an Access 2010 database on windows 7 used by 5 people in a corporate environment. I split the database into a front end and back end to enable users to write the queries on their front end located on the desktop. This also enable easier updates to the back end tables.
This works extremely well in the office, but when people are working remotely over VPN, we start to get the much dreaded "system resource exceeded" on our front end databases.
I have broken all connections and loaded all of the tables locally on my front end DB, and my queries run without issue. This led me to believe the database structure is not the problem, it's the fact I have split the database for use over VPN.
I have a few ideas - none of them terrific for dealing with this issue. I am loathe to get corporate IT involved. Has anyone else encountered this problem?
Thanks in advance.
