Re: Access project (with SQL server)
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Sat, 30 Apr 2005 06:31:47 -0400
What is your criteria? In other words, what's the WHERE clause in the SELECT
statement? Does the data you're trying to insert meet that criteria?
If, for example, you're only displaying records associated with this month,
and you're trying to insert a record for a different month, you'll get that
error.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"johnbertell" <johnbertell@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF5D2446-417B-4321-BD04-DFDFB2BF116D@xxxxxxxxxxxxxxxx
> Have anyone seen this error message before:
> -----
> The data was added to the database but the data won't be displayed in the
> form because it doesn't satisfy the criteria in the underlying record
> source.
> -------
> In the error box there is a 'Show help' which gives this message:
> --------
> This error can occur if the data you are attempting to save is saving to
> an
> SQL database (Microsoft SQL Server 7.0) and the RecordSource for the
> subform
> is using an SQL Select statement with fields pulled directly from the
> source
> table, and the table is using an Identity field set as its primary key.
> To avoid this problem set the RecordSource property of the Subform to a
> Table or a View.
> -Or-
> Upgrade to a newer version of Microsoft SQL Server.
> More information about this error message online.
> -------
> - which makes absolutely no sense since I use MS SQL Server 8.0, and it
> does
> not come in a subform, it is in a plain form with a record source in the
> form
> of an SELECT-statement. I cannot use a table or a view, since I have
> dynamic
> criteria in the form which changes the recordset.
>
> By the way, the link to 'More information about this online' gives
> absolutely nothing! Here is the link:
> http://watson.microsoft.com/dw/errormessages.asp?ProductName=Office11&EventSource=OfficeErrorMessages&EventID=10021&Language=1033&productBuild=11.0.6352.0
>
> --
> /John
.
- References:
- Access project (with SQL server)
- From: johnbertell
- Access project (with SQL server)
- Prev by Date: Access project (with SQL server)
- Next by Date: Re: How do I accomplish the equivalent of hitting the {ESC} key in code?
- Previous by thread: Access project (with SQL server)
- Next by thread: Re: How do I accomplish the equivalent of hitting the {ESC} key in code?
- Index(es):
Relevant Pages
|
