Current User issue

Jacques Latoison

unread,

Oct 27, 2009, 4:42:51 PM10/27/09

to

Hello all,
After migrating a financial DB from Access to SQL certain functions do
not work.
Primarily, the Access version of the DB had
A table with user records (that they input themselves).
A query that gives the CurrentUser() the list of their records only
A form that shows the query, and defaults any new record with the
currently logged in user's username by having the default value is the
UserName field be CurrentUser().

This allows for multiple people to be in the same system and input and view
ONLY their own records.

So the table is the source, the query provides the filter/view, and the form
is the interface.

My problem is that the form (because of the query) won't allow new records
in SQL.
Only the tables were upsized. The Access DB has not changed. The tables
are now linked tables.

A regular user can input new records into the source table directly, but not
through the query.
The table is on a SQL server, the query and form are in an Access
application.

I want to assume that the problem is the CurrentUser() command not working
in SQL, but what would I replace it with, and why should I have to, seeing
that the default value is located in the Access form and not in the SQL
table.

Thanks beforehand

Stefan Hoffmann

unread,

Oct 31, 2009, 10:45:56 AM10/31/09

to

hi Jacques,

see my answer in microsoft.public.access.forms.

When posting the same message in more than one newsgroup use crossposts
and an appropriate follow-up. So that others can find my answer.

mfG
--> stefan <--

Jacques Latoison

unread,

Nov 2, 2009, 1:56:47 PM11/2/09

to

I initially did the other post as I assumed no one was going to answer.
However, what is a crosspost?

"Stefan Hoffmann" <ste...@ste5an.de> wrote in message
news:evpCajjW...@TK2MSFTNGP02.phx.gbl...

Stefan Hoffmann

unread,

Nov 3, 2009, 3:42:28 AM11/3/09

to

hi Jacques,

Jacques Latoison wrote:
> I initially did the other post as I assumed no one was going to answer.
> However, what is a crosspost?

http://en.wikipedia.org/wiki/Crossposting
http://www.webhero.org/Newsgroups/crossposting.asp

mfG
--> stefan <--

Mark Annett

unread,

Dec 4, 2009, 9:49:01 PM12/4/09

to

Stefan,

Can you possibly tell me where to find your? I think this wil help with my
recent post "Some subforms work some don't".

I know it would have been best if Jacques had posted the link but since he
didn't can you help.

-Mark-
--
Mark Annett
ISPManSys.com

"Stefan Hoffmann" wrote:

> .
>

Stefan Hoffmann

unread,

Dec 6, 2009, 7:02:30 AM12/6/09

to

hi Mark,

Mark Annett wrote:
> Can you possibly tell me where to find your? I think this wil help with my
> recent post "Some subforms work some don't".

http://groups.google.com/group/microsoft.public.access.forms/browse_thread/thread/098b385f51ecc256/ebadeb9d4f86a370?lnk=raot

mfG
--> stefan <--

Mark Annett

unread,

Dec 7, 2009, 8:33:01 AM12/7/09

to

Thanks for the link. FYI, the solution to the problem that I had with adding
new records was that all I need to do was rebuild my queries and exactly as
they were and I was instantly able to add new records.
--
Mark Annett
ISPManSys.com

"Stefan Hoffmann" wrote:

> .
>