Why? Why? Why?

[RichardH]

Why? Why? Why? Unable to see new table.

When I run an sql statement to create a table in one database while connected to another, how come access can't then find a form in the database where the table has been created, which takes the new table as it's recordsource?
Please help, I've had enough of this.

 

[modest]

Let me see if I understand this correctly:

You have two databases: DB1, DB2
From DB1 you create a table in DB2
A Form uses the table in DB2 as the recordsource, but it isn't working?

Try refreshing the form.

 

[RichardH]

Yes you're correct, that's the way it works. Unfortunately when I try to refresh the form it can't find the recordsource (which is the table that has just been created)
This has been driving me mad for nearly a week now and I know it'll just be a one liner that will fix it, it always is.

 

[frozbie]

You have two databases: DB1, DB2
From DB1 you create a table in DB2
A Form uses the table in DB2 as the recordsource, but it isn't working?

In DB1, create a link to the table in DB2, without this DB1 will not be able to see the table and the form will not be able to use the table as a recordset.

Frozbie

 

[RichardH]

Frozbie, sorry I haven't explained this very well. The form is in db2 and it takes the table created in db2 as the recordsource.
I've tried linking them, pausing it, doevents, adding a button so I open it manually, yet it sometimes works and sometimes doesn't, even when all the testing settings are exactly the same.
I'm losing the plot here )
Any other ideas?

 

[modest]

I was thinking it never works for you. If it works sometimes, there must be a way to fix this, I'd like to see your code.

 

[Pat Hartman]

Have you tried refreshing the tabledefs collection in the db where you created the table? That may be why the report doesn't "see" the table.

 

[RichardH]

Thanks Pat. At the risk of sounding a total dummy, how do I do that? I'm very new to this so please make it simple.