Problem with File-Connection menu item after deploying

  • Thread starter Thread starter Marcin Przybylowicz
  • Start date Start date
M

Marcin Przybylowicz

I made *.adp application with File-Connection menu item in order to change
database. So I can choose MSSQL database and work by internet. It works
properly. After using Package and Deploymet Wizard and installing
distributed
application with runtime Access File_Connection menu item doesn't work.

Please help.

Martin
 
Maybe assess is in sandbox mode.

Microsoft disallows certain unsafe expressions in office applications. What I am thinking is that maybe your code is “Unsafe” in the eyes of Microsoft. I never bothered with all that trusted application stuff and have no idea how it works with runtime.

What I have done to get around these issues in the past is to write a simple launch program in VB. I never modify a connection string, I was updating the application. If you did this I imagine you could just use the command line option to specify the connection.

I guess you could try the runtime switch on the command line for access; and see if it works for you.
 
are you deploying it via the access runtime?

do you have the menus locked down via STARTUP options??

i think that you can Docmd.RunComand acCmdShowConnectionInfo or
something along those lines

hth
 
Back
Top