Access 2007 and "current user"

  • Thread starter Thread starter NeilR
  • Start date Start date
N

NeilR

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 said:
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
 
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?
 
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!
 
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.
 
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.
 
Back
Top