> Question is this: Access itself (the Office application) > does not have to be on the server...for basic queries > (select, insert, update, delete). But in order to do > table manipulation queries (add table, alter table, etc), > it does?
No, you don't need it for anything, I don't think. You can run SQL-DDL commands (CREATE, ALTER, DROP) through any ODBC client. You can even create new Access databases through ODBC. > What are the advantages/disadvantages of having the Access > application itself on the server? There aren't any, unless you plan to sit at the server console and use the GUI tools to design new databases. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
