• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 444
  • Last Modified:

Changing table design in .adp file

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!
0
printmedia
Asked:
printmedia
  • 2
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You can do it through Access; an adp is a native interface directly into SQL (just like SSMS is).

Jim.
0
 
printmediaAuthor Commented:
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?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Yep and yep.   From within Access, it's just like you were working inside SQL Server Management Studio.

Might want to do a quick read of the following, which gives you an overview:

http://office.microsoft.com/en-us/access-help/about-an-access-project-adp-HP005273103.aspx

Jim.
0
 
printmediaAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now