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 / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

Access Runtime

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J. Trucking - 05 Sep 2007 15:46 GMT
Hello,

I just had a quick question about Access Runtime.  I have a database
which I have built and I would like to distribute it to a few users.
I split the database and made an mde file for the front end.  I then
put a copy of this mde file on each users work station with the back
end on the server.  Each of the work stations I put the MDE on has
Access Runtime installed on it because these workstations already run
another database.  The install of runtime and the other database were
done before my time here.  What I am wondering is if Runtime only
needs to be installed on the machine once or if it needs to be
packaged with every DB that is on the machine.  After copying the MDE
file to the workstation and double clicking it, I get an error message
stating that I have an "unrecognizable format".  I understand about
runtime having issues when using different versions of office but I do
know that we are running office 2003. Thanks in advance for any tips
regarding using runtime.

Thanks,

John.
Pieter Wijnen - 05 Sep 2007 16:51 GMT
When using runtime (and otherwise for that matter) it's best to create a
proper shortcut

target:
<path to msaccess.exe> <path to database> /wrkGrp<path to system.mdw>

HTH

Pieter

> Hello,
>
[quoted text clipped - 17 lines]
>
> John.
J. Trucking - 05 Sep 2007 17:04 GMT
Hi Peter,

I've seen some posts on this.  Would I just create this in the
properties of the file and include a portion to launch runtime?

Thanks for the help,

John
Pieter Wijnen - 05 Sep 2007 19:53 GMT
Standard Windows Shortcut (on the start menu)

Pieter

> Hi Peter,
>
[quoted text clipped - 4 lines]
>
> John
Tony Toews [MVP] - 20 Sep 2007 22:53 GMT
>I just had a quick question about Access Runtime.  I have a database
>which I have built and I would like to distribute it to a few users.
[quoted text clipped - 6 lines]
>needs to be installed on the machine once or if it needs to be
>packaged with every DB that is on the machine.

Installing the runtime once is all that is required.

>After copying the MDE
>file to the workstation and double clicking it, I get an error message
>stating that I have an "unrecognizable format".  I understand about
>runtime having issues when using different versions of office but I do
>know that we are running office 2003.

But maybe the runtime is A2000 or A2002.  Right click on the
msaccess.exe found on the work station and determine the version
number.  It should be 11.something to be the A2003 runtime.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 
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.