Search results

I've come across quite a few many-to-manys before, which I always turn into two one-to-manys and a table linking them. I agree with pat about the one-to-ones also.

why not burn the files onto a cd, take it home, install the sqlserver 2000 trial on it from microsoft and get everything off that way? you can download the 180 day trial from http://www.microsoft.com/downloads/details.aspx?FamilyID=D20BA6E1-F44C-4781-A6BB-F60E02DC1335&displaylang=en Thats...

Hey guys thanks again for the replies, exactly what I needed. I think i'll go with MySQL or SQL Server instead. It's what I am more comfortable with anyway but I needed some kind of rationale as to why i'm not using Access in my work, this will do nicely :) Thanks again for the advice.

Hi Claire I think what The_Doc_Man is saying is that you will get errors trying to input data into linked tables if you do not do it in the right order. i.e. if you have a table full of car makes, and a table full of car models: if the car make table contains aston martin and ferrari, you...

Hi guys thanks for the replies It's a mixture of both data entry and simple report viewing etc, the 40 users will be taking phone calls from new customers and they will have to add their details to the database, but they will also be tracking these customers over the weeks and printing reports...

Hi everyone I'm starting a year-long university project which will be written in c#. The client app will be run on a LAN, with 35-40 users accessing the database concurrently, connecting to a database held on the server. Could anyone tell me if Access can withstand 35-40 users at the same...