Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Tue, 6 Nov 2007 10:02:10 -0800,    group: microsoft.public.sqlserver.odbc        back       


adding new tables after ODBC linking   
Hi,

I have an Access2003 database -- which I upsized to sqlServer 2005 -- as 
linked ODBC tables

I have numerous access forms I would like to continue to use for quick data 
entry -- for the time being.

Is it possible to add a new table in Access (or in SQLServer) and then 
depending on which route I go either:

1) if created in access, upsize that table to the existing SQL2005 database
2) if created in SQLServer -- import it into my linked ODBC access

Or do I have to delete the SQL DB and re-upsize the whole thing??

thanks for any help
date: Tue, 6 Nov 2007 10:02:10 -0800   author:   thersitz

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us