Multiple data sources

[weeze2]

Hi
I am having problems with a DB thats too big. It contains a table with pictures. The pictures itself is not that big but for some reason, the size is 1GB. I cannot compress the DB and I am now considdering something else.
How do you instead of using one tabel, use multiple tables in other databases, as one table? Or to put it in another way, how do one use more than one table as if it was one?
I hope someone can help or give advice

 

[weeze2]

Hi agian ..I forgot to add that the error message I get when trying to 'compress'* the database (going into Functions > Databasefunktions)is

"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"

And i am the only one using the file.

(*dont know the english phrase)

 

[AccessAce]

When using tables with text from mulitple databases, I first create linked tables to the databases, then create a UNION query to put all of the information in one place:

SELECT * FROM table1
UNION
SELECT * FROM table2;

Then use the query as the basis for whatever object you need. It will appear as though the information from all of the tables is in the query, which it is, minus any duplicates.

To solve the problem of huge databases when storing images, in the past, I've created a folder outside of the database that stores the images. I then store the path in the database. Whenever someone wishes to view the record using a form, I have VB Code that retrieve ths image from the path and displays it in an image object. If that solution is available, I would suggest that one.

 

[vin02day]

How I can do link to AccessDB tables from my AccessDB?
Can I do that without Tables Wizard?

 

[AccessAce]

You link tables to an AccessDB by using the Main Menu options:
File--Get external data--Link Tables

Then browse to the file you want, make sure you select the proper file type, and click Link. You may be prompted to answer a few questions. A new icon will appear in your database with a name. Access will now treat that link as a table.