db sorterer efter anden db

From one of the databases you can link the table from the other datebase. (Files+Get External data + Link Tables)

Then cut and paste this into a Query (SQL View) and modify the  table and field names
tbl1 = table in db1. tbl2 = table (linked) in db2

No is the unique field names in both tables!


SELECT tbl1.text
FROM tbl1 INNER JOIN tbl2 ON tbl1.[no] = tbl2.[No]
WHERE (((tbl2.No2)=1));

3dmaxer.dk> are you there?

yes, but I have not yet tried it out. It looks promising.

When I have tried it out I will write again.

Thanks so far

OK :o)

hows it going?

HELLOOooooowwww.....
How about responding 3dmaxer.dk :o)

I\'m back!!

I\'m sorry - I havn\'t responded the last two weeks. This week I got time this week to see if it works :-)

On my own PC it works great. When I upload it to my website on the net it doesn\'t work at all.

When I link from db1 to db2 on my own PC it creates a shortcut. This shortcut is not the right one when it is uploaded. It seems like I can\'t changes the shortcut. The two dbs are in the same dir.

Do you have a solution to this?

3dmaxer.dk> There was no mention of a website in your question. You MUST know where the other database is so that you can alter the link in code. Another way is to MAP a network drive to the same name as on your website an dthen place your other db ther and then re-link before uploading to your website.

3dmaxer.dk take a look at the answre given for this question.
http://www.eksperten.dk/spm/120980

You have been a BIG help - doubble up 60p.

3dmaxer.dk>thanks a lot :o)