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 / Forms / December 2007

Tip: Looking for answers? Try searching our database.

executing code on access forms on different pc's

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Patrick - 10 Dec 2007 07:34 GMT
We have several access databases that we used without any problems for years.
All databases are in access2003 format and have forms with VB code behind it.

recently we are getting new PC's that cannot execute the forms in (MDE
version) databases. It reports missing references. Opening the MDB version is
no problem but then it cannot be opened on the older PC's anymore. Both old
and new PC's have Office 2003 installed and are running XPSP2. The missing
references are 3 files:
Comct232.ocx
Comdlg32.ocx
mscomct2.ocx

Does anyone know where these files come from? Could they belong to office97?
All old PC's migrated from office97 to 2003.

It's strange that running the same software on same platform can case this
behaviour.

Patrick Delisse
Douglas J. Steele - 10 Dec 2007 11:42 GMT
> We have several access databases that we used without any problems for
> years.
[quoted text clipped - 18 lines]
> It's strange that running the same software on same platform can case this
> behaviour.

Actually, it's not that surprising. Whoever developed the application chose
to use references over and above the basic ones associated with Access.
Whenever you do that, you run the risk of incurring problems with the
References collection, as you are. The probability of problems increases
significantly if differently software gets installed.

The three controls you mention are actually part of the operating system,
although you technically need a Developer product (VB, Office Developer or
something else) in order to add them to an application.

Are you saying that opening the MDBs on the new machines works? If so,
simply create new versions of the MDEs. Your application should be split
into a front-end (containing the queries, forms, reports, macros and
modules), linked to a back-end (containing the tables and relationships).
Only the back-end should be on the server: each user should have his/her own
copy of the front-end, ideally on his/her hard drive. In that way, you
simply have to ensure that each user has whichever version of the front-end
works for his/her machine.

Signature

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

Patrick - 10 Dec 2007 11:59 GMT
> > We have several access databases that we used without any problems for
> > years.
[quoted text clipped - 37 lines]
> simply have to ensure that each user has whichever version of the front-end
> works for his/her machine.

Doug,
Thanks for the quick reply.
The databases where build by me years ago and are used on a daily basis.
With the migration from access 97 to 2003 we had no problems.
The databases are set-up as you indicated, with a front-end and a back-end
part.
Both front-end and back-end are on the server. This way I can update the
front-end MDE and don't have to bother with getting the new front-end version
distributed to the users (approx. 65 PC's)
Is there a way to analyze what control/command uses witch reference?
Because all of the commands are as far I can tell basic access functions. I
might be able to get rid of all non-access references.

Patrick Delisse
DutchAero
Douglas J. Steele - 10 Dec 2007 22:00 GMT
If you have the MDB, you can try removing the three references and then
compiling to see what code breaks.

Your logic, though, for having the front-end on the server is faulty.
Sharing a front-end database is a good way to cause corruption. You also
cause significantly more network traffic if the front-end is on the server.

Take a look at the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm That provides you with a way to
ensure that each user has a copy of the current front-end in place on
his/her hard drive.

Signature

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

> Doug,
> Thanks for the quick reply.
[quoted text clipped - 13 lines]
> Patrick Delisse
> DutchAero
Patrick - 11 Dec 2007 15:57 GMT
Thanks,
That helped. Found out that the references where not used at all !!!
For the front-end to local I used the method descibed in
http://www.databasejournal.com/features/msaccess/article.php/3286111
Got a few done now and it's looking good.

Patrick Delisse
 
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.