Experts Exchange connects you with the people and services you need so you can get back to work.

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!

printmedia

Asked: 2013-01-04

Advertise Here

Microsoft Access

1 Solution

LVL 59

Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented: 2013-01-04

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

Jim.

printmediaAuthor Commented: 2013-01-04

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?

LVL 59

Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented: 2013-01-04

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.

printmediaAuthor Commented: 2013-01-04

Thanks!

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.

Changing table design in .adp file

Join & Write a Comment Already a member? Login.

Featured Post