Re: Database Split and Linked Table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Take a look at the Auto FE Updater Tony Toews has (for free) at
http://www.granite.ab.ca/access/autofe.htm

Believe us when we tell you that it is far superior for each user to have
his/her own copy of the front-end on his/her hard drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"jeannette_rivera" <jeannetterivera@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:8BCE96DD-EA4F-473A-9295-31967D1212CC@xxxxxxxxxxxxxxxx
I really appreciate you're trying to help with this thing but having a copy
of the FE on each machine didn't help me at this point. Just because the
FE
is changing so quickly, it will be harder or even imposible to keet all
the
machines updated always. The FE is used by several machines in different
branches. By puting the FE in the server help me to have all the machines
updated at the same time.

I know what we want to do is not always the same way to do things,
specially
when I don't have enough experience programming but still think there
should
be a way to have this fix without putting a copy on each pc. To avoid
this
is why we use servers and networking.

Please, still need your help to have this solved.

"Jerry Whittle" wrote:

Each user should have a copy of the FE on their machine. That should
increase
performance. Also it might solve the problem you are having.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"jeannette_rivera" wrote:

But, if I made changes and install the new one in a server. It has the
same
name and target as the original. The users only have a shortcut to the
FE
database not a copy in their machines. This is what they have and they
were
working OK before the split but now they can't see the info on the
combo
boxes attach to a table that's in the BE.

Will appreciate your help.

Jeannette

"Jerry Whittle" wrote:

The Linked Table Manager only needs to be run once. The other users
need
their own copy of the new FE database and they all should be linked
to the
same BE .mdb file.

If you make a change to the FE, you need to give a copy to all users.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"jeannette_rivera" wrote:

Hi all:

I have a database created to be small but it grew and I used the
Database
Splitter and Linked Table Manager. It works perfectly in the PC it
is
install but, other PC's have a shurtcut to this database. They can
open and
use the db but in some forms there are combo boxes looking to
tables and when
the other users try to look at those fields, anything shows.

Can you please help me fix this in the other machines? Should I
run the
linked table manager in all the PCs? Do I need to do something
special every
time there is an update to the forms or the tables in all the pc
having the
shortcut?

I'm asking because usually I work the changes from home and then
copy the
new database in the same folder with the same name to avoid redo of
the
shortcut.

Greatly appreciate your help.


.

Relevant Pages

  • RE: Database Split and Linked Table
    ... The FE is used by several machines in different ... "Jerry Whittle" wrote: ... The users only have a shortcut to the FE ... database not a copy in their machines. ...
    (microsoft.public.access.setupconfig)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • Re: Large Database System
    ... add database capabilities to the data files that are being processed. ... Because of the sheer number of machines involved in computations we ... Reliability is always an issue. ... You do know that SQLite is a single user database? ...
    (comp.lang.c)
  • Re: Problem with Standard Functions
    ... Are they all sharing the same database, Mark? ... Doug Steele, Microsoft Access MVP ... > As the machines acted up I removed library references which initially ...
    (microsoft.public.access.formscoding)
  • VM in 2.6 doing a worse job of caching than 2.4?
    ... day by a proprietary database system. ... I recently started evaluating the 2.6 kernel for these machines. ... and see's CPU idle of 30-35%. ... Theoretically, they both should receive similar traffic, though the load ...
    (comp.os.linux.development.system)