Select "blah" INTO GetUser()

  • Thread starter Thread starter Edro
  • Start date Start date
E

Edro

I hope the subject line speaks for itself..

AS you can see I am trying to create a multiuser app without splittin
the database. No Client allowed on PC's ..Bummer :(.
Has anyone attempted to create temp tables named from the users
network logon?

Any assistance with this would be most greatly appreciated..

Edr
 
Edro,

"SELECT blah INTO " & Environ("UserName") & " WHERE ....."

Beware, though, that a monolithic multiuser database is a recipe for
disaster; it may not happen immediately, but it's bound to corrupt, plus the
bloat (in between corruptions, that is) will be amazing! If you're not
allowed to install FE's on the users' PC's, then still split the database
and put a separate copy of the FE for each user on the network.
It's worth spending some time in the multiuser NG, you'll find some useful
stuff as well as interesting horror stories of monolithic multiuser
databases, or split ones with a common FE for all users (trust me, I learnt
the hard way).

HTH,
Nikos
 
Back
Top