MDB og ADP hvad er bedst? og kan jeg skifte?

I assume that you are linking the tables in your SQL Server. If that is correct then Access shouldnt have any problem with 50 users. There is quite a bit of work involved converting to an ADP so I would suggest continuing with the setup you have already. If performance is a problem then try converting your queries to pass-through queries.

Ok lyder godt - er ikke helt opsat på at skulle til at kode det hele om.
Kender du nogle gode steder hvor jeg kan læse mere om pass-through queries?

Nogen der har et svar på den sidste del af mit spørgsmål?
Derudover vil jeg meget gerne høre om der er nogen mulighed for i frontend at tilgå sql-brugernavnet på den der er logget ind i henholdsvis mdb/adp-udgaven?

You can use
environ("username") to get the name of who is logged on to the PC, I assume that this is also being used to log on to the SQL Server.

Pass-through queries:
http://support.microsoft.com/kb/303968
http://support.microsoft.com/kb/210415

or just enter
access pass-through queries

in google :o)

Nej, brugeren logger ind med sql-brugernavn når han åbner databasen... så det duer ikke helt.

If the user logs in then cant you get hold of the user/password when they log in?

Create a function in the SQL database

CREATE FUNCTION dbo.UserName ()
RETURNS nvarchar(40)
AS 
        BEGIN
                DECLARE @UserName as nvarchar(40)

                set @UserName =upper(substring(suser_sname(),patindex('%\%',suser_sname())+1,(len(suser_sname())-patindex('%\%',suser_sname()))))

                return(@UserName)
        END


And in a module in your frontend use something like this

Function UserName() As Variant
Dim rs As ADODB.Recordset

    UserName = Null
   
    Set rs = New ADODB.Recordset
    rs.Open "SELECT UserName()", CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly
   
    If rs.EOF Then Exit Function
   
    UserName = rs(0)
   
    rs.Close
    Set rs = Nothing
   
End Function

fantastisk. jeg takker mange gange for hjælpen.

selv tak