Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
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.
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
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.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month5 days, 2 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.