turn off warning message in mde

N

Novice User

Hi

I hope someone can tell me how to do this. I have an append query that runs
when I open a form. While working with the full version of Access (ver 2002)
I have turned off the warnings for action queries - but when I create the mde
I get the warning using the Access Viewer.

Also, is there a way for the MDE to retain the login information so the user
doesn't have to type it? My report is linking to my accounting tables vie
obdc so I have to type a user id (no password) to login in - can this be
automated?

Thanks for your help
 
A

Albert D. Kallal

There are two solutions that I often use to solve this problem:

1), in place of docmd.RunSql, use

currentdb.Execute strSql

2) simply execute a set warnings command right before you run the runSql.

eg:
DoCmd.SetWarnings False

DoCmd.RunSQL "drop table qtemp"

MySql = "SELECT * INTO qtemp FROM qryDestSeats where " & buildwhere
DoCmd.RunSQL MySql

DoCmd.SetWarnings True

For the most part, I now use the currentDb.Execute method...
 
N

Novice User

Thank you for your reply - it is not the network login, but the login for the
Accounting software package that I am linking to.
 
K

Klatuu

You could still use the API to determine who is logged on.
Then create a table with userID and the accounting package login. Then you
call use a DLookup to find the password for the user who is logged in.
 
A

Albert D. Kallal

Novice User said:
Thank you for your reply - it is not the network login, but the login for
the
Accounting software package that I am linking to.

Hum, I think in this case, I would simply store this info in a table.
Perhaps even a one record table. That way, you make the box that prompts the
user as a bound form to a table. If the form is bound then next time the
user opens that form, the old informaton will be retained....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top