Error opening a recordset

[NeoPa]

That's exactly what you need Seth, except the TableDef version including a Name parameter (which is simply incorrect). Do you have the link for that?

[Seth Schrock]

Well, let me put it this way. It says the syntax is
expression.OpenRecordset(Type, Options) but it then continues to describe the four parameters I listed. Here are the links:
TableDef.OpenRe cordset Method
Database.OpenRe cordset Method

[NeoPa]

Thank you for the links.

Not impressive I'll grant you Seth, but it does include the information you need. The Syntax described at the top is accurate, even if, confusingly, it explains parameters that aren't available in that syntax. Low score for MS on their Help pages, especially after coming from a system where the quality was considerably higher, but enough to get you going using the methods. It's particularly upsetting as this will clearly effect newbies more than experienced developers, thus restricting the uptake of Access in new developers.

[zmbd]

Seth:
This should work in V2007 as well as 2010.
As you can see from the picture.... there's just a few lines of information:
[imgnothumb]http://bytes.com/attachments/attachment/6767d1355412815/bytesthread_945 144_help.jpg[/imgnothumb]
When I did this (as shown) the first thing I got was a list of about 20 or so items, I clicked on the first one just to see what was there and that is what is shown in the screen shot.

The other option is in the bottom corner of the help window... a little globe.

[Seth Schrock]

That is what I clicked on Z. However, in this case I didn't get any different results. I just posted the links for NeoPa since it was the same data and so that I didn't have to do screen shots and post them.

[NeoPa]

The point here is that the links you posted were web-based, while the pic Z posted is from an internal Help program. Generally speaking, the latter is a much more reliable resource. Given the choice, most of us would use the internal system. It's certainly what I'm recommending you use if you have that option available. The software needs to be included when Access/Office is installed.