Hi,

I have two databases, One database checks the version number of the other 
one and updates the database accordingly.

I have it working on my developers machine. However, when i go over to a 
users machine who does not have a developers environment, they only have 
run time access on their machine, my command line no longer works.

What i have is one database (e.g.Event Management) that has new versions 
on a regular basis. The command line on this fires off my Version Update 
Database, the version update database only contains 1 module and 1 
autoexec macro. What is suppose to happen is that the Event Management 
command line fires up the version update database and checks the details 
and then copies the latest version of the event management database to  
the users local drive.

The shortcut does work because it works on my developer enviroment, 
however when i put it on a non-developer enviroment (i.e. pcs that dont 
have access except for Run Time Access) then the command line fires up my 
version update database but does not run the autoexec macro and gives me 
an Action Failed error.

I tried using a start up form and firing of my module in the Version 
Update Database from the Load Event but it still failed.

any ideas.
Alankar

Hi try second copy 2000 ; www.centered.com

-----Original Message-----
From: Alankar Trivedi [mailto:alankar.trivedi@i...]
Sent: Monday, September 23, 2002 12:38 PM
To: Access
Subject: [access] Runtime Command Line


Hi,

I have two databases, One database checks the version number of the other 
one and updates the database accordingly.

I have it working on my developers machine. However, when i go over to a 
users machine who does not have a developers environment, they only have 
run time access on their machine, my command line no longer works.

What i have is one database (e.g.Event Management) that has new versions 
on a regular basis. The command line on this fires off my Version Update 
Database, the version update database only contains 1 module and 1 
autoexec macro. What is suppose to happen is that the Event Management 
command line fires up the version update database and checks the details 
and then copies the latest version of the event management database to  
the users local drive.

The shortcut does work because it works on my developer enviroment, 
however when i put it on a non-developer enviroment (i.e. pcs that dont 
have access except for Run Time Access) then the command line fires up my 
version update database but does not run the autoexec macro and gives me 
an Action Failed error.

I tried using a start up form and firing of my module in the Version 
Update Database from the Load Event but it still failed.

any ideas.
Alankar

Whats second copy 2000


> Hi try second copy 2000 ; www.centered.com

-----Original Message-----
From: Alankar Trivedi [mailto:alankar.trivedi@i...]
Sent: Monday, September 23, 2002 12:38 PM
To: Access
Subject: [access] Runtime Command Line


Hi,

I have two databases, One database checks the version number of the other 
one and updates the database accordingly.

I have it working on my developers machine. However, when i go over to a 
users machine who does not have a developers environment, they only have 
run time access on their machine, my command line no longer works.

What i have is one database (e.g.Event Management) that has new versions 
on a regular basis. The command line on this fires off my Version Update 
Database, the version update database only contains 1 module and 1 
autoexec macro. What is suppose to happen is that the Event Management 
command line fires up the version update database and checks the details 
and then copies the latest version of the event management database to  
the users local drive.

The shortcut does work because it works on my developer enviroment, 
however when i put it on a non-developer enviroment (i.e. pcs that dont 
have access except for Run Time Access) then the command line fires up my 
version update database but does not run the autoexec macro and gives me 
an Action Failed error.

I tried using a start up form and firing of my module in the Version 
Update Database from the Load Event but it still failed.

any ideas.
Alankar

Hi Alankar,
Can you post the code from your module?  I'm not really familiar with MDE 
versions since all of my users have full versions, but maybe seeing the 
code would be helpful.
Thanks,
Denise

> Hi,

> I have two databases, One database checks the version number of the 
other 
o> ne and updates the database accordingly.

> I have it working on my developers machine. However, when i go over to a 
u> sers machine who does not have a developers environment, they only have 
r> un time access on their machine, my command line no longer works.

> What i have is one database (e.g.Event Management) that has new versions 
o> n a regular basis. The command line on this fires off my Version Update 
D> atabase, the version update database only contains 1 module and 1 
a> utoexec macro. What is suppose to happen is that the Event Management 
c> ommand line fires up the version update database and checks the details 
a> nd then copies the latest version of the event management database to  
t> he users local drive.

