table refresh

[babu]

Hi All,
I am creating a table using VBA code as create table. The code is working fine. the problem is, the table tab is not getting refreshed automatically.
I mean, if i am in the table tab, and run the function which create the table and looking into the table tab, i am not getting the newly created table. I have to go to any other tab(any one form, query etc.) and again coming to Table tab, i can see the newly created table.

Please anyone can advise me on this.
Thanks a lot in advance.

 

[babu]

I am using the Access 97 version.

 

[LPurvis]

I suspect all you're wanting is
Application.RefreshDatabaseWindow

However, in general, it's not a big deal (as adding tables through code wouldn't coincide all that often with needing to immediately work with them from the database window...)

 

[babu]

Hi,
Thanks a lot for the information.
It's working fine for me now.

Actually as per my requirement user wants to do some manipulation on teh table after it gets created.

Thanks,
Babu

 

[LPurvis]

Hmm...

• Automated Table Creation via code.
• Refresh of Database Window
• User Manipulation / Access to Table

They would, pretty much, be mutually exclusive functions.
i.e. If you're creating a table in code - it would be for your application to use - within the confines of a UI which you have created.
Refreshing the DB window? OK - that could be for you at design time, but I see no burning need for it - a developer knows the window may need refreshing.
User access to tables? Pretty much the biggest risk you can offer in an application.
Now this may not be what you'd call a application in the strict sense of the word. You might just be providing some convenient tools for your manager to use...
But it would be very much in the minority of cases that you'd attempt to offer automated features to an application and yet still offer direct table access.

You can always display raw table data through a form/subform - and gain some control there at least. But through a dedicated bound form is most ideal.
Protect those users from themselves.