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!
Microsoft Access
Last Comment
printmedia
8/22/2022 - Mon
Jim Dettman (EE MVE)
You can do it through Access; an adp is a native interface directly into SQL (just like SSMS is).
Jim.
printmedia
ASKER
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?
Jim.