petehilljnr
Registered User.
- Local time
- Today, 14:22
- Joined
- Feb 13, 2007
- Messages
- 192
If anyone can explain:
In A2k, when I try to use a recordset on a linked table (or a query based on a linked table), it spits out a "Run-time error '3061': Too few parameters. Expected 2" error.
If I import that table fully (instead of linking), it works fine.
I'm trying to create the recordset using the following snippets of code:
Does anyone know why it doesn't like linked tables? Am I calling it the wrong way (as in, is the syntax different with a linked table)?
Regards,
Pete.
In A2k, when I try to use a recordset on a linked table (or a query based on a linked table), it spits out a "Run-time error '3061': Too few parameters. Expected 2" error.
If I import that table fully (instead of linking), it works fine.
I'm trying to create the recordset using the following snippets of code:
Code:
Dim rst As DAO.Recordset
Set rst = CurrentDB.OpenRecordset("SELECT * FROM tblTest",dbOpenDynaset)
Does anyone know why it doesn't like linked tables? Am I calling it the wrong way (as in, is the syntax different with a linked table)?
Regards,
Pete.