Operation must be an updateable query
in [General]
|
From: Gina Whipp on 26 Feb 2010 00:59 Anthony, What about FE's, is every got seperate front ends? I would also check folder permissions, Users will need Read, Write and Delete. -- 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:2D793E93-71DC-4CF5-A052-70EEA583B8AE(a)microsoft.com... 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 > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: Anthony Ching on 1 Mar 2010 21:59 Gina, I checked them all and there is no conflict. -- Anthony "Gina Whipp" wrote: > Anthony, > > What about FE's, is every got seperate front ends? I would also check > folder permissions, Users will need Read, Write and Delete. > > -- > 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:2D793E93-71DC-4CF5-A052-70EEA583B8AE(a)microsoft.com... > 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 > > > > > > > > > > > > . > > > > > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: Gina Whipp on 1 Mar 2010 23:39 ANthony, Did you check the permissions? -- 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:C811F5A7-D830-4656-B348-4363CB1085B2(a)microsoft.com... Gina, I checked them all and there is no conflict. -- Anthony "Gina Whipp" wrote: > Anthony, > > What about FE's, is every got seperate front ends? I would also check > folder permissions, Users will need Read, Write and Delete. > > -- > 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:2D793E93-71DC-4CF5-A052-70EEA583B8AE(a)microsoft.com... > 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 > > > > > > > > > > > > . > > > > > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: De Jager on 13 Mar 2010 13:01 "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: joelgeraldine on 17 Mar 2010 09:16 ggnnnnn "Anthony Ching" <AnthonyChing(a)discussions.microsoft.com> a écrit dans le message de groupe de discussion : C811F5A7-D830-4656-B348-4363CB1085B2(a)microsoft.com... > Gina, > > I checked them all and there is no conflict. > -- > Anthony > > > "Gina Whipp" wrote: > >> Anthony, >> >> What about FE's, is every got seperate front ends? I would also check >> folder permissions, Users will need Read, Write and Delete. >> >> -- >> 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:2D793E93-71DC-4CF5-A052-70EEA583B8AE(a)microsoft.com... >> 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
|
Pages: 1 2 3 Prev: Detail Background Next: How to synchronize between form inside MS Access to outlook ca |