Up dateing Front end in runtime

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chasday - 16 Jan 2008 19:13 GMT

I'm am working with the code Steve Schapel has at
http://accesstips.datamanagementsolutions.biz/versions.htm
to automatically update a front end. I have it working great until I convert
the front end to runtime by changing the extention to .accdr (in Access 2007)

The I get a error
"... cannot open this file ... file was converted to runtime br changing
it's extention to .accdr. This file will only open when Access is in runtime
mode..."

I'm guessing the problem is in the code to open the local front end

LocalFile = CurrentProject.Path & "\PMG Proposals.accdr"
CmdToOpen = """" & SysCmd(acSysCmdAccessDir) & "Msaccess.exe""" & " """ &
LocalFile & """"
Shell CmdToOpen, vbNormalFocus

Help?

Reply to this Message

Dave - 17 Jan 2008 23:43 GMT

isn't there a command line option to run access in runtime mode??

> I'm am working with the code Steve Schapel has at
> http://accesstips.datamanagementsolutions.biz/versions.htm
[quoted text clipped - 17 lines]
>
> Help?

Reply to this Message

Dave - 17 Jan 2008 23:49 GMT

there it is... in older versions add /runtime to the command line and it
starts in runtime mode. see if putting that after your msaccess.exe part of
the command gets rid of that message.

> isn't there a command line option to run access in runtime mode??
>
[quoted text clipped - 19 lines]
>>
>> Help?

Reply to this Message

chasday - 18 Jan 2008 01:48 GMT

I tried that, no dice.

> there it is... in older versions add /runtime to the command line and it
> starts in runtime mode. see if putting that after your msaccess.exe part of
[quoted text clipped - 23 lines]
> >>
> >> Help?

Reply to this Message

Alex Dybenko - 18 Jan 2008 15:07 GMT

Hi,
should work, see:
http://blogs.msdn.com/clintcovington/archive/2007/02/23/tips-and-tricks-for-desi
gning-forms-and-reports-with-access-2007.aspx

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

>I tried that, no dice.
>
[quoted text clipped - 29 lines]
>> >>
>> >> Help?

Reply to this Message

Visitbazaar Info - 13 Feb 2008 03:56 GMT

Visitbazaar.com is a secure online shopping mall where you can shop over 200
stores and save up to 60% and more with coupons, deals and discounts. Since
October of 2007, we have helped many customers save money on products &
services ranging from arts and crafts to web services. At Visitbazaar.com,
we are strongly committed to keeping our online mall a safe place to shop
at, and to help our customers save money on a wide selection of products &
services.

My Window is a browser application which increases the internet browsing
speed by applying various compression techniques and protocol optimization.
Reduces the upload and download time in FTP. To switch on MyWindow feature,
log on Visitbazaar.com now.

Regards
Visitbazaar Info

Reply to this Message