Uskifte min backend med SQL

Følger lige med

Der er masser af sider behandler emnet. Brug søgeord "SQL"

det prøver jeg Mugs

well the first you want to do is get hold of SQL Server which is NOT cheap!
Then follow the instructions for installing it. From there I would suggest you get hold of a book on SQL Server. A very good one is Inside MS SQL Server 2000 ISBN 0-7356-0998-5. You may find this hard going at the start but I am sure it contains most of waht you want. There is also a VERY GOOD Books Online included.

Here are a few links you may find usefull too.
The first is an idea as to how much it costs and which version you will need.
http://www.microsoft.com/sql/howtobuy/production.asp

http://www.inquiry.com/techtips/thesqlpro/10min/10min0798.asp
http://www.sqlservercentral.com/default.asp
http://www.sqlteam.com/
http://www.microsoft.com/sql/default.asp

Men laver man bare en sql server der indeholder nogle tabeller der er linket til en frontend Access-database - Altså skifter backend Access-databasen ud med en sql-server? Eller hyr?

When you link to an SQL Server db you make an ODBC data source then instead of linking to an MDB file you select ODBC data soreces form the combo.

There are other methods but this is the easiest.

Og det alene skulle være bedre når vi taler flerbruger databaser?

I was sure I had placed a comment here this morning!
SQL is desigend for MANY (1000's) users so you will have NO problem there but it has its price!

20 users shouldnt be a problem for Access

3Xx>Have you received the amswer you wanted?

Tjaahh - det er vel godt nok. Jeg er da blevet klogere...

OK! I think it is possible to download a trail version of SQL Server 2000!

OK! Jeg prøver at kigge på MS hjemmeside...