What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is a
macro the best way to handle this?
Thanks in advance.
Troy Lee
2  2390 
On Mon, 19 May 2008 08:21:38 -0700 (PDT), tr******@comcas t.net wrote:
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is a
macro the best way to handle this?
Thanks in advance.
Troy Lee
On your copy of the database front end (that you take home with you),
delete the existing table (this does not delete the table, it only
breaks the link). Note: You can tell if your table is the linked table
if it has an arrow next to the table name.
Then click on File + Get External data + Import.
Navigate to the database that contains the actual back end table.
Select the table. Click on Options. Select Definition and Data.
If you also need to import the back end relationships, click on Import
Relationships.
Click OK.
You now have all the current records in that table on your database,
but it is no longer linked to the other database.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
On 19 May, 16:46, fredg <fgutk...@examp le.invalidwrote :
On Mon, 19 May 2008 08:21:38 -0700 (PDT), troy_...@comcas t.net wrote:
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is a
macro the best way to handle this?
Thanks in advance.
Troy Lee
On your copy of the database front end (that you take home with you),
delete the existing table (this does not delete the table, it only
breaks the link). Note: You can tell if your table is the linked table
if it has an arrow next to the table name.
Then click on File + Get External data + Import.
Navigate to the database that contains the actual back end table.
Select the table. Click on Options. Select Definition and Data.
If you also need to import the back end relationships, click on Import
Relationships.
Click OK.
You now have all the current records in that table on your database,
but it is no longer linked to the other database.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
An even simpler method which I use for this exact purpose all the
time! Both for Linked Access tables and also Oracle and SQLServer ones
too!
Have a development copy of your database system using local tables but
with linked tables as well!
1/ rename the linked tables to tablename_linke d
2/ create make table queries using the link tables as a master!
3/ Call the new table the original table name so all your forms etc.
continue to work
4/ run the query whenever you can be linked and you will have the
latest data! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jep |
last post by:
I have to setup some scheduled tasks to copy 3-4 tables from an
SQL2000 database to DB2 v. 8.1.
The job must run every night replacing all data.
How can this be done - with standard utilities??
Please be exact - I'm new to this.
Thank for any help.
|
by: Andromeda |
last post by:
Ok... form with a subform..
form has contact information (company name, address, etc.)
subform selects the area covered by each contact
form is linked to subform on contactID (a primary key/autonumber for
tbl form is based on, FK for table subform is based on)
for some reason, the contactID is not copying over from the form to
the subform, so after I enter information in the subform I have to go
to the table and fill in the...
|
by: itm |
last post by:
I have to copy a FE/BE Access 2002 database on a regular basis to a CD
to take to another site to use at that site. The data does not have to
be up to the minute at that site.
Is there a simple way to copy the db with the linked tables but without
the links? In other words, the complete db would be usable on any
computer anywhere. I would really appreciate some help with this asap
as my boss is breathing down my neck. Thanks!
|
by: Jill Elaine |
last post by:
I am building an Access 2002 frontend with linked tables to an
encrypted Paradox 7 database. When I first create these linked tables,
I'm asked for the password to the encrypted Paradox database, and the
linked tables are successfully created. I use the data from these
linked tables in several forms.
All works great until I close the Access frontend and open it again.
When I try to use the forms, I get an error message: "Could not...
|
by: TC |
last post by:
I need an automated procedure to copy data from an Access table to a
SQL Server table. Speed is important. What is the recommended
technique?
I can export the data from Access, copy it via FTP, then import it into
SQL Server. I've tried that, and the speed is acceptable. It is an ugly
solution, however, and I expect to find a better one -- preferably a
solution better integrated with the Access RDBMS.
I've tried using an ODBC...
| | |
by: corsibu |
last post by:
hello , i just wanted to ask if there's anyone who could help me do the following thing : i have an empty temporary table, this table will have a row filled with data grabbed by a querry at this point this point another query filters this data (it was the only way to do this as i know) and inserts it into an empty table called MOVIMENTI. until here all works just fine. after i finished this part i grab the data from MOVIMENTI and other 2...
|
by: mark_aok |
last post by:
Hi all,
I have a situation where I have a split database. At the back end, I
need to
- create a new table (I will call it newTable) with the exact fields,
and relationships as another table (let's call it oldTable, and I need
to copy everything EXCEPT the data).
- Then I need to delete oldTable, and rename newTable 'oldTable'
|
by: iitt2007 |
last post by:
I have a XLS file on local machine and would like to copy all the columns to a new SQL table on the 'remote' (not local sql server) using SQL scripts.
I tried following :
select * into TEMP_PLAN_CODE FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 10.0;Database=D:\Placodes.xls;HDR=YES',
'SELECT * FROM ')
but it's giving me an error :
Msg 7415, Level 16, State 1, Line 1
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0'...
|
by: Guineapig1980 |
last post by:
Hi all
I am trying to copy data from one database server to another. I only
want to copy one table's data, not the entire database. The part that
I am having trouble with is connecting from one database server and
connect to another then telling it to insert into the second database
server.
Not sure if this is how it works.
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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.
| |
