Slow performance after replication

[Guest]

I have replicated a data base so that I can take a replica home and work on
the data and the data base. The problem is that the forms became VERY slow
to load after replication. Some forms can take up to three minutes to load
can anyone shed light on why this may be and how I can solve it?

 

[Lynn Trapp]

You are NOT replicating your forms, are you? Replication is designed for
DATA ONLY.

 

[Tony Toews]

I have replicated a data base so that I can take a replica home and work on
the data and the data base. The problem is that the forms became VERY slow
to load after replication. Some forms can take up to three minutes to load
can anyone shed light on why this may be and how I can solve it?

To add to Lynn's posting. Have you split the MDB into a FE/BE? You
likely haven't. If you do the split then you can work on the FE
elsewhere and do updates much easier.

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.. It also supports Terminal Server/Citrix quite nicely.

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

 

[Guest]

Well . . . Yes I am. I had not gotten to the point of creating FE/BE. I
still have to get data into the system. The database forms are a work in
progress. I would like to change forms at home (less distraction) and
synchronize back at work. No can do??? Sometimes I also enter data from
home. My home is not connected to a VPN so that I could access the data at
work.

Have I damaged things irretrevably? I have been living with slow forms for
a while until I can figure out the "safe" fix.

 

[Lynn Trapp]

The database forms are a work in

progress. I would like to change forms at home (less distraction) and
synchronize back at work. No can do???

No can do via Access Replication. You should only replicate Data. The way to
do what you want is simply take an unreplicated copy of the database home,
do what work you need on the forms then, when you get back to work, import
the forms into the version you are using at work. It's just as fast as , or
faster than, replication and much safer.

Have I damaged things irretrevably?

Unknown. Replication of database objects CAN cause corruption but it doesn't
always happen. I would just cease and desist while you have the chance.

 

[Guest]

Hello Tony

Sorry If I am budding in here, but this topic is of interest to me as I am
trying to split my companies data base into a front end and back end.

I am able to split the data base into two using the wizrd with no problems,
I then place the back end , (which i believe contains the data bases tables
only) into a share drive (Drive G I then attempted to copy the front end of
the data base to my computers C:\Program Files\Data Base (which worked)

I assume that I need to launch the data base by opening the file that I
pasted into the above mentioned folder??? I did this and created a dummy
entry. It saved ok as far as I could see, however I checked the back end file
(took a look at the "Data Entry" table) however the dummy file did not
appear??!! :-(

Do I need to link the front end and back end some how?? I was looking at
"Tools\Data Base Utilities\Linked Table Manager. Is this where I link the the
FE & BE???

Forgive the questions, I have been given the mighty task of splitting the
data base, however this is all VERY new to me.

If you can respond in plain english, I would be most greatfull.

Thanking you in advance..

Regards

Sam

 

[Tony Toews]

Sorry If I am budding in here, but this topic is of interest to me as I am
trying to split my companies data base into a front end and back end.

Not a problem. Butting in is fine although you are also welcome to
start a new thread.

Do I need to link the front end and back end some how?? I was looking at
"Tools\Data Base Utilities\Linked Table Manager. Is this where I link the the
FE & BE???

You are correct. You need to relink your FE to the BE on your server.

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