Home All Groups Group Topic Archive Search About

OPENFORM ACTION CANCELED....HELP!! MS ACCESS 2003

Author
17 Nov 2007 4:01 AM
bygrace
Hi, new user...not tech savvy at all.  I do transcription and recieved a
Access data via FTP file.  When I tried to select the file to open, I got
INTO the database, BUT not the EVENT, it says "openform action canceled".
when my employer sent it to someone else, they opened it fine.  PLEASE help.
I am losing money by not being able to open this file.   I am using Office
professional 2003


--
bygrace

Author
17 Nov 2007 4:43 AM
John W. Vinson
On Fri, 16 Nov 2007 20:01:00 -0800, bygrace
<bygr***@discussions.microsoft.com> wrote:

>Hi, new user...not tech savvy at all.  I do transcription and recieved a
>Access data via FTP file.  When I tried to select the file to open, I got
>INTO the database, BUT not the EVENT, it says "openform action canceled".
>when my employer sent it to someone else, they opened it fine.  PLEASE help.
>I am losing money by not being able to open this file.   I am using Office
>professional 2003

I have no idea what you mean by "the EVENT". Is this a form, or something that
you click on a switchboard, or what? What steps are you taking to generate the
error?

             John W. Vinson [MVP]
Author
17 Nov 2007 11:44 AM
bygrace
I am going to my FTP folder, right clicking, save to desktop (i've tried
opening from FTP file also).

Going to desktop, double clicking the file icon (by the way, it has a
padlock in the icon, did not have it when I tried a trial version of 2007 -
which also said "openform action canceled")

After I double click, i put in the login information and password into the
database.  I come to a "main menu" within the database.  I click select a
drop down menu, then select a file to open.  When I click "proceed" to
actually open the file, I get "openform action canceled". 
--
bygrace


Show quote
"John W. Vinson" wrote:

> On Fri, 16 Nov 2007 20:01:00 -0800, bygrace
> <bygr***@discussions.microsoft.com> wrote:
>
> >Hi, new user...not tech savvy at all.  I do transcription and recieved a
> >Access data via FTP file.  When I tried to select the file to open, I got
> >INTO the database, BUT not the EVENT, it says "openform action canceled".
> >when my employer sent it to someone else, they opened it fine.  PLEASE help.
> >I am losing money by not being able to open this file.   I am using Office
> >professional 2003
>
> I have no idea what you mean by "the EVENT". Is this a form, or something that
> you click on a switchboard, or what? What steps are you taking to generate the
> error?
>
>              John W. Vinson [MVP]
>
Author
17 Nov 2007 7:40 PM
John W. Vinson
On Sat, 17 Nov 2007 03:44:00 -0800, bygrace
<bygr***@discussions.microsoft.com> wrote:

>I am going to my FTP folder, right clicking, save to desktop (i've tried
>opening from FTP file also).

You'll certainly need to have the database (.mdb file?? .accdb? something
else?) on your local hard drive. I'd suggest putting it in a folder rather
than on your desktop but that's your choice.

>Going to desktop, double clicking the file icon (by the way, it has a
>padlock in the icon, did not have it when I tried a trial version of 2007 -
>which also said "openform action canceled")

This is probably a security issue. I don't have 2007 installed yet, so I can't
be precise on the details, but you may need to move the database to a folder
and mark that folder as a "trusted location". Try checking the suggestions on
Jeff Conrad's site:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

             John W. Vinson [MVP]
Author
17 Nov 2007 10:33 PM
bygrace
Ok, I deleted the old folder and put it in a new folder.  Same thing.  I went
onto that site and didnt find anything useful.  Please remember, I am VERY
not tech savvy.  I searched for allow *.mde files.  can't find anything.  I
didnt have any problem with Access xp
--
bygrace


Show quote
"John W. Vinson" wrote:

> On Sat, 17 Nov 2007 03:44:00 -0800, bygrace
> <bygr***@discussions.microsoft.com> wrote:
>
> >I am going to my FTP folder, right clicking, save to desktop (i've tried
> >opening from FTP file also).
>
> You'll certainly need to have the database (.mdb file?? .accdb? something
> else?) on your local hard drive. I'd suggest putting it in a folder rather
> than on your desktop but that's your choice.
>
> >Going to desktop, double clicking the file icon (by the way, it has a
> >padlock in the icon, did not have it when I tried a trial version of 2007 -
> >which also said "openform action canceled")
>
> This is probably a security issue. I don't have 2007 installed yet, so I can't
> be precise on the details, but you may need to move the database to a folder
> and mark that folder as a "trusted location". Try checking the suggestions on
> Jeff Conrad's site:
>
> Jeff Conrad's resources page:
> http://www.accessmvp.com/JConrad/accessjunkie/resources.html
>
>              John W. Vinson [MVP]
>
Author
17 Nov 2007 10:35 PM
bygrace
I deleted the old folder.  Put it in a new folder.  Still wont open,  I
searched the site you sent me, no help.  But remember, I am an at home user. 
Not tech savvy at all.

