|
Posted by Piotr Tracz on March 15, 2005, 8:29 am
Please log in for more thread options
>
> 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...
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
| 
XML Sitemap