We have several crucial access xp databases used on our remote desktop
server by various remote workers. I have just bought a new workstation
and I am experimenting with office 2007. All these XP databases use
the "CurrentUser()" parameter in many queries and forms in order to
save lists for the user's own use. With Access 2007, there is no
workgroup sign-on so the current user always comes up as "Admin". In
the past I have used Moshannon's Speed Ferret to find specific strings
in all database objects, but they have not yet released a version that
works with Access 2007, so I cannot use this to change all the forms
and queries from the in-built CurrentUser to SelectUser (which I could
set with a new log-on screen.

Can anyone suggest either: 1) Another programme that would enable me
to find and replace all instances of CurrentUser; or 2) A way of
setting CurrentUser without reverting to using mdb and workgroup
files?

This is really holding us back as we will lose some clients who have
moved to Access 2007 if we cannot make these databases work!

Many thanks for any suggestions

"NeilR" <(E-Mail Removed)> wrote in message
news:6567b977-97ae-4e1d-9f85-(E-Mail Removed)...
> We have several crucial access xp databases used on our remote desktop
> server by various remote workers. I have just bought a new workstation
> and I am experimenting with office 2007. All these XP databases use
> the "CurrentUser()" parameter in many queries and forms in order to
> save lists for the user's own use. With Access 2007, there is no
> workgroup sign-on so the current user always comes up as "Admin". In
> the past I have used Moshannon's Speed Ferret to find specific strings
> in all database objects, but they have not yet released a version that
> works with Access 2007, so I cannot use this to change all the forms
> and queries from the in-built CurrentUser to SelectUser (which I could
> set with a new log-on screen.
>
> Can anyone suggest either: 1) Another programme that would enable me
> to find and replace all instances of CurrentUser; or 2) A way of
> setting CurrentUser without reverting to using mdb and workgroup
> files?
>
> This is really holding us back as we will lose some clients who have
> moved to Access 2007 if we cannot make these databases work!
>
> Many thanks for any suggestions

May be a silly question but why not keep to the mdb format and carry on
using the CurrentUser function? mdb is fully supported by A2007 AIUI.

Keith.
www.keithwilby.com

On Jul 16, 11:46*am, "Keith Wilby" <h...@there.com> wrote:
> "NeilR" <neilry...@yahoo.com> wrote in message
>
> news:6567b977-97ae-4e1d-9f85-(E-Mail Removed)...
>
>
>
>
>
> > We have several crucial access xp databases used on our remote desktop
> > server by various remote workers. I have just bought a new workstation
> > and I am experimenting with office 2007. All these XP databases use
> > the "CurrentUser()" parameter in many queries and forms in order to
> > save lists for the user's own use. With Access 2007, there is no
> > workgroup sign-on so the current user always comes up as "Admin". In
> > the past I have used Moshannon's Speed Ferret to find specific strings
> > in all database objects, but they have not yet released a version that
> > works with Access 2007, so I cannot use this to change all the forms
> > and queries from the in-built CurrentUser to SelectUser (which I could
> > set with a new log-on screen.
>
> > Can anyone suggest either: 1) Another programme that would enable me
> > to find and replace all instances of CurrentUser; or 2) A way of
> > setting CurrentUser without reverting to using mdb and workgroup
> > files?
>
> > This is really holding us back as we will lose some clients who have
> > moved to Access 2007 if we cannot make these databases work!
>
> > Many thanks for any suggestions
>
> May be a silly question but why not keep to the mdb format and carry on
> using the CurrentUser function? *mdb is fully supported by A2007 AIUI.
>
> Keith.www.keithwilby.com- Hide quoted text -
>
> - Show quoted text -

Many thanks for the rapid response. May be a stupid reply, but I
cannot find out how to sign onto the workgroup so that it lets me sign
on (thus setting current user)! Can you give me a simple answer to
this one?

On Jul 16, 11:58*am, NeilR <neilry...@yahoo.com> wrote:
> On Jul 16, 11:46*am, "Keith Wilby" <h...@there.com> wrote:
>
>
>
>
>
> > "NeilR" <neilry...@yahoo.com> wrote in message
>
> >news:6567b977-97ae-4e1d-9f85-(E-Mail Removed)....
>
> > > We have several crucial access xp databases used on our remote desktop
> > > server by various remote workers. I have just bought a new workstation
> > > and I am experimenting with office 2007. All these XP databases use
> > > the "CurrentUser()" parameter in many queries and forms in order to
> > > save lists for the user's own use. With Access 2007, there is no
> > > workgroup sign-on so the current user always comes up as "Admin". In
> > > the past I have used Moshannon's Speed Ferret to find specific strings
> > > in all database objects, but they have not yet released a version that
> > > works with Access 2007, so I cannot use this to change all the forms
> > > and queries from the in-built CurrentUser to SelectUser (which I could
> > > set with a new log-on screen.
>
> > > Can anyone suggest either: 1) Another programme that would enable me
> > > to find and replace all instances of CurrentUser; or 2) A way of
> > > setting CurrentUser without reverting to using mdb and workgroup
> > > files?
>
> > > This is really holding us back as we will lose some clients who have
> > > moved to Access 2007 if we cannot make these databases work!
>
> > > Many thanks for any suggestions
>
> > May be a silly question but why not keep to the mdb format and carry on
> > using the CurrentUser function? *mdb is fully supported by A2007 AIUI..
>
> > Keith.www.keithwilby.com-Hide quoted text -
>
> > - Show quoted text -
>
> Many thanks for the rapid response. *May be a stupid reply, but I
> cannot find out how to sign onto the workgroup so that it lets me sign
> on (thus setting current user)! Can you give me a simple answer to
> this one?- Hide quoted text -
>
> - Show quoted text -

Keith,
Please ignore my last message. I have found how to do it and it works!
Tghanks for the suggestion - I will carry on with mdb!

"NeilR" <(E-Mail Removed)> wrote in message
news:0ee0b6c9-d5fd-4203-b296-(E-Mail Removed)...

> Keith,
> Please ignore my last message. I have found how to do it and it works!
> Tghanks for the suggestion - I will carry on with mdb!

No probs, glad you got it sorted.

"NeilR" <(E-Mail Removed)> wrote in message
news:0ee0b6c9-d5fd-4203-b296-(E-Mail Removed)...
Please ignore my last message. I have found how to do it and it works!
Tghanks for the suggestion - I will carry on with mdb!

You do realize that since you were able to open the mdb without login (and
therefore 'admin' is the user), that anyone could do that; i.e. it isn't
secured at all.

--
Joan Wild
Microsoft Access MVP