How to fill "Local Tables" with Password Protected back-end database tables

Khalid_Afridi

Registered User.
Local time
Today, 03:24
Joined
Jan 25, 2009
Messages
491
Hi everyone!
I want to fill local tables in some application with disconnected recordset. The tables in the front end application having the same table structure as in the back end database.
The front end application was linked with the back end password protected database tables.
I want no connected linked tables in the front end application. How can I fill the local tables in the front end application with the back-end password protected tables?:confused:
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

Look to use Append Queries as you can Append to another database and its table, therefore you may want to also look at Delete Query so you can look to Delete the Old Data and then Append the New Data.
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

So is your question about how to deal with BE DB / FE DB tables, or how to manage the password the BE DB requires?

I have solutions for both in use, so just want to be sure I do not go off in the incorrect direction.
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

Thanks Michael Lueck and Trevor

Actually I required to get all the linked tables data in one of my Reporting front end application, where we can print reports based on lot of complex queries and different reports.
The problem was that all the queries are so complex and the huge net of queries developed by someone to print the reports. This was effecting the others applications connected to the Back-End Database on the same Network.
The back-end database and the network was dying to give the response while all the other applications are running on the same time when you get the reports from reporting application.
So I decided to import all the tables on run time in Reporting application. This idea will not effect the others online application connected to back-end database directly.
I manage to import all the required tables on run time...
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

And you have some sort of SQL BE DB? Or an Access shared database file?

For my application, ALL access to the BE DB is done via Stored Procedures (SP). The Access FE DB executes the correct SP to accomplish what the FE needs done.

In the case of reports, there again the report is run via a SP, answer records downloaded into an FE temp table, and the report presentation is based on all of the data in the report's FE temp table. So if the report needs to be grouped, I do that operation in the report itself... and I just make sure that the SP delivers to the FE temp table enough answers that the report is able to use the raw data in that FE temp table without further processing.
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

I would use the Last Query in the group you mentioned to Make a Table and append only those filtered records.

Then I would run the Report from the new Table.

I have done this before with dramatic improvement in speed.
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

I would use the Last Query in the group you mentioned to Make a Table and append only those filtered records.

Then I would run the Report from the new Table.

How do you go about making sure that the dynamically created tables have their Subdatasheet Name set to None?

I leave the temp tables in my FE DB, empty them, etc... and leave them at least existing so that their Subdatasheet Name remains set to None.

Also I do not need to fuss with scripting the creation of indexes. Do you automate this as well?
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

The only thing that I do that I did not mention in my previous post is that I delete the existing Table if it exists.

I don't bother with any of those things you mentioned.

If you decide to do a test I would be interested to know of any improvement.
 
Re: How to fill "Local Tables" with Password Protected back-end database tables

And you have some sort of SQL BE DB? Or an Access shared database file?

For my application, ALL access to the BE DB is done via Stored Procedures (SP). The Access FE DB executes the correct SP to accomplish what the FE needs done.

I dont have the SQL BE, I have shared database file. This file is shared by lot of other applications on the network, one of which is REPORTING application where we need the latest data to print.
Reporting application have lot of complex quires and reports connected directly to the MAIN BE. (A BIG load on the other Applications)

I managed to IMPORT all the necessary tables in my FE Reporting application whenever user login to the application. ( i create a local table and store all the required tables names in the table, call the function and iterate to IMPORT the required tables) my BE is also password protected, so I recall the password in the function to authenticate the IMPORTED tables.

I was thinking to make local tables with _Local suffix name, but this would create lot of problem in already running queries with the different name. I would have to redesign all the queries in the application if I did so

The IMPORT tables idea save my lot of time to re design all the queries running in the Application. nothing is changed in the queries.. ;) now the data is local and the application is rocket.
 

Users who are viewing this thread

Back
Top Bottom