We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
7 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Changing table design in .adp file
Posted on 2013-01-04
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!
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!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
Active today
You can do it through Access; an adp is a native interface directly into SQL (just like SSMS is).
Jim.
Jim.
Active today
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?
Does this also apply when I create a table in the adp file, will it automatically show up in SQL Server?
Active today
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| sIMULTANEOUS USAGE ON NETWORK-ACCESS 2010-2013 | 7 | 75 | |
| Converting Access 2016 from 32-bit to 64-bit | 8 | 56 | |
| Sharepoint list value updated via access or Excel | 3 | 31 | |
| Create two calculated fields in a table based on one field entered | 4 | 38 |
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear? Sometimes you may have an additional problem: where the devil did they go? If you last had a popup form open…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month7 days, 11 hours left to enroll
737 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.