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.
1  1242 
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Penn Markham |
last post by:
Hello all,
I am writing a script where I need to use the system() function to call
htpasswd. I can do this just fine on the command line...works great
(see attached file, test.php). When my...
|
by: chicha |
last post by:
Hey people,
I have to convert MS Access 2000 database into mysql database, the whole
thing being part of this project I'm doing for one of my faculty
classes. My professor somehow presumed I...
|
by: Dalan |
last post by:
After reading and experiencing the phenomenon of installing MS Office
2000 on a system that already has MS Office 97, or for that matter
just Access 97 Runtime, I saw the ugliness that ensues. If...
|
by: alanknipmeyer |
last post by:
Dear Sirs,
Having previously used other SQL implementations I have grown used to
having an audit trail to find when problems occured, the problem I am
increasingly finding with Access is that...
|
by: Neil Ginsberg |
last post by:
I have a strange situation using Access to automate a Word mail merge. Using
Access 2000 and Word 2000, the code opens Word, opens the document in Word,
sets a table
in the calling Access...
|
by: Andy Davis |
last post by:
I have set up a mail merge document in Word 2003 which gets its data from my
Access 2000 database. I want to set up a button on a form that:
1. runs the query to provide the dat for the merge...
|
by: Rico |
last post by:
Hello,
I have an application that I'm converting to Access 2003 and SQL Server 2005
Express. The application uses extensive use of DAO and the SEEK method on
indexes. I'm having an issue when...
|
by: sammyloo |
last post by:
Hi all,
I'm experiencing a problem using ASP.NET web services to access a
different server with SQL Server 2000 database.
And I get the error of the following
Exception Details:...
|
by: JP |
last post by:
Hello:
I am using VB 6.0 with a Windows XP Professional environment. I am also
using Access 2000. I am currently building a program and need reporting
capabilities. So, I started a Data...
|
by: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: Naresh1 |
last post by:
What is WebLogic Admin Training?
WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: Matthew3360 |
last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function.
Here is my code.
header("Location:".$urlback);
Is this the right layout the...
|
by: Matthew3360 |
last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
|
by: Oralloy |
last post by:
Hello Folks,
I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA.
My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
|
by: Ricardo de Mila |
last post by:
Dear people, good afternoon...
I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control.
Than I need to discover what...
| |