it is a *.mde file.  I did a googled "allow *.mde file.  Nothing helped. 
HELP!
--
bygrace


Show quote
"John W. Vinson" wrote:

> On Sat, 17 Nov 2007 03:44:00 -0800, bygrace
> <bygr***@discussions.microsoft.com> wrote:
>
> >I am going to my FTP folder, right clicking, save to desktop (i've tried
> >opening from FTP file also).
>
> You'll certainly need to have the database (.mdb file?? .accdb? something
> else?) on your local hard drive. I'd suggest putting it in a folder rather
> than on your desktop but that's your choice.
>
> >Going to desktop, double clicking the file icon (by the way, it has a
> >padlock in the icon, did not have it when I tried a trial version of 2007 -
> >which also said "openform action canceled")
>
> This is probably a security issue. I don't have 2007 installed yet, so I can't
> be precise on the details, but you may need to move the database to a folder
> and mark that folder as a "trusted location". Try checking the suggestions on
> Jeff Conrad's site:
>
> Jeff Conrad's resources page:
> http://www.accessmvp.com/JConrad/accessjunkie/resources.html
>
>              John W. Vinson [MVP]
>
Author
20 Nov 2007 10:49 AM
bygrace
hello again.  still can't open this file.  The "geek squad" from bestbuy is
coming on Saturday.  I'd really like to get this fixed before.  my daughter
was able to open the file from her laptop.  Can anyone help?????????? :(
--
bygrace


Show quote
"bygrace" wrote:

> I deleted the old folder.  Put it in a new folder.  Still wont open,  I
> searched the site you sent me, no help.  But remember, I am an at home user. 
> Not tech savvy at all.
>
> it is a *.mde file.  I did a googled "allow *.mde file.  Nothing helped. 
> HELP!
> --
> bygrace
>
>
> "John W. Vinson" wrote:
>
> > On Sat, 17 Nov 2007 03:44:00 -0800, bygrace
> > <bygr***@discussions.microsoft.com> wrote:
> >
> > >I am going to my FTP folder, right clicking, save to desktop (i've tried
> > >opening from FTP file also).
> >
> > You'll certainly need to have the database (.mdb file?? .accdb? something
> > else?) on your local hard drive. I'd suggest putting it in a folder rather
> > than on your desktop but that's your choice.
> >
> > >Going to desktop, double clicking the file icon (by the way, it has a
> > >padlock in the icon, did not have it when I tried a trial version of 2007 -
> > >which also said "openform action canceled")
> >
> > This is probably a security issue. I don't have 2007 installed yet, so I can't
> > be precise on the details, but you may need to move the database to a folder
> > and mark that folder as a "trusted location". Try checking the suggestions on
> > Jeff Conrad's site:
> >
> > Jeff Conrad's resources page:
> > http://www.accessmvp.com/JConrad/accessjunkie/resources.html
> >
> >              John W. Vinson [MVP]
> >
Author
20 Nov 2007 10:52 AM
bygrace
Hi again,
The Geek Squad from bestbuy is coming on Saturday, $249, plus tax.  My
daughter was able opben the database from her laptop.  I am still getting
"openform action canceled".  I would really like to get this issue resolved. 
Can anyone help???
--
bygrace


Show quote
"John W. Vinson" wrote:

> On Sat, 17 Nov 2007 03:44:00 -0800, bygrace
> <bygr***@discussions.microsoft.com> wrote:
>
> >I am going to my FTP folder, right clicking, save to desktop (i've tried
> >opening from FTP file also).
>
> You'll certainly need to have the database (.mdb file?? .accdb? something
> else?) on your local hard drive. I'd suggest putting it in a folder rather
> than on your desktop but that's your choice.
>
> >Going to desktop, double clicking the file icon (by the way, it has a
> >padlock in the icon, did not have it when I tried a trial version of 2007 -
> >which also said "openform action canceled")
>
> This is probably a security issue. I don't have 2007 installed yet, so I can't
> be precise on the details, but you may need to move the database to a folder
> and mark that folder as a "trusted location". Try checking the suggestions on
> Jeff Conrad's site:
>
> Jeff Conrad's resources page:
> http://www.accessmvp.com/JConrad/accessjunkie/resources.html
>
>              John W. Vinson [MVP]
>

AddThis Social Bookmark Button