> The shortcut does work because it works on my developer enviroment, 
h> owever when i put it on a non-developer enviroment (i.e. pcs that dont 
h> ave access except for Run Time Access) then the command line fires up 
my 
v> ersion update database but does not run the autoexec macro and gives me 
a> n Action Failed error.

> I tried using a start up form and firing of my module in the Version 
U> pdate Database from the Load Event but it still failed.

> any ideas.
A> lankar

Below is the code for my Version Update Database, all this contains is the 
below module and an autoexec macro to run the below code.

The command line on my Event Management Database is 
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Program 
Files\versionupdate\versionupdate.mdb"

The version update database does fire up but it does not execute the macro 
therefore the code is not executed.

Just to mention the files are not MDE files there just packaged files, 
there still MDB's, its just users only have runtime access therefore they 
cant create their own database's.




Option Compare Database
Option Explicit

Function Startup()
'This function automatically updates the local maching application on 
startup to match
'the server copy of the application when the server file date is more 
current than the local one

Dim OpenForms
Dim X
Dim LocalApp, NetworkApp, LocalFileName, strsecurityfile, strAccessPath, 
strShellPath As String
Dim strApp, strAccessPath2, strMDWfile
Dim pblstrmsgtitle

pblstrmsgtitle = "Application Update Version 1.00"
'Local machine path and ifle name information
LocalApp = "C:\Program Files\EventManagement1\EventManagement1.mdb"
LocalFileName = "EventManagement1.mdb"
strsecurityfile = "L:\IBBApps\Event Management\Security\secured.mdw"
strAccessPath = "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
strAccessPath2 = """C:\Program Files\Microsoft 
Office\Office\MSACCESS.EXE"""
strApp = """C:\Program Files\EventManagement1\EventManagement1.mdb"""
strMDWfile = """L:\IBBApps\Event Management\Security\secured.mdw"""

'server path information
NetworkApp = "L:\IBBApps\Event 
Management\Versionupdate\EventManagement1.mdb"

    'check to see if the directory contains the file
    If Dir(LocalApp) = LocalFileName Then
        'check to see if the network app is more current than the local app
        'if it is the network app file is copied to the local machine to 
update it
        If FileDateTime(LocalApp) < FileDateTime(NetworkApp) Then
            MsgBox "There is a new version of the database on the server, 
please wait until it has been copied. Please click ok.", vbOKOnly + 
vbInformation, pblstrmsgtitle
            OpenForms = DoEvents
            FileCopy NetworkApp, LocalApp
            MsgBox "The Database has now been copied please click ok to 
enter the Application", vbOKOnly, pblstrmsgtitle
        End If
    Else
    'if the file is not in the directory it copied from the network and 
placed in the directory
        OpenForms = DoEvents
        FileCopy NetworkApp, LocalApp
    End If
    
    strShellPath = strAccessPath2 & " " & strApp & " /wrkgrp" & strMDWfile
    Shell strShellPath, vbMaximizedFocus
    Quit
    
End Function





> Hi Alankar,
C> an you post the code from your module?  I'm not really familiar with 
MDE 
v> ersions since all of my users have full versions, but maybe seeing the 
c> ode would be helpful.
T> hanks,
D> enise

> > Hi,

> > I have two databases, One database checks the version number of the 
o> ther 
o> > ne and updates the database accordingly.

> > I have it working on my developers machine. However, when i go over to 
a 
u> > sers machine who does not have a developers environment, they only 
have 
r> > un time access on their machine, my command line no longer works.

> > What i have is one database (e.g.Event Management) that has new 
versions 
o> > n a regular basis. The command line on this fires off my Version 
Update 
D> > atabase, the version update database only contains 1 module and 1 
a> > utoexec macro. What is suppose to happen is that the Event Management 
c> > ommand line fires up the version update database and checks the 
details 
a> > nd then copies the latest version of the event management database 
to  
t> > he users local drive.

> > The shortcut does work because it works on my developer enviroment, 
h> > owever when i put it on a non-developer enviroment (i.e. pcs that 
dont 
h> > ave access except for Run Time Access) then the command line fires up 
m> y 
v> > ersion update database but does not run the autoexec macro and gives 
me 
a> > n Action Failed error.

> > I tried using a start up form and firing of my module in the Version 
U> > pdate Database from the Load Event but it still failed.

> > any ideas.
A> > lankar