Using Access 2003 with SQL Server with SDE

Background: I'm new at SQL Server (no experience, zip, nada) but
getting pretty good with developing applications in Access(VBA) and in
VB using ADO....

Currently I use access to and GIS software to build data management
systems. I have become pretty proficient in programming these systems
in Access but a client would like their system to be on an existing SQL
server using SDE.

I understand one way to go would be to develop the GUI in VB and hit
the SQL server using ADO which I have worked with in the past but
really only 3 or 4 tables out of the 35 or so really need to be used by
the GIS thus only 3 or 4 tables really need to be on the SQL server.

My question is: can I use Access as the front end for all my imports,
queries, and other system code and then when it comes time to write the
final tables that the GIS hits write those tables to the SQL server.
Also I would like to access the SQL Server tables though Access. I
would like ant help on the subject or any links to recourses that could
help me in deciding which direction to go...

Thanks,
Chuck

forget about using MS Access and SDE. Access is too poor and buggy (this
is desktop database system not sql server) and can be used for simple
desktop using but not to keep GIS data into it.

/Peter