467,867 Members | 1,348 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,867 developers. It's quick & easy.

Trouble with Access 2000 and finding a table's source

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
  • viewed: 1121
Share:
1 Reply
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.

Similar topics

9 posts views Thread by Penn Markham | last post: by
17 posts views Thread by chicha | last post: by
5 posts views Thread by alanknipmeyer | last post: by
3 posts views Thread by sammyloo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.