Operation must be an updateable query

A

Anthony Ching

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.
 
D

Debra

Anthony Ching said:
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.
Click to expand...
 
J

Jerry Whittle

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.
 
A

Anthony Ching

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 said:
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 said:
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.
Click to expand...
Click to expand...
 
G

Gina Whipp

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

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 said:
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 said:
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.
Click to expand...
Click to expand...
 
A

Anthony Ching

Thanks Gina. There is no missing reference, and I have actually included the
drivers in the executable version.

--
Anthony


Gina Whipp said:
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

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 said:
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 said:
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.
Click to expand...
Click to expand...


.
Click to expand...
 
G

Gina Whipp

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

Thanks Gina. There is no missing reference, and I have actually included the
drivers in the executable version.

--
Anthony


Gina Whipp said:
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

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 said:
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 said:
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.
Click to expand...
Click to expand...


.
Click to expand...
 
A

Anthony Ching

I have tried that one too. It worked on my machine with Office 2007, but not
the other machines.
--
Anthony


Gina Whipp said:
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

Thanks Gina. There is no missing reference, and I have actually included the
drivers in the executable version.

--
Anthony


Gina Whipp said:
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

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 said:
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.


:

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.
Click to expand...


.
Click to expand...


.
Click to expand...
 
G

Gina Whipp

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

I have tried that one too. It worked on my machine with Office 2007, but not
the other machines.
--
Anthony


Gina Whipp said:
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

Thanks Gina. There is no missing reference, and I have actually included
the
drivers in the executable version.

--
Anthony


Gina Whipp said:
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

message
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 said:
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.


:

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.
Click to expand...


.
Click to expand...


.
Click to expand...
 
A

Anthony Ching

Gina,

These databases are all placed in a Trusted location.

Anthony
--
Anthony


Gina Whipp said:
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

I have tried that one too. It worked on my machine with Office 2007, but not
the other machines.
--
Anthony


Gina Whipp said:
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

Thanks Gina. There is no missing reference, and I have actually included
the
drivers in the executable version.

--
Anthony


Gina Whipp said:
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

message
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


:

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.


:

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


.
Click to expand...


.
Click to expand...


.
Click to expand...
 
G

Gina Whipp

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

Gina,

These databases are all placed in a Trusted location.

Anthony
--
Anthony


Gina Whipp said:
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

I have tried that one too. It worked on my machine with Office 2007, but
not
the other machines.
--
Anthony


Gina Whipp said:
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

message
Thanks Gina. There is no missing reference, and I have actually included
the
drivers in the executable version.

--
Anthony


Gina Whipp said:
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

message
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


:

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.


:

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


.
Click to expand...


.
Click to expand...


.
Click to expand...
 
A

Anthony Ching

Gina,

I checked them all and there is no conflict.
--
Anthony


Gina Whipp said:
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

Gina,

These databases are all placed in a Trusted location.

Anthony
--
Anthony


Gina Whipp said:
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

I have tried that one too. It worked on my machine with Office 2007, but
not
the other machines.
--
Anthony


Gina Whipp said:
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

message
Thanks Gina. There is no missing reference, and I have actually included
the
drivers in the executable version.

--
Anthony


:

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

message
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


:

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.


:

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


.



.
Click to expand...


.
Click to expand...


.
Click to expand...
 
G

Gina Whipp

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

Gina,

I checked them all and there is no conflict.
--
Anthony


Gina Whipp said:
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

Gina,

These databases are all placed in a Trusted location.

Anthony
--
Anthony


Gina Whipp said:
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

message
I have tried that one too. It worked on my machine with Office 2007, but
not
the other machines.
--
Anthony


Gina Whipp said:
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

message
Thanks Gina. There is no missing reference, and I have actually
included
the
drivers in the executable version.

--
Anthony


:

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

message
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


:

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.


:

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


.



.
Click to expand...


.
Click to expand...


.
Click to expand...
 
D

De Jager

Anthony Ching said:
Thanks Gina. There is no missing reference, and I have actually included
the
drivers in the executable version.

--
Anthony


Gina Whipp said:
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

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 said:
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.


:

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.
Click to expand...


.
Click to expand...
Click to expand...
 
J

joelgeraldine

ggnnnnn

"Anthony Ching" <[email protected]> a écrit dans le
message de groupe de discussion :
(e-mail address removed)...
Gina,

I checked them all and there is no conflict.
--
Anthony


Gina Whipp said:
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

Gina,

These databases are all placed in a Trusted location.

Anthony
--
Anthony


Gina Whipp said:
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

message
I have tried that one too. It worked on my machine with Office 2007,
but
not
the other machines.
--
Anthony


:

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

message
Thanks Gina. There is no missing reference, and I have actually
included
the
drivers in the executable version.

--
Anthony


:

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

message
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


:

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.


:

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


.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
A

Anthony Ching

HI Gina,

I finally got a chance to work on this one again and found the problem. As I
have a split database, my "Trust Location" on the coding side was correct.
However, the "Trust Location" on the server side did not have the coding
location on it. therefore the user can only read but not write to the server.
Once I added the trust location on the server, now it works. thanks.

Anthony
--
Anthony


Gina Whipp said:
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

Gina,

I checked them all and there is no conflict.
--
Anthony


Gina Whipp said:
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

Gina,

These databases are all placed in a Trusted location.

Anthony
--
Anthony


Gina Whipp said:
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

message
I have tried that one too. It worked on my machine with Office 2007, but
not
the other machines.
--
Anthony


:

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

message
Thanks Gina. There is no missing reference, and I have actually
included
the
drivers in the executable version.

--
Anthony


:

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

message
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


:

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.


:

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


.



.



.
Click to expand...


.
Click to expand...


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Update Database 4
Provider cannot be found when opening connection 1
'Operation must use an updateable query' 1
CurrentProject.OpenConnection ignores default language 1
Cannot debug Access 1
security exception opening an Access database from an InfoPath form 1
Appending records: 2 ADO connections 1
Operation must use an updateable query 1

Top