Operation must be an updateable query
in [General]
|
From: Anthony Ching on 23 Feb 2010 22:18 Thanks Gina. There is no missing reference, and I have actually included the drivers in the executable version. -- Anthony "Gina Whipp" wrote: > Anthony, > > Check your References... sounds like it might be Access getting confused > between the versions. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message > news:BDD69603-CB51-4F10-B265-250E42D7BBE3(a)microsoft.com... > Thanks Jerry. I tried that and the same problem appears. Can it be something > different between the 2003 and 2007 office jet engine. Btw, the database is > split and the data portion resides in a server. > -- > Anthony > > > "Jerry Whittle" wrote: > > > I don't see anything obvious. My suggestion is to create a plain old query > > as > > similar as possible to your code. See if there are any problems running it > > that way. > > -- > > Jerry Whittle, Microsoft Access MVP > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > > > > "Anthony Ching" wrote: > > > > > I am using Access 2007. When I use Developer's Extension to create > > > .accdr > > > with Access Runtime to run on machines with Office 2003 only, the above > > > message comes up when I tried to use the "Update" statement. the .accdr > > > works > > > fine on my machine though. > > > > > > The statement I tried to execute is: > > > > > > Dim strSql As String > > > Dim cn As ADODB.Connection > > > > > > On Error GoTo Change_Err > > > > > > Set cn = CurrentProject.Connection > > > strSql = "UPDATE [User Identification] SET [Password] = '" & ([New > > > Password]) & "', [Date Last Change] = #" & Now() & "# WHERE [User ID]= > > > '" & > > > TempVars!CurrentUser & "';" > > > cn.Execute strSql > > > > > > Password and User ID are both alphanumeric. > > > > > > Can someone help. Thanks. > > > > > > -- > > > Anthony > > > . >
From: Gina Whipp on 24 Feb 2010 00:13 ANthony, What happens when you just use a plain old Update query, as Jerry suggested, does it work? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message news:653B1169-D4D8-4A03-A54A-3800B2158340(a)microsoft.com... Thanks Gina. There is no missing reference, and I have actually included the drivers in the executable version. -- Anthony "Gina Whipp" wrote: > Anthony, > > Check your References... sounds like it might be Access getting confused > between the versions. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message > news:BDD69603-CB51-4F10-B265-250E42D7BBE3(a)microsoft.com... > Thanks Jerry. I tried that and the same problem appears. Can it be > something > different between the 2003 and 2007 office jet engine. Btw, the database > is > split and the data portion resides in a server. > -- > Anthony > > > "Jerry Whittle" wrote: > > > I don't see anything obvious. My suggestion is to create a plain old > > query > > as > > similar as possible to your code. See if there are any problems running > > it > > that way. > > -- > > Jerry Whittle, Microsoft Access MVP > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > > > > "Anthony Ching" wrote: > > > > > I am using Access 2007. When I use Developer's Extension to create > > > .accdr > > > with Access Runtime to run on machines with Office 2003 only, the > > > above > > > message comes up when I tried to use the "Update" statement. the > > > .accdr > > > works > > > fine on my machine though. > > > > > > The statement I tried to execute is: > > > > > > Dim strSql As String > > > Dim cn As ADODB.Connection > > > > > > On Error GoTo Change_Err > > > > > > Set cn = CurrentProject.Connection > > > strSql = "UPDATE [User Identification] SET [Password] = '" & ([New > > > Password]) & "', [Date Last Change] = #" & Now() & "# WHERE [User ID]= > > > '" & > > > TempVars!CurrentUser & "';" > > > cn.Execute strSql > > > > > > Password and User ID are both alphanumeric. > > > > > > Can someone help. Thanks. > > > > > > -- > > > Anthony > > > . >
From: Anthony Ching on 24 Feb 2010 19:57 I have tried that one too. It worked on my machine with Office 2007, but not the other machines. -- Anthony "Gina Whipp" wrote: > ANthony, > > What happens when you just use a plain old Update query, as Jerry suggested, > does it work? > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message > news:653B1169-D4D8-4A03-A54A-3800B2158340(a)microsoft.com... > Thanks Gina. There is no missing reference, and I have actually included the > drivers in the executable version. > > -- > Anthony > > > "Gina Whipp" wrote: > > > Anthony, > > > > Check your References... sounds like it might be Access getting confused > > between the versions. > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message > > news:BDD69603-CB51-4F10-B265-250E42D7BBE3(a)microsoft.com... > > Thanks Jerry. I tried that and the same problem appears. Can it be > > something > > different between the 2003 and 2007 office jet engine. Btw, the database > > is > > split and the data portion resides in a server. > > -- > > Anthony > > > > > > "Jerry Whittle" wrote: > > > > > I don't see anything obvious. My suggestion is to create a plain old > > > query > > > as > > > similar as possible to your code. See if there are any problems running > > > it > > > that way. > > > -- > > > Jerry Whittle, Microsoft Access MVP > > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > > > > > > > "Anthony Ching" wrote: > > > > > > > I am using Access 2007. When I use Developer's Extension to create > > > > .accdr > > > > with Access Runtime to run on machines with Office 2003 only, the > > > > above > > > > message comes up when I tried to use the "Update" statement. the > > > > .accdr > > > > works > > > > fine on my machine though. > > > > > > > > The statement I tried to execute is: > > > > > > > > Dim strSql As String > > > > Dim cn As ADODB.Connection > > > > > > > > On Error GoTo Change_Err > > > > > > > > Set cn = CurrentProject.Connection > > > > strSql = "UPDATE [User Identification] SET [Password] = '" & ([New > > > > Password]) & "', [Date Last Change] = #" & Now() & "# WHERE [User ID]= > > > > '" & > > > > TempVars!CurrentUser & "';" > > > > cn.Execute strSql > > > > > > > > Password and User ID are both alphanumeric. > > > > > > > > Can someone help. Thanks. > > > > > > > > -- > > > > Anthony > > > > > > . > > > > > . >
From: Gina Whipp on 25 Feb 2010 00:33 ANthony, This may be a silly question but you did place these databases in a Trusted Location? http://www.regina-whipp.com/index_files/TrustedLocation.htm -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message news:DA7EFFD2-84E6-42E6-BA44-2E7F889EEE9F(a)microsoft.com... I have tried that one too. It worked on my machine with Office 2007, but not the other machines. -- Anthony "Gina Whipp" wrote: > ANthony, > > What happens when you just use a plain old Update query, as Jerry > suggested, > does it work? > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message > news:653B1169-D4D8-4A03-A54A-3800B2158340(a)microsoft.com... > Thanks Gina. There is no missing reference, and I have actually included > the > drivers in the executable version. > > -- > Anthony > > > "Gina Whipp" wrote: > > > Anthony, > > > > Check your References... sounds like it might be Access getting confused > > between the versions. > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - > > Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in > > message > > news:BDD69603-CB51-4F10-B265-250E42D7BBE3(a)microsoft.com... > > Thanks Jerry. I tried that and the same problem appears. Can it be > > something > > different between the 2003 and 2007 office jet engine. Btw, the database > > is > > split and the data portion resides in a server. > > -- > > Anthony > > > > > > "Jerry Whittle" wrote: > > > > > I don't see anything obvious. My suggestion is to create a plain old > > > query > > > as > > > similar as possible to your code. See if there are any problems > > > running > > > it > > > that way. > > > -- > > > Jerry Whittle, Microsoft Access MVP > > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > > > > > > > "Anthony Ching" wrote: > > > > > > > I am using Access 2007. When I use Developer's Extension to create > > > > .accdr > > > > with Access Runtime to run on machines with Office 2003 only, the > > > > above > > > > message comes up when I tried to use the "Update" statement. the > > > > .accdr > > > > works > > > > fine on my machine though. > > > > > > > > The statement I tried to execute is: > > > > > > > > Dim strSql As String > > > > Dim cn As ADODB.Connection > > > > > > > > On Error GoTo Change_Err > > > > > > > > Set cn = CurrentProject.Connection > > > > strSql = "UPDATE [User Identification] SET [Password] = '" & ([New > > > > Password]) & "', [Date Last Change] = #" & Now() & "# WHERE [User > > > > ID]= > > > > '" & > > > > TempVars!CurrentUser & "';" > > > > cn.Execute strSql > > > > > > > > Password and User ID are both alphanumeric. > > > > > > > > Can someone help. Thanks. > > > > > > > > -- > > > > Anthony > > > > > > . > > > > > . >
From: Anthony Ching on 25 Feb 2010 19:56 Gina, These databases are all placed in a Trusted location. Anthony -- Anthony "Gina Whipp" wrote: > ANthony, > > This may be a silly question but you did place these databases in a Trusted > Location? > > http://www.regina-whipp.com/index_files/TrustedLocation.htm > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message > news:DA7EFFD2-84E6-42E6-BA44-2E7F889EEE9F(a)microsoft.com... > I have tried that one too. It worked on my machine with Office 2007, but not > the other machines. > -- > Anthony > > > "Gina Whipp" wrote: > > > ANthony, > > > > What happens when you just use a plain old Update query, as Jerry > > suggested, > > does it work? > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in message > > news:653B1169-D4D8-4A03-A54A-3800B2158340(a)microsoft.com... > > Thanks Gina. There is no missing reference, and I have actually included > > the > > drivers in the executable version. > > > > -- > > Anthony > > > > > > "Gina Whipp" wrote: > > > > > Anthony, > > > > > > Check your References... sounds like it might be Access getting confused > > > between the versions. > > > > > > -- > > > Gina Whipp > > > 2010 Microsoft MVP (Access) > > > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> wrote in > > > message > > > news:BDD69603-CB51-4F10-B265-250E42D7BBE3(a)microsoft.com... > > > Thanks Jerry. I tried that and the same problem appears. Can it be > > > something > > > different between the 2003 and 2007 office jet engine. Btw, the database > > > is > > > split and the data portion resides in a server. > > > -- > > > Anthony > > > > > > > > > "Jerry Whittle" wrote: > > > > > > > I don't see anything obvious. My suggestion is to create a plain old > > > > query > > > > as > > > > similar as possible to your code. See if there are any problems > > > > running > > > > it > > > > that way. > > > > -- > > > > Jerry Whittle, Microsoft Access MVP > > > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > > > > > > > > > > "Anthony Ching" wrote: > > > > > > > > > I am using Access 2007. When I use Developer's Extension to create > > > > > .accdr > > > > > with Access Runtime to run on machines with Office 2003 only, the > > > > > above > > > > > message comes up when I tried to use the "Update" statement. the > > > > > .accdr > > > > > works > > > > > fine on my machine though. > > > > > > > > > > The statement I tried to execute is: > > > > > > > > > > Dim strSql As String > > > > > Dim cn As ADODB.Connection > > > > > > > > > > On Error GoTo Change_Err > > > > > > > > > > Set cn = CurrentProject.Connection > > > > > strSql = "UPDATE [User Identification] SET [Password] = '" & ([New > > > > > Password]) & "', [Date Last Change] = #" & Now() & "# WHERE [User > > > > > ID]= > > > > > '" & > > > > > TempVars!CurrentUser & "';" > > > > > cn.Execute strSql > > > > > > > > > > Password and User ID are both alphanumeric. > > > > > > > > > > Can someone help. Thanks. > > > > > > > > > > -- > > > > > Anthony > > > > > > > > > . > > > > > > > > > . > > > > > . >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Detail Background Next: How to synchronize between form inside MS Access to outlook ca |