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 1310
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 webserver runs that part of the
script (see attached file, snippet.php), though, it doesn't go through.
I don't get an error message or anything...it just returns a "1"
(whereas it should return a "0") as far as I can tell. I have read the
PHP...
|
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 knew db's and gave me long list
of things to do with that particular database, first thing being that
particular conversion. Truth is that I don't know a first thing about
db's, let alone using mysql... I downloaded mysql form www.mysql.com and...
|
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 one elects
the standard installation, then Office 2000 deletes a large percentage
of the older files. Of course, if one happens to choose Custom
installation and elects not to uninstall prior versions, then things
are happier. Yes, the archives...
|
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 there is no 'inbuilt' audit
trail for me to see what has happend to the database to get it into its
current state.
Is there a way to make Access 2002 (in 2000 mode) to generate a log of
ALL changes to table data ? A time/datestamp to start with...
|
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 application as the data source, and then performs a
merge. Everything works fine.
However, when a user uses it in Access 2002 and Word 2002, an extra instance
of the Access application is opened and remains open at the end. Sometimes
it remains open
| |
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 document in Word;
2. opens the document and runs the merge process for the new data.
I have managed to write the code to perform step 1 ok, but I'm having
trouble with step 2. It opens the word document fine but does not perform
the mail merge of...
|
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 the recordset opens a table. When I
write
Set rst = db.OpenRecordset("MyTable",dbOpenTable, dbReadOnly)
I get an error. I believe it's invalid operation or invalid parameter, I'm
|
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: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.
|
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 Project (first time I've ever used it so
it's already a "mystery").
I clicked on DataEnvironment1 and showed the object. Then I added a
connection. Used the wizard and under:
Provider I Selected Microsoft Jet 4.0 OLE DB Provider
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |