Turn Startup Form Off

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm not an expert at Access and I've taken over someone else's role. I have
two problems:

1) I need to turn the startup form off when the app runs. When the app
starts up, the Access window goes away and there's just a form. I can't right
click on it or anything. I vaguely recall that there's a combination of
keystokes or keystrokes + mouse clicks that will allow me to open the Access
db in design mode. I just need to fix a query that's broken!

2) I'm not able to run the app (runs with a SQLServer backend). I keep
getting the ODBC error, Access Denied. I've emulated the previous developer's
security/user settings and I'm the administrator on my box.

Thanks in advance!!
 
Have you created an ODBC DataSource exactly the same as the previous
developer used on your PC?
 
What Van said about the ODBC stuff and to open the app in design mod hold
down the shift key while opening the app.
 
Thanks for your help! I found out that my ODBC problem was that I was
connecting to the wrong server!
 
It is easy to connect to the wrong SQL Server.

In my set-up, I have 3 different instances of SQL Servers on 2 different
servers (1 instance is a named intance). Even on 1 of the instance, I have
a production version and a test version of the database. Since the ODBC
DataSource (I have about 10) point to a particular database of a particular
SQL Instance, it is easy to use the wrong ODBC DataSource.
 
Back
Top