Access Application

[Guest]

I have a start up form that when a user clicks a button it runs several
queries that clear table, append data, create tables and then launch a report.

Everything works fine on me desktop.

I send the database to someone else and he receives several message box
such as

cannot find the dsn
you are about to run a make table query
you are about to paste 70 records etc.

I have 2 tables that I am linking to from a sql server. When, I did the
link I checked the "save password" box. This works fine on my pc. I can
create a dsn on the user pc - unless I can do it in code?

I also tried to create an MDE file but the button is grayed out.

Any suggestions to make this database run without the user having to answer
all the message boxes is appreciated.

Thanks

 

[Guest]

for the confirmation messages add this before the queries start,
if using code:
docmd.setwarnings false

if using a macro:
-select setwarnings from macro action column, set to false (no) below

 

[Guest]

Thank you - it worked.

Do you know why the "Make MDE File" is grayed out?

 

[Guest]

Some things at least to check:

-An *.mdb database to be converted to *.mde must be open
-The *.mdb database was created with the same version of access opening it,
lets say your database *.mdb file was created with Access 2000 nad now you
open the database with Access 2003, it wont let you create the mde, if this
is the case convert your database to the same version of access
-Compile your modules prior to converting to mde to make sure there are no
coding errors, if there is at least one, Acccess wont create an mde file,