Linked table - when? - Microsoft Access / VBA

Annette Massie

I have a database with a linked table within it.

I have a query form that opens and allows the user to select criteria
and then the form is filled with data found from the linked table.

At what point is the table linking? For example, if I open the form it
takes forever. I would like the form to open immediately, allow the
user to enter data and then have it search the linked table. It
appears it is opening the linked table and then asking for the
criteria and the processing to get the records.

I guess I was wondering how I could have the criteria form open
immediately and then have the linking take place.

Help!

Nov 12 '05 #1

Subscribe Reply

2065

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The form's RecordSource is probably the query name, which will cause
the query's result set to be loaded into the form when the form opens.
You can change the form's RecordSource or the form's Filter to limit
the number of records that appear when the form opens.

One way is to open the form in design view & set the form's Filter to
select a record that you know is NOT in the query's recordset.
Something like this:

CustomerID=0 - if you had "CustomerID " field in recordset

and set the Filter On property to Yes. Then save the form. When it
is next opened it should open faster 'cuz it is not retrieving any
records.

Another way is to leave the form's RecordSource property blank. Then
in the AfterUpdate event of the criteria selection (a CommandButton?)
put the query name in the form's RecordSource. I'm assuming the
criteria selection is really a filter that is applied to the form.

HTH,

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7wZ2IechKq OuFEgEQJmuQCfRX GjzXc1J1m0ST5CZ o4UloOmQ4IAoMlO
Plh31PkPXWekfRZ pl9s0VmdK
=CePZ
-----END PGP SIGNATURE-----

Annette Massie wrote:

I have a database with a linked table within it.

I have a query form that opens and allows the user to select criteria
and then the form is filled with data found from the linked table.

At what point is the table linking? For example, if I open the form it
takes forever. I would like the form to open immediately, allow the
user to enter data and then have it search the linked table. It
appears it is opening the linked table and then asking for the
criteria and the processing to get the records.

I guess I was wondering how I could have the criteria form open
immediately and then have the linking take place.

Help!

Nov 12 '05 #2

Similar topics

6761

Bad performance in queries with Jet4.0 and linked ODBC-tables to SQL-Server 2000

by: Andreas Lauffer | last post by:

I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:

Microsoft SQL Server

2673

Problem with HOST_NAME Function with Linked View

by: Neil | last post by:

I have an Access 2000 MDB file with a SQL 7 back end. I have a main table with 50,000 records; and I have a selections table with 50,000 records for each machine that uses the database (about 25-50). This allows each user to have their own set of selections. The selections table has three fields: ID (int), Sel (bit), MachName (varchar). ID and MachName comprise the primary key. I have a view that combines the main table and the entries...

Microsoft SQL Server

4465

Updating Linked Table - why is action query failing?

by: deko | last post by:

How to run action query against linked table? I have an Access 2003 mdb with an Excel 2003 Workbook as a linked table. When I attempt to run an action query against the linked table I get this error: Deleting data in a linked table is not supported by this ISAM. From what I understand, indexed sequential access method (ISAM) drivers are used to update "non-Microsoft" file formats. So why doesn't Access

Microsoft Access / VBA

5089

Problem deleteing linked tables

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 = CurrentDb For Each tbl In dbs.TableDefs

Microsoft Access / VBA

18949

Linked Table Password

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 password. I am developing a process that will automatically run at night which will access those tables. I need to be able to give Access the password, as the user currently does, so that the process can run without a password prompt appearing....

Microsoft Access / VBA

11822

#Deleted displaying for ODBC linked tables

by: Joe | last post by:

I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For tables that involve a number field as the primary key, the data is returned successfully. For tables that involve a character field (e.g. CHAR(3) or VARCHAR(10)) as the primary key, I have the correct number of rows returned, but the data displayed...

Microsoft Access / VBA

4890

DSN and linked table ?

by: Zlatko Matiæ | last post by:

Hi! What happens with linked tables if they were linked using File DSN, when I copy the Access file on some other PC without File DSN ? What is the difference between DSN on linked tables and pass-through queries ? Why I can change DSN for pass-through query and can't change it for linked table, in Properties dialog box ? Zlatko

Microsoft Access / VBA

6003

How to re-provide password to encrypted linked tables?

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...

Microsoft Access / VBA

1355

mixing linked tables

by: Gil | last post by:

hello i have a front end access application that has mixed linked tables from 2 different sources. some tables are linked to a MYODBC Driver and the other tables are linked to an access database. I know this sounds weird but it must be this way according to my situation. I am noticing that each time i run a query between the 2 linked tables it takes very long for the new connection to load.

Microsoft Access / VBA

7687

Local tables or linked local database?

by: Jim Devenish | last post by:

I have a split front end/back end system. However I create a number of local tables to carry out certain operations. There is a tendency for the front end to bloat so I have set 'compact on close' I think that I have read in some threads (althoug I cannot find them now) that others place such tables in a local, linked database. I could do this but I am interested to know what would be the advantages. And disadvantages, if any. Any...

Microsoft Access / VBA

8036

What is ONU?

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...

General

7978

Changing the language in Windows 10

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,...

Windows Server

8126

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6796

AI Job Threat for Devs

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...

Career Advice

5987

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5470

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4010

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2454

transfer the data from one system to another through ip address

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

C# / C Sharp

1572

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP