By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,330 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,330 IT Pros & Developers. It's quick & easy.

Trouble with Access 2000 and finding a table's source

P: n/a
Hello all,

I've come upon a problem when trying to find where some data in my .mdb
file is coming from. This database was designed by someone else
several years ago, and now I've been put to task at redesigning it for
my company's current needs. However, I've been trying to find out
where exactly the table that is feeding data into several reports and
forms is coming from. There is no linked table object in the Tables
list of the .mdb file, and I cannot find anyway whatsoever to find out
where the original table data is coming from.

If I open up one of the queries or reports, I can see the name of the
table that the information is coming from, but that's it. No path, no
originating .mdb. Hell, I don't even know if its coming from an actual
Access database and not an SQL Server database somewhere else. I've
been told that Access was in place here before the SQL Server software
was added, so I highly doubt that's where its linking from anyway.

I just need to find out the location of this rogue table I'm dealing
with so that I can add a handful of extra rows to it.
Thanks in advance.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 1 Feb 2005 08:38:22 -0800, le*******@gmail.com wrote:
Hello all,

I've come upon a problem when trying to find where some data in my .mdb
file is coming from. This database was designed by someone else
several years ago, and now I've been put to task at redesigning it for
my company's current needs. However, I've been trying to find out
where exactly the table that is feeding data into several reports and
forms is coming from. There is no linked table object in the Tables
list of the .mdb file, and I cannot find anyway whatsoever to find out
where the original table data is coming from.

If I open up one of the queries or reports, I can see the name of the
table that the information is coming from, but that's it. No path, no
originating .mdb. Hell, I don't even know if its coming from an actual
Access database and not an SQL Server database somewhere else. I've
been told that Access was in place here before the SQL Server software
was added, so I highly doubt that's where its linking from anyway.

I just need to find out the location of this rogue table I'm dealing
with so that I can add a handful of extra rows to it.
Thanks in advance.


The tables are hidden.
Click Tools + Options + General
Place a check mark in the 'Show Hidden Objects" box.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.