Upsizing Question

[dogman01]

I have upsized my database to a sql server and kept the mdb file to work from. I see that there are now 2 copies of each table. 1 is a local copy and the other and odbc copy. If I want to modify or add a field in a table do I use the local copy because opening the odbc copy tells me I cannot modify. The only issue is if I modify the local table the changes are not reflected in the odbc table. Am I supposed to upsize each time I make a table change because using the linked table wizard does not make the needed changes to the odbc. Thanks

 

[KenHigg]

I'm guessing you need to use the SQL Server system tools to modify SQL objects like tables, etc.