473,320 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem with linked tables

I'm using Access 2000. I have a DB with 19 tables, and I have just
split it. When I look in the back end, all 19 tables are there.
However, only 17 of them in the front end are actually linked to the
back end. When I look at the table objects in the front end, two of
them do not have arrows to indicate they are linked. These same two
tables do not show up in the Linked Table Manager.

If I open the tables in design view and look at the Properties,
Description is blank. Whereas the Description of the other tables
shows the path of the linked table.

Any suggestions on how I can get these two tables linked correctly?

Thanks,

Randy

Nov 13 '05 #1
6 1822
you can always do it manually.
File, Get External Data, Link...

Nov 13 '05 #2
Yes, do it manually. As a rule of thumb in Access, you should use the
wizard only to help you learn, as it almost never produces the best
result.

Make sure to keep any tables that are local to the front-end in the FE
so it runs faster.

Nov 13 '05 #3
good point... keep the static tables local. If you need to update them
every now and then, you can redistribute the front end etc. See Tony
Toews's site for ideas on that. But static lookup tables should all be
on the front end.

Nov 13 '05 #4
Thanks for the help.

I now know why the tables lost the links. They are both created in
code by SQL Select... Into... statements. So the original tables are
deleted each time the queries are run.

I have found some other posts in the NG that mention the TableDef
Connect property and RefreshLink method. I'll check these out and see
if I can use them to solve my problem.

Randy

Nov 13 '05 #5
Yoiu mean you're deleting the tables completely and recreating them
from scratch each time? Why not just clear out the tables and reuse
them? instead of doing a DROP TABLE <tablename>, just use a delete
query with no criteria to delete all the records in your temporary
tables or whatever.

Nov 13 '05 #6
pi********@hotmail.com wrote:
Yoiu mean you're deleting the tables completely and recreating them
from scratch each time? Why not just clear out the tables and reuse
them? instead of doing a DROP TABLE <tablename>, just use a delete
query with no criteria to delete all the records in your temporary
tables or whatever.

Thanks. That sounds like a better way than what I'm currently doing.

What I need to do is this: I have to have a report print in MS Word.
The powers that be want it in Word, and converting an Access report to
an RTF doc won't do because there are lines and a table that need to be
printed. The report will contain different data depending on
selections made by the user. A command button on the form runs a query
that fills tblReportData and opens a template in Word. When the
template opens, it pulls the data from tblReportData and populates the
report. Because the report data changes each time, I only need one row
in tblReportData. So the way I originally did this was by filling
tblReportData with

SELECT <data> INTO tblReportData FROM <tables>.

So I was not explicitly doing

DROP TABLE tblReportData,

but tblReportData was being deleted and recreated each time the query
was run. It seemed to be satisfactory at the time. Then I split the
DB, and the query created a new front end table while the Word template
was still pulling old data from the back end table.

So now I will try deleting all old data from tblReportData and
inserting new data for each new report. This is my first attempt at
creating a report in Word. If anyone could suggest a different/better
way, I will happily accept all suggestions.

Thanks again for the help.

Randy

Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Robert McGregor | last post by:
Hi all, I've got a Front End / Back End database that was working just fine. One day i opened the FE to find that if I tried to open one of the linked tables from the database window, nothing...
3
by: Michael Plant | last post by:
Hello one and all. I have a stored table in my database and the form I'm using is based on a query that draws data from my stored table and a linked table. The linked table is a *.txt file. ...
5
by: b b | last post by:
I created the following code to delete all linked tables in my database (Access 200): -------------------------------------------------------- Dim tbl As TableDef Dim dbs As Database Set dbs...
2
by: DataB | last post by:
Hi everyone! I have a forms problem. Bakground: I have created a number of tables. Of these, I have a main parent table (Personal Details) and a number of other child tables (Tax file No.,...
4
by: Neil Ginsberg | last post by:
I have ODBC linked tables to a SQL 7 database in an A2K database. The linked tables do not have the password stored in them, so the first time the user accesses them, they need to enter the SQL...
8
by: Alfonso Esteban Gonzalez Sencion | last post by:
I am trying to use Access as a front end for extracting information from an Oracle database. I started using linked tables but I am getting a very curious behaviour. When I consult the linked...
1
by: kuhni | last post by:
Hi everybody! Writing this time, I'm really desperate. Basically, I have a conceptual problem of how to solve a certain "problem" in MS Access 97. General objective: In order to categorise...
4
by: pokerboy801 | last post by:
OK, I will try to explain this as clearly and as concise as possible. I am using Access, which has three MS Excel Linked tables, to store call center metrics for reps. My Excel workbook has three...
4
by: Mike | last post by:
I have a multiuser access database to which I have split into fe & be. The system refreshes the links at each log-on between the fe & be automatically via code. PROBLEM: Locally it runs...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.