FE Development

[Chip]

I've asked questions about this topic in the past. I thought I was
square but somethings not right.

I have my project split into a FE and BE. The BE is located on the
server in my office. But being the total workaholic that I am, I want
to be able to take the project home with me and work on it locally on
my laptop.

I thought, that by copying my FE and a copy of my BE to my laptop, and
then using the Linked Table Manager would do the trick. I relink all
my lists to the local BE. Then when I go back into work, I relink to
the "live" data on the server and redistribute my new FE.

But now that I've done that, when I try and relink my lists to the
local copy, it says that the Path to the Live Data is non existant.
The only way that I've been able to get it to work, is for me to
exstablish my VPN to my Network connection, then it relinks.

If that was the only problem, I'd be ok.. but now, when I go to enter
the VBE or the Design view of my FE, it lags and most of fhe time,
hangs... This only happens when I'm working on my laptop remotely. It
does not happen in the office where I'm more strongly connected to the
server. For some reason, I think it still wants to connect to the
live data on the server.. What can I do to speed up the performance
on my laptop, so I can work on it here at home...

Chip

 

[Albert D. Kallal]

But now that I've done that, when I try and relink my lists to the
local copy, it says that the Path to the Live Data is non existant.
The only way that I've been able to get it to work, is for me to
exstablish my VPN to my Network connection, then it relinks.

Hum, that behavior does not sound 100% correct. Is it possible that you have
a couple of tables that are not being re-linked, and therefore pointing to
the wrong location? perhaps you deleted a table the back end, and forgot to
delete the table or link in the front end, and is still try to connect
somewhere that don't exist?

If that was the only problem, I'd be ok.. but now, when I go to enter
the VBE or the Design view of my FE, it lags and most of fhe time,
hangs... This only happens when I'm working on my laptop remotely. It
does not happen in the office where I'm more strongly connected to the
server. For some reason, I think it still wants to connect to the
live data on the server.. What can I do to speed up the performance
on my laptop, so I can work on it here at home...

As I said, this seems to suggest that some connection or something is not
being refreshed correctly.

I'm exactly the same boat as you have, and I often take a copy of both the
front, and back end home to work on, when I get back to the office, I simply
link my front end to the production backend that resides on the server at
work.

It is a little bit of work, but I would suggest you try deleting all of your
links.

Also another thing that can slow things down is when you're at home, you
have your printer pointing to something over the VPN, or just simply a
network printer that not active. This can really slow down development for
MS access, so set your default printer to local printer to alleviate this
"network" problem.

 

[Chip]

Ok.. Here I did a little digging. I deleted all my tables and
reimported them. I still have a link somewhere that is trying to
connect to my server. I've isolated it down to either one table or my
main data entry form. But I dont know how to find where that link
is. I tred running Object Dependencies, but it wasnt sucessful. It
failed becaue it to was not able to find the required link back to the
network. Other than going, item by item to find this link back to my
network, what else can I do?

 

[Albert D. Kallal]

Check for shared drives on your computer.....

ms-access gathers information about all the drives you have...and if some
are shared to your network, then that will cause activity....

The other thing was ensure your default printer is not a network printer
(and, your reports don't have the particular default printer saved with
them.

If you must, create a blank database, and import everything into that....

So, it may not be a stray table, or a link that is pointing to the wrong
place, but one of the above possible....

Also, check for mapped drives on your computer...as again that could be
source of trouble...

However, do remember that to eliminate the delays during development (or
use), simply ensure you have a persistent connection to the back end. This
will solve your delay problems. By the way, you need/want a persist
connection during use also, because it is possible that users are work are
also experiencing delays...just not as great as when you at home. So, during
use of the application, ensure a persisting connection, and also during
development.

To test this, simply open a linked table in the front end, and then minimize
that table. now, try working...you see the delays are gone...