<div>
You can do it through Access; an adp is a native interface directly into SQL (just like SSMS is).<br />
<br />
Jim.
</div>


You can do it through Access; an adp is a native interface directly into SQL (just like SSMS is).

Jim.

<div>
Oh ok, so once I add a field to a table or delete the field from a table it will automatically appear in the database on SQL Server?<br />
<br />
Does this also apply when I create a table in the adp file, will it automatically show up in SQL Server?
</div>


Oh ok, so once I add a field to a table or delete the field from a table it will automatically appear in the database on SQL Server?

Does this also apply when I create a table in the adp file, will it automatically show up in SQL Server?

<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
I need to add a field to a table in an Access .adp file as well remove a field from another table. But I don't know if I need to do that from within the .adp file or on the SQL Server 2000 database? <br />
<br />
I've never worked with .adp files, I usually work with a .mdb file and the tables (which are on SQL Server) are linked into the Access database.<br />
<br />
Thank you in advance!
</div>
</div>


Hi all.

I need to add a field to a table in an Access .adp file as well remove a field from another table. But I don't know if I need to do that from within the .adp file or on the SQL Server 2000 database? 

I've never worked with .adp files, I usually work with a .mdb file and the tables (which are on SQL Server) are linked into the Access database.

Thank you in advance!

Changing table design in .adp file

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.