J
John Walker
Hi,
One of our customers provided us with an Access program to which they need
us to make some modifications. The database is SQL server. In order to run
program a shortcut link has been provided with this command:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
C:\Inquiry\Inquiry2K.mdb /wrkgrp "c:\inquiry\inquiry2k.mdw"
When I execute this command, I am prompted with a logon screen where I
provide the username and password and when I click OK I am brought to a form
called "Main Switchboard", and everything works fine. (In Tools/Startup in
Design Mode, "Main Switchboard" set as the "Display Form/Page").
But, I need to execute this program from Design Mode because I need to add
some breakpoints for debugging. When I do an Open on the form "Main
Switchboard" I am prompted with a SQL login screen. I know the password so I
enter it, but then I get the error:
Run-time error '3021':
No current record.
I need to run this is debug-mode. Would someone please help learn how to do
this?
Thanks,
John
One of our customers provided us with an Access program to which they need
us to make some modifications. The database is SQL server. In order to run
program a shortcut link has been provided with this command:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
C:\Inquiry\Inquiry2K.mdb /wrkgrp "c:\inquiry\inquiry2k.mdw"
When I execute this command, I am prompted with a logon screen where I
provide the username and password and when I click OK I am brought to a form
called "Main Switchboard", and everything works fine. (In Tools/Startup in
Design Mode, "Main Switchboard" set as the "Display Form/Page").
But, I need to execute this program from Design Mode because I need to add
some breakpoints for debugging. When I do an Open on the form "Main
Switchboard" I am prompted with a SQL login screen. I know the password so I
enter it, but then I get the error:
Run-time error '3021':
No current record.
I need to run this is debug-mode. Would someone please help learn how to do
this?
Thanks,
John