printing object dependencies
Searching for text in an MS Access MDB File
I'm using MS Access 2003.
I'd like to be able to search all non-table objects in a given MDB for a given text string. Is this possible? I want to know which MS Access objects contain the specified string. (I haven't seen anything in the menus that looks promising.)
My intention is to identify dependencies: if I want to delete, say, a query, I want to be sure that nothing references it. Yes, I know that there's an Object Dependencies option, but there are some Unsupported Objects that Object Dependencies cannot work with. I have union queries and subqueries that would be a problem for Object Dependencies.
When I click on object dependencies for a query, form, report or anything my system (Access 2007) does not show me anything. Is there a option that I need to enable or something?
View Object Dependencies won't work
I am trying to clean up my database using the View/Object Dependencies feature. It won't work and I keep getting a message that Access "cannot enable Name AutoCorrect because it cannot open and save one or more objects."
I have the proper permission, the objects are not open etc. I have tried clearing the Track name AutoCorrect and starting over. I have watched it map tables, queries, forms and reports but I get the "cannot enable Name AutoCorrect" message as soon as it gets to the Macros and Modules.
I know those things aren't supported for viewing dependencies, but why can't I getthe dependencies for the other objects that it appears to have mapped?
Advanced Object Dependencies Viewer
I have a fairly complex database. I've noticed that one can use the object dependencies option to see which objects depend on which.
The code in my forms events use a lot of query definitions which depend on queries.
Is there a way to see which functions depend on which query, that would make things easier in code maintenance
Can't eliminate Object Dependencies
I'm having problems getting rid of object dependencies. I have a query (query1) that used to depend on another query (query2), but then I changed query1 so that it no longer uses any fields in query2. However, Access still thinks that query1 is depends on query2! I've checked the SQL statements, and tried deleting the relationships in the query designer, but still. the dependency persists. Any advice on tracing this down
Table Dependent on another Table?
I am using Access 2007, and have inherited a database from a co-worker that is no longer with our company. This particular database works fine, and has for quite awhile now.
I was reviewing and analyzing all the tables and decided to find out the Object Dependencies for each one.
Much to my surprise I discovered that Table A shows that the objects that depend on it are a bunch of queries, and Table B!
When I click on object dependencies for Table B I find out that the converse is true!
I have checked the primary key/foreign key for each table and these are fine, and have no effect here.
Neither table uses Lok-up as the data type!
Output Object Dependencies
Been a while since mdbmakers.com, so it is good to see a number of familiar users from that forum.
Is there a utility, add-in or homebrew way to output the object dependency information from Access 2007? I know there are a couple retail solutions out there.
Missing Dependency Question
I have finished building my database and I was just doing some final checks to make sure that everything is in order and functioning properly when I noticed some missing dependencies.
I went to 'Database Tools', 'Object Dependencies' and started selecting each object to verify what they depended on and what depended on them.
I came across this one and for the life of me I cant figure out what dependency is missing. Every thing works fine but I would still like to know what I did during the build process that caused this to happen and how I can fix it.
A part of me says don't worry about every thing works. The other part that wants to learn something says figure it out and don't leave well enough alone.
With that in mind, the learning part of me is asking for
If you have a Query depending on a table and it shouldn't be, how do you correct it?
How do I delete a dependency
I downloaded the issues database and deleted a bunch of it. It is still generating error messages saying I have a missing form. I checked the dependencies window and it says there are some dependencies there, but I can't find them in any properties window of any field or object, they don't appear anywhere I can find in the design view. They don't appear in the relationships window. Where else can I look?
How do I delete a dependency that is hidden somewhere? Is there anything that will show me where Access thinks a dependency exists?
Printing fine but unable output reports
I use Access 2003. I have several reports that are printed with a Macro. The account data is provided from a query. This works fine for printing but now I want to save these reports to a directory and use them as attachments for an email.When I use output in the macro I get garbage. It should be in Rich Text. something is not working right, I'm out of ideas
Heres what I have so far
Object Type =Report
Object Name =Anything
Object Format =Rich Text Format
Object File =C:\Edocs\
Auto Start =No
Table, Query, and Form Printing
Printing consists of writing or drawing, on a piece of paper, the values held by an object of a database. This means that you can print from a table, a query, or a form. Before doing this, of course the object must exist and it must have records.
To print from a table, a query, or a form, in the appropriate section of the database window, right-click the object and click Print... When you do this, the document is sent directly to the printer.
Topics: Table, Query, and Form Printing, Report Fundamentals, Designing a Report, Using a Report and Report Maintenance.
Table "Missing Information:Out of Date" in Object Dependencies
I inherited an Access 2007 database that is using ODBC links to a back-end MySQL database to a remotely hosted site. During my discovery phase of this database I ran the "Object Dependencies" tool for a linked table and some of the results state "Missing Information: Out of Date". Can anyone help me understand what that means? What's out of date? What's missing? When I click on the hyperlink "Out of Date" all I get is a generic Access Help module. The ODBC link is good, and I can get live data just fine. I ran the Linked Tables updater just for the hell of it but it didn't change anything.
reading MDB file information from another language
I'm looking for a way or a language in which I can read MDB files and their dependencies from outside the actual file. Whether that happens by writing a program in DELPHI, or something else.
I'm not well versed in this sort of stuff, however I'm looking for ideas. Anyone know if this would be possible?
More or less, I'm looking for compatibilities with the data format and structuring of MDB data. Access can open a multitude of file extensions if the data is structured in a compatible way that Access can read.
Does anyone follow this?
Basically I think I want a way to capture the objects inside MDB files and those object dependencies (properties only). I can throw the data anywhere once I have it, but figuring out a method for getting it is the tough part
Display Object Dependencies
In this article, we will examine a feature that is new in MS Office Access 2013, and which offers great potential in our documentation, maintenance, and general upkeep efforts, from the perspective of the organizations MS Access databases. In MS Office Access 2013, we can directly and easily view information on dependencies between database objects. The capability to view a list of a database's objects, particularly within the context of how those objects relate to each other, can help us to maintain a database over time. The capability is perhaps most useful in helping us to avoid errors that emerge with the uninformed removal of record sources or other databases objects, but numerous other potential uses exist, as well.
MS Access as a Documentation Tool: Display Object Dependencies
In this article, we will examine a feature that is new in MS Office Access 2003, and which offers great potential in our documentation, maintenance, and general upkeep efforts, from the perspective of the organizations MS Access databases. In MS Office Access 2003, we can directly and easily view information on dependencies between database objects. The capability to view a list of a database's objects, particularly within the context of how those objects relate to each other, can help us to maintain a database over time. The capability is perhaps most useful in helping us to avoid errors that emerge with the uninformed removal of record sources or other databases objects, but numerous other potential uses exist, as well.
I have a form, that has several buttons that do some behind the scenes imports, queries etc. etc. What would be the easiest way for me to find out what all this form is dependent on, so I could copy it over to another "new" database (as well as the queries and dependencies) and not loose any of the functions of the form?
Access 2007 Object Dependencies on a Field
I know that Access 2007 allows you to check which objects are dependent upon a given object so that you can make sure it's okay to delete that object without screwing up other objects.
I was wondering whether this type of function was available for a given field. In the process of updating my database design, sometimes a field becomes obsolete. In this case, I update allmy queries and forms according to the new design without using the obsolete field.
However, I have over 100 queries in this particular database. I was wondering if Access could give me a list of queries that depend on a given field.
you have selected "Tables and Related Views" as the way to group objects
I get this problem of access: | in the database. Access needs to update information on object dependencies to create the groups. This will take some time for large databases. What can I do?
Is there a way with Access to make a button(s) non-printing? If I use them on a report, that ultimately would be printed I wouldn't want/need a button printing on it. Is there a way to do this in Access