linking tables

[kerrigirrl]

i'm not sure if this is the right forum for this, but here goes...

on my form, within vba code, i'm linking a table, then copying it to another common table name for query purposes. when i go to run the query, it says it can't open it because it's exclusively opened by someone else. is the first table hanging open out there somewhere? any suggestions are appreciated. thanks!

 

[katiekat]

Maybe try doing this in "exclusive mode"? Just a thought. Holy tek-tips batman!:-0

 

[kerrigirrl]

nobody else uses this database or file.

 

[petermeachem]

Are you running a make table query or somesuch to create the common table? I can't think why this should not work, I've it loads of times.

What exactly are you doing? Peter Meachem
peter@accuflight.com

 

[kerrigirrl]

i think my problem is that i'm using transfertext to link the table. if i go and link it manually, i have no problems. to create the common table, i'm using copyobject...
that seems to be working.

 

[petermeachem]

I didn't even know you could do that (use transfertext that is). You can link in code (would you like to know how?) or you could use the IN ... code. Peter Meachem
peter@accuflight.com

 

[kerrigirrl]

yes i'd like to know how.

thank you so much!