Replies

Hi Hans,

I have tried your code (modified – see below) and get the following error message:
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
The code stops at the cnn.Open statement.
Is there any chance that the problem is the provider? Should I be using a text file provider, rather than an Jet provider?

Public Function GetFileRst(strFileName As String, strFilePath As String, _
strLogon As String, strPwd As String)

Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim strCnn As String

strCnn = “Provider=Microsoft.Jet.OLEDB.4.0;”
strCnn = strCnn & “Data Source=” & strFilePath & “;”
strCnn = strCnn & “Extended Properties=’text;HDR=YES;FMT=Delimited'”

cnn.Open strCnn, UserID:=strLogon, Password:=strPwd

rst.Open Source:=”SELECT * FROM ” & strFileName, _
ActiveConnection:=cnn, CursorType:=adOpenStatic, _
LockType:=adLockReadOnly, Options:=adCmdText

Do While Not rst.EOF
Debug.Print rst(0).Value
Loop

rst.Close
Set rst = Nothing

End Function

Hi Hans,

I had thought of that but my question was aiming at a more fundamental level. I often put a lot of code in the onLoad event of a form and up until now I have made reference to the values of bound controls in that code. Normally this has worked but I wonder if I have just been lucky with the timing.

Regards
Ian

Oops, just re-read your reply. What is a repair installation?

Sorry Hans, I thought I had said that in my post. Yes I have tried detect and repair.

The exact same thing has just happened to me: last week all my databases worked – this week I get ‘The OpenReport action was canceled’ when I try to run reports, and nothing at all when I try to open one in design view. This is happening to all the databases that I try and open on my machine. When I open the same databases from other machines I do not have any problems. I am running Access 2003 (sp2) on Windows XP Pro (sp2). Others on the network are running a mixture of Windows 2000 Pro and XP Pro. Everybody is running Access 2003.

I have tried Compact and Repair from the Tools menu and Detect and Repair from the Help menu, but I still have the problem. I’ve checked the references in VBA and nothing looks out of place. Because I often dial in from home my PC was left on over the weekend. I had one of those messages when I logged in this morning saying that some kind of update had required a reboot. I can’t remember the exact words but I wonder if that is significant.

I have printers installed and I can print to them with other applications.

Any clues gratefully received.

Ian

That gets rid of the light brown space behind the tabs, but the tab control itself is still not transparent.

I’ve just received the three replies to the origanal post this morning.
Has something happened at Woody’s Lounge? I will contact my ISP anyway.

That did it.
BTW – I didn’t get an email informing me of this reply either.

Of course! (sound of head being slapped)
Thanks again.

BTW, I didn’t get an email to rell me that this reply had been posted. Have I changed a setting somewhere?

There is no error trapping used. I prefer this with work in progress as I can get straight to the problem , when it happens, by clicking the debug button. I think that was possibly the philosophy used by the writers of SendObject, except that they forgot to turn the error reporting functionality on after they had got it working.

Yes, I noticed the RTF thing after I created the post.
Problem now solved – it was nothing to do with SendObject, the report was making reference to a form control and the form control was empty. When I ran the report on its own I got a useful error message. Sorry to waste your time, but I wonder why there was no error message when SendObject tried to open the report?

Ian

Thanks. I have sent those suggestions to her support people.

Gary,
That looks very interesting. I must admit that this is not the first time that I have seen this problem, it’s just the first time that I couldn’t get around it by getting the query parameters from somewhere else. I’m not in the office today but I will check the query closing trick tomorrow.
Hans,
If Gary’s tip doesn’t work I’ll send in a database. As I say, I have seen this before and would like to know what is going on.

Thanks
Ian

Hi Hans,

Both the query that works, and the one that doesn’t, are called using DoCmd.OpenQuery “QueryName”

Ian

I am using Visual Web Developer Express which, as far as I know, doesn’t require the use of a bin folder. The relevant line in my web.config file is:

I’m not sure why I can’t see any error messages, but I have been trying to work out what the error is anyway. The security that I set up, using the wizards in VWDE, uses a SQL Express database. I’m not sure what the ISP has to provide for SQL Express to work. Should it have an instance of SQL Server running somewhere on the same machine, or does it just need to have the right files (DLLs?) available?

Ian