Access issues with linked sharepoint tables

[ChrisHannah]

Hello

I have a few issues with the users of my database.
When opening the database(i load a menu with 4 buttons on it based on macros) they get a white screen and nothing opens and access goes into "not responding" mode after 2 seconds.

1. if i give them the database with no menu they can open it but still receive the white screen when opening the menu.

2.if i re-fresh the tables then open the menu there is no problem.

The first time i gave them the database i refreshed the tables so they could access them, they were asked for a username and password in most cases i asked them to save this password, then we tested and all was fine.
Since then a few of them have changed their password and we are having issues, i have tested and recreated this issue and it appears to be a little random when it will work or not work.

What i need is some advice on how to proceed so it will work every time my users open it.
Perhaps a script to prompt a re-fresh on opening the DB (and since this automatically prompts for a password we would just use this as an authentication so would eliminate issues of password change) but this would then need to open the menu.

or is there a way to have a username and password to open the database and the database then uses this for authentication to the sharepoint server (not mad on that idea)

i'm a little frustrated as i have spend a long time getting things right and every time i think i've got it i just seem to run into a new problem. :banghead:

My tables are based on sharepoint lists.
my front end is ran locally and is 10mb.

 

[ChrisHannah]

I have Added code to the open form event that
Refreshes the linked tables, it seams to work well with one issue

Private Sub Form_Open(Cancel As Integer)
Set dbs = CurrentDb
For Each tdf In dbs.TableDefs
If Len(tdf.Connect) > 0 Then
tdf.RefreshLink
End If
Next
End Sub

When that loading that form the form goes white and blank and does not load correctly this means i need to go and re-open that menu screen. somehow....