August 23, 2004 at 3:43 am
Hi i am new to this forum, so hello to all
I have Windows XP installed on my laptop and i want to use SQL Server to hold the tables for an access database.
can i install the SQL Server on my laptop with Windows XP ?
will this effect my installtion of windows ?
is it easy to set up the tables for access?
is there a version of SQL Server that is more stable than another
August 23, 2004 at 4:02 am
can i install the SQL Server on my laptop with Windows XP ?
Yes, MSDE, SQL Server Personal Edition, and SQL Server Developer Edition will all install on Windows XP. Bear in mind that MSDE comes with no client tools (such as Enterprise Manager).
will this effect my installtion of windows ?
Other than having a SQL server installed, no.
is it easy to set up the tables for access?
No more difficult than creating tables in access.
is there a version of SQL Server that is more stable than another
MSDE is throttled after 5 (or 10, I never remember) concurrent connections. No edition is more 'stable', although some editions support high-availability solutions, if required.
August 23, 2004 at 4:05 am
great, thanks for that...
i want to try and get to grips with it on my laptop first, then at a later date use the companies versio to run our current database from it...
is it hard to link MS Access quries etc... to the tables in SQL Server ?
August 23, 2004 at 4:10 am
I can't say I've ever used Access (other than as a back-end for simple web applications), but connecting to a SQL database is very similar to connecting to Access. You could use a DSN, oledb string, or whatever.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply