Deploy MS Access for new bee!

[MMM]

Hi all,
I am brand new to Access so please help.
I will develope FE using MS Access 2K , the database
stored in SQL2K.
How can I:
- When I am done to create a new .mdb (or .adp) file then
how can I give to the user? (.exe of MDE ?)
- The user required to connect to SQL server through my
program (MS Access I did).
- Too complicate with MS Access, do I need to prefer to
use different application? Cause of I am very confuse with
Access.
Thanks for any help,
MMM

 

[Chris]

When I am done to create a new .mdb (or .adp) file then how can I give to
the user? (.exe of MDE ?)

You can't do a .exe. If the user doesn't have Access, then you will need to
provide a runtime version. For more information, see:
http://www.mvps.org/access/general/gen0001.htm


The user required to connect to SQL server through my program (MS Access I
did).

Any linked tables, queries, or ADO will require SQL Server login information
(Server, Database, User, Password).
If you know these, hard code them in. Or, better yet, store the information
in a table and use that to connect with. If the user has
to provide a username/password, then trying to open a table will prompt them
for that information.


Too complicate with MS Access, do I need to prefer to use different
application? Cause of I am very confuse with Access.

If Visual Basic, C++, Delphi, etc. comes easier, then use them. If you
don't have experience with any development platform, then Access is a good
place to start.