By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 1,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

sql server tables modification

P: n/a
Im new to access+sql server.
I know i can easy export my access database to sql server. But is it
possible to easy modify data structure on sql server from acc(adding
deleting field, modifying forms). I mean is it possible to modify
database so i dont have to export it again? i really appreciate your
help, any links to sollution appreciated.
Martin
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use SQL Server's T-SQL language (Data Definition Language: DDL) to
modify the database.

Read a book on Database Design, it will explain how databases are
created/altered using DDL.

You must have permission to alter the db's structure. If using DAO from
Access you can use pass-thru queries to modify the db's structure. If
using ADO from Access you'll have to use VBA to run the DDL commands
(I'd use the Connection object & the adCmdText parameter).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQUx2rYechKqOuFEgEQL4ZwCg8D916bBv5Rtw/27IsnBEgdHXpmsAniQ4
6MeLOZNCPJ7Lz0CQnY09W7Av
=TQ26
-----END PGP SIGNATURE-----
Marcin Siewiera wrote:
Im new to access+sql server.
I know i can easy export my access database to sql server. But is it
possible to easy modify data structure on sql server from acc(adding
deleting field, modifying forms). I mean is it possible to modify
database so i dont have to export it again? i really appreciate your
help, any links to sollution appreciated.
Martin


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.