Prev: Form/Query Question
Next: office files on one pc are treated as read only
From: Anthony Ching on 16 May 2010 22:51
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" wrote:

> 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
> > > > >
> > > > >
> > > > > .
> > > > >
> > > >
> > > >
> > > > .
> > > >
> > >
> > >
> > > .
> > >
> >
> >
> > .
> >
>
>
> .
>
 | 
Pages: 1
Prev: Form/Query Question
Next: office files on one pc are treated as read only