Hello all,
i have a linked table in Access to SQL Server. I'm running a simple select statement in Access on the table.
select * from tblData;
When I do this it brings up a parameter pop-up to add a [dtDate] field entry in the query??? The [dtDate] field is not in the table or in the above query, but the Access is asking for it. Wierd!!! When I go into SQL Server and run the same query, viola it runs without issue.
I've relinked the tables in Access...this resolved the issue for a while, but when I try to run the query, it's doing the same thing again.
Anyone ever see this??? How bizarre!!!
i have a linked table in Access to SQL Server. I'm running a simple select statement in Access on the table.
select * from tblData;
When I do this it brings up a parameter pop-up to add a [dtDate] field entry in the query??? The [dtDate] field is not in the table or in the above query, but the Access is asking for it. Wierd!!! When I go into SQL Server and run the same query, viola it runs without issue.
I've relinked the tables in Access...this resolved the issue for a while, but when I try to run the query, it's doing the same thing again.
Anyone ever see this??? How bizarre!!!