Hi,
I am new to Access and currently trying to work my way around it and have stumbles across a table with 4 field_Names but no idea where this table extracts data from to populate, how do I find out where this data comes from please?
Hi,
I am new to Access and currently trying to work my way around it and have stumbles across a table with 4 field_Names but no idea where this table extracts data from to populate, how do I find out where this data comes from please?
In a properly designed database data can come from various places. Some common places are:
1. Typed into a form
2. Imported from an external source, like an Excel table
3. Created programmatically from data in other tables.
4. Created by developer as static data that will not change over the lifetime of the program.
So the information you provided doesn't let us pin it down at all.
I guess that's my point, I can't give you anymore information as I don't know what to look for.
?? Where did this database originate? Did you build it? Or inherit it?
How exactly does one "stumbles across a table with 4 field_Names"?
I have inherited the database.
I am looking to move queries over to SQL server so was looking at the existing queries within Access to work out what needs replicating and as I followed the process from the first query, my end point arrives at this table. Other queries link straight into the source database but this doesn't so im at a loss how the data is populated. It updates each month so it's not a static table.
I think people would have to see and review the database (or part of it) in order to provide focused advice.
Is there any documentation?
Is original developer still accessible?
Is there vba /modules associated with this database?
If so, you could search for routines that involve that table.