Linked Tables Problems

[Badeye]

Hi Guys,

So i currently have 2 different back ends for 1 front end. Now i have managed to get it so i can switch between the backends and this is working great, the only problem i am having is that the bound textboxes on my form are not displaying the new data when i switch backend, they appear to only be displaying the old data.

Any idea's on how i can overcome this problem

Thanks,

Si

 

[gemma-the-husky]

I would have thought you would switch tables before doing anything. you may get problems if you do this with an active "dirty" record

but anyway, you would need to do a me.requery on all openforms, I would think.

 

[Badeye]

yeah i've tried doing a me.requery but doesn't appear to do anything. Everything else updates great, so queries and reports all seem to pull the updated info, its just the textboxes that won't display the new info.

How is it possible for the form to display information from a a backend that its not connected to?

Is there anyting in VBA i can use to clear any connections?

Hope this makes sense?

Ta,

Si

 

[mdlueck]

but anyway, you would need to do a me.requery on all openforms, I would think.

If this does not totally resolve the refresh problems, I found this and several others have confirmed it worked for them as well

Must update RecordSource in order for Refresh to actually work
http://www.access-programmers.co.uk/forums/showthread.php?p=1091968#post1091920

 

[Solo712]

yeah i've tried doing a me.requery but doesn't appear to do anything. Everything else updates great, so queries and reports all seem to pull the updated info, its just the textboxes that won't display the new info.

How is it possible for the form to display information from a a backend that its not connected to?

But how do you know that some of your tables are not connected to the other backend ? How do you switch ? Through the Linked Tables Manager ?

Run this sub to see if the table(s) in question are really connected to the right backend.

Private Sub ViewTableDefs()
Dim dbs as DAO.database
Dim tdef as DAO.TableDef

Set dbs = CurrentDB
With dbs
For each tdef in .TableDefs
Debug.Print tdef.Name & ": " & tdef.Connect
Next tdef
End With
End Sub

Is there anyting in VBA i can use to clear any connections?

You can set the Backend connections programmatically via the TableDef object's Connect property. You can do it for all the tables.

Best,
Jiri