How Do I force Access to See Newly Created SQL Tables Via Code??

[Chris Cairns]

I am running Access XP ADP and I create a temporary table on my SQL 2000
Server and sometimes I can access that table via code just after creation
and other times I can not.
I think I just need to refresh the list of tables but was not sure the best
method. Keep in mind that I am accessing the newly created table using code
and not the database window. I tried the tabledefs.refresh but get an error
438.

Something Like

Set dbs = Application.CurrentProject
dbs.TableDefs.Refresh

--OR--

Application.RefreshDatabaseWindow


What's the best method to handle this sort of thing?

 

[Michael, Cheng [MST]]

Hello Chris,

I noticed that this issue was posted in access.formscoding group. I am
adding a reply to that post. If you have follow up questions, please post
there and I will be glad to work with you.

Thank you for your patience and cooperation. If you have any question or
concern, don't hesitate to let me know. We are here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.