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 / New Users / October 2005

Tip: Looking for answers? Try searching our database.

Question about References

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe Cilinceon - 30 Oct 2005 23:28 GMT
I wish to compress a 2002 version front end DB by creating a new DB and then
importing all the forms and such from the old DB. Now I notice that it
doesn't carry any of the reference over that are setup in the original DB.
Is there something I'm missing or do you just have to go in the Reference
section and re select each time.

Signature

Joe Cilinceon

Rick Brandt - 30 Oct 2005 23:40 GMT
> I wish to compress a 2002 version front end DB by creating a new DB
> and then importing all the forms and such from the old DB. Now I
> notice that it doesn't carry any of the reference over that are setup
> in the original DB. Is there something I'm missing or do you just
> have to go in the Reference section and re select each time.

Yep. References are carried over when you convert a file from an older version,
but not when you import all objects.

(not a good idea  to have any non-default references anyway).

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Joe Cilinceon - 30 Oct 2005 23:44 GMT
>> I wish to compress a 2002 version front end DB by creating a new DB
>> and then importing all the forms and such from the old DB. Now I
[quoted text clipped - 6 lines]
>
> (not a good idea  to have any non-default references anyway).

The only ones I have is for Word and Excel so not a big deal. Thanks Rick

Signature

Joe Cilinceon

david@epsomdotcomdotau - 31 Oct 2005 03:58 GMT
> The only ones I have is for Word and Excel so not a big deal.

Those are exactly the ones you should consider not having.

They are fairly stable, so you don't need early binding to check that the
entry points haven't changed.

But they may crash your entire application if they aren't present, or are
the wrong version, or have been installed in a different folder, or have an
obscure registration problem.

Presumably, we aren't talking about an MDE, so if your application is only
installed on your own PC, or you have a really firm SOE policy, or if you
are making frequent changes to the Word/Excel automation code, you have fair
reason to include the Word and Excel references.

If not, you have fair reason to consider using late binding instead.

(david)

> >> I wish to compress a 2002 version front end DB by creating a new DB
> >> and then importing all the forms and such from the old DB. Now I
[quoted text clipped - 8 lines]
>
> The only ones I have is for Word and Excel so not a big deal. Thanks Rick
 
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.