New passtive shutdown/connection center control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We just upgraded to Access 2007 from 2000 and are running into lots of
challenges. One of the biggest is that when one person filters some records,
no one else can access the database, even after the filter person unfilters.
They have to completely close their program to allow everyone else back in.

The other challenge is the Calls button we had set up to log our phone calls
& other transaction is no longer functioning. I'm not a real technical
person, and will appreciate any help we can get.

Thank you!!
 
Sheridan HBC said:
We just upgraded to Access 2007 from 2000 and are running into lots of
challenges. One of the biggest is that when one person filters some records,
no one else can access the database, even after the filter person unfilters.
They have to completely close their program to allow everyone else back in.
Click to expand...

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.
The other challenge is the Calls button we had set up to log our phone calls
& other transaction is no longer functioning. I'm not a real technical
person, and will appreciate any help we can get.
Click to expand...

You'll have to be more specific as to your exact problem. What error
message(s) are you getting?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
you need A c c e s s D a t a P r o j e c t s


Tony Toews said:
You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.


You'll have to be more specific as to your exact problem. What error
message(s) are you getting?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Click to expand...
 
Back
Top