Turn Startup Form Off

[atrapp]

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!!

 

[Van T. Dinh]

Have you created an ODBC DataSource exactly the same as the previous
developer used on your PC?

 

[Reggie]

What Van said about the ODBC stuff and to open the app in design mod hold
down the shift key while opening the app.

 

[atrapp]

Thanks for your help! I found out that my ODBC problem was that I was
connecting to the wrong server!

 

[Van T. Dinh]

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.

 

[Lynn Trapp]

"atrapp" <[email protected]>

Cousin???? <g>