Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / October 2004

Tip: Looking for answers? Try searching our database.

Problems with switching between forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Help - 28 Oct 2004 12:24 GMT
Hi,

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.

That aside, there are a few forms which try and position themselves
automatically when activated and deactivated. The Activate/Deactivate
event is code with various "docmd.moveto 0,0" "docmd.restore" type commands.

This seems to have generally worked ok. However, we have made a couple
of changes to the db and now, when a user switches quickly from one form
to an other, they can generate errors such as:
"You can't carry out this action at this time" or
"Application defined or object defined error"

When I choose debug, I usually, but not always am pointed at one of the
various .moveto, .restore type lines. Sometimes, no line is highlighted
and the stack is empty. In these case, I have put debug.print staments
in to see where things are getting and it is usually reaching but not
passing a docmd.restore line.

The changes we have made have no positioning changes and we haven't
adjusted anything that we can see in this area, but it seems to have
exacerbated the problem.

I understand that docmd.restore or the moveto would only be available if
the restore or move menu option is available tot he window. So, I assume
that the errors I am getting are because thes menu options aren't
available. Running through the logic of the code, however, suggests that
they should be if all is in sync.

Does anyone any ideas, hints, tips as to where to look for this .. or am
I looking at a synchronising problem within access if the users clicks
too fast. (And yes, I have asked them to click slower .. but, well, they
 are users, aren't they !)

Appreciate any suggestions...

Cheers
Brett Collings [429338] - 29 Oct 2004 12:01 GMT
>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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.