>We have started to maintain an Access/2000 database app which is running
>on a server. It is split into FE/BE but, unfortunately, the split is
>silly and there are tables in the front end which are required by
>eveyone so we can't run the FE on individual machines yet.
You have to fix that, no question ... piece of cake ...
- Copy/Paste the FE tables to the BE
- Add a 0 (ie tblCustomer0) to each of the copied tables
- Go New->Link and point to the BE tables
- Open each to be sure it's all there
- Delete all the tables with the 0 suffix
Access will not know the difference. The programme "sees" the link
*as* the table.
That's it, all done. The rest of your problems are because a number
of users are addressing the same form at the same time and the
programme is trying to move the form on two different machines ...
impossible task. Give them all a copy of the FE.
If that's not compelling enough, I can almost guarantee that sooner or
later you will get a corrupted FE and it may or may not be
recoverable.
Short answer ... you *must* move the FE to every desktop. Nothing
else matters.
Cheers
Brett
>That aside, there are a few forms which try and position themselves
>automatically when activated and deactivated. The Activate/Deactivate
[quoted text clipped - 30 lines]
>
>Cheers
Cheers,
Brett
----------------------------------------------
Be adventurous, be bold, be careful, be a star
----------------------------------------------
Brett Collings
Business & Systems Analyst
Management Information Systems Developer
Help - 29 Oct 2004 16:12 GMT
Hi Brett,
>>We have started to maintain an Access/2000 database app which is running
>>on a server. It is split into FE/BE but, unfortunately, the split is
>>silly and there are tables in the front end which are required by
>>eveyone so we can't run the FE on individual machines yet.
>
> You have to fix that, no question ... piece of cake ...
Unfortunately not in this case ...
Don't get me wrong, I am all in favour or splitting and running on a
separate machine and I understand the risks.
This application has code that relinks various tables whilst looking for
the databases in specific places. A move to the user's machine messes
things up unfortunately. I will do it, but it needs a fair bit of code
change and testing ..
Thanks for the comments tho .. appreciated...
Cheers
> - Copy/Paste the FE tables to the BE
> - Add a 0 (ie tblCustomer0) to each of the copied tables
[quoted text clipped - 64 lines]
> Business & Systems Analyst
> Management Information Systems Developer
Help - 29 Oct 2004 16:13 GMT
Hi Brett,
>>We have started to maintain an Access/2000 database app which is running
>>on a server. It is split into FE/BE but, unfortunately, the split is
>>silly and there are tables in the front end which are required by
>>eveyone so we can't run the FE on individual machines yet.
>
> You have to fix that, no question ... piece of cake ...
Unfortunately not in this case ...
Don't get me wrong, I am all in favour or splitting and running on a
separate machine and I understand the risks.
This application has code that relinks various tables whilst looking for
the databases in specific places. A move to the user's machine messes
things up unfortunately. I will do it, but it needs a fair bit of code
change and testing ..
Thanks for the comments tho .. appreciated...
Cheers
> - Copy/Paste the FE tables to the BE
> - Add a 0 (ie tblCustomer0) to each of the copied tables
[quoted text clipped - 64 lines]
> Business & Systems Analyst
> Management Information Systems Developer