Solved it - thanks for your help.
The problem was that it was trying to write to a temporary space on the D:\. We never used to have the DB do that but someone changed it. The problem was happening because sometimes the CD drive took the D:\ or the D:\ partition wouldn't be formatted.
Thanks again
mekon
Last Activity: Feb 20 '07, 12:33 AM
Joined: Feb 15 '07
Location: Australia
-
I'm not sure how to check the first two points but we put message boxes through the script to see where it got it and it fails here
Set LocalTbl = gLocalDB.Create TableDef(conLOC ALTBL_NAME)Leave a comment:
-
Thanks for the reply NeoPa, very quick
Would it help if I posted the code? I'll put it in anyway in case it will
...Code:[B]Private Sub btnOK_Click() Dim FldDef As Field, IndexDef As Index Dim holdtime, i As Integer Dim x On Error GoTo btnOK_Click_Err DoCmd.Hourglass True '*** beep and exit if txtUserID and txtUserPassword are empty If txtUserID &[/]Leave a comment:
-
Access Error: Object Variable or With block variable not set
Hi All,
I'm hoping someone out there can give me a hand with this problem I've got. I have an Access DB that people connect to using Access RT 2000. There are some machines that can connect through to the DB but most cannot and I can't work it out. The error people receive when trying to log onto the DB is 'Object variable or With block variable not set'.
I don't understand how some machines will connect but most won't.
I...
No activity results to display
Leave a comment: