SQL2000-Database, SQLExpress, Access TheoW 07.06.2006 15:16:01 I have a big MSSQL2000-Database. I want to query the data. I have no SQL-Server yet. Is it a good Idea to install SQLExpress, attach the Datafile and connect to Access 2003? Who has experiences?

Re: SQL2000-Database, SQLExpress, Access "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 07.06.2006 15:29:02 IMHO, iIf the database is smaller than 4Gigs (if I remember correctly); you shouldn't have any problem detaching it, copying it and reattaching it to SQL-Express 2005. You can also try with MSDE 2000 if you want to be absolutely sure to not have any compatibility problem but I don't thing that you will any. If you want only to query data and that you already have your Access 2003 application (MDB or ADP), Access 2003 will be fine for both; however, if you want to make some design changes in ADP, I'm not sure that you will be able to do so if you are using SQL-Express 2005 instead of MSDE 2000. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message news:C2230002-9C72-4CB1-B8EC-BE5380C244CF[ at ]microsoft.com... [Quoted Text] >I have a big MSSQL2000-Database. I want to query the data. I have no > SQL-Server yet. Is it a good Idea to install SQLExpress, attach the > Datafile > and connect to Access 2003? Who has experiences?

Re: SQL2000-Database, SQLExpress, Access TheoW 07.06.2006 20:54:01 Hello Silvain, installation of SQLExpress and attachment of the database to SQLExpress are without problems. But with Access I can't get connection to the data. Now I try MSDE. [Quoted Text] > IMHO, iIf the database is smaller than 4Gigs (if I remember correctly); you > shouldn't have any problem detaching it, copying it and reattaching it to > SQL-Express 2005. > > You can also try with MSDE 2000 if you want to be absolutely sure to not > have any compatibility problem but I don't thing that you will any. > > If you want only to query data and that you already have your Access 2003 > application (MDB or ADP), Access 2003 will be fine for both; however, if you > want to make some design changes in ADP, I'm not sure that you will be able > to do so if you are using SQL-Express 2005 instead of MSDE 2000. > > -- > Sylvain Lafontaine, ing. > MVP - Technologies Virtual-PC > E-mail: http://cerbermail.com/?QugbLEWINF > > > "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message > news:C2230002-9C72-4CB1-B8EC-BE5380C244CF[ at ]microsoft.com... > >I have a big MSSQL2000-Database. I want to query the data. I have no > > SQL-Server yet. Is it a good Idea to install SQLExpress, attach the > > Datafile > > and connect to Access 2003? Who has experiences? > > >

Re: SQL2000-Database, SQLExpress, Access "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 07.06.2006 21:27:54 First, take a look at these: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 http://www.datamasker.com/SSE2005_NetworkCfg.htm http://msdn2.microsoft.com/en-us/library/ms345318(SQL.90).aspx http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message news:96ABD235-0D16-4F2A-9F22-3267F6FD1385[ at ]microsoft.com... [Quoted Text] > Hello Silvain, > installation of SQLExpress and attachment of the database to SQLExpress > are > without problems. But with Access I can't get connection to the data. > Now I try MSDE. > >> IMHO, iIf the database is smaller than 4Gigs (if I remember correctly); >> you >> shouldn't have any problem detaching it, copying it and reattaching it to >> SQL-Express 2005. >> >> You can also try with MSDE 2000 if you want to be absolutely sure to not >> have any compatibility problem but I don't thing that you will any. >> >> If you want only to query data and that you already have your Access 2003 >> application (MDB or ADP), Access 2003 will be fine for both; however, if >> you >> want to make some design changes in ADP, I'm not sure that you will be >> able >> to do so if you are using SQL-Express 2005 instead of MSDE 2000. >> >> -- >> Sylvain Lafontaine, ing. >> MVP - Technologies Virtual-PC >> E-mail: http://cerbermail.com/?QugbLEWINF >> >> >> "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message >> news:C2230002-9C72-4CB1-B8EC-BE5380C244CF[ at ]microsoft.com... >> >I have a big MSSQL2000-Database. I want to query the data. I have no >> > SQL-Server yet. Is it a good Idea to install SQLExpress, attach the >> > Datafile >> > and connect to Access 2003? Who has experiences? >> >> >>

Re: SQL2000-Database, SQLExpress, Access TheoW 07.06.2006 22:19:01 Hello Silvain, thank you for the good resources. I tryed sqlcmd -S.\sqlexpress. The SQLCMD window pops up, is waiting a while an then disapears. The SQLExpress-Server is running, I can see in the task bar. SQL Server Management Studio Express is working well. What can I do? Thank you for helping. Theo Weidmann "Sylvain Lafontaine" wrote: [Quoted Text] > First, take a look at these: > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 > > http://www.datamasker.com/SSE2005_NetworkCfg.htm > > http://msdn2.microsoft.com/en-us/library/ms345318(SQL.90).aspx > > http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx > > -- > Sylvain Lafontaine, ing. > MVP - Technologies Virtual-PC > E-mail: http://cerbermail.com/?QugbLEWINF > > > "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message > news:96ABD235-0D16-4F2A-9F22-3267F6FD1385[ at ]microsoft.com... > > Hello Silvain, > > installation of SQLExpress and attachment of the database to SQLExpress > > are > > without problems. But with Access I can't get connection to the data. > > Now I try MSDE. > > > >> IMHO, iIf the database is smaller than 4Gigs (if I remember correctly); > >> you > >> shouldn't have any problem detaching it, copying it and reattaching it to > >> SQL-Express 2005. > >> > >> You can also try with MSDE 2000 if you want to be absolutely sure to not > >> have any compatibility problem but I don't thing that you will any. > >> > >> If you want only to query data and that you already have your Access 2003 > >> application (MDB or ADP), Access 2003 will be fine for both; however, if > >> you > >> want to make some design changes in ADP, I'm not sure that you will be > >> able > >> to do so if you are using SQL-Express 2005 instead of MSDE 2000. > >> > >> -- > >> Sylvain Lafontaine, ing. > >> MVP - Technologies Virtual-PC > >> E-mail: http://cerbermail.com/?QugbLEWINF > >> > >> > >> "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message > >> news:C2230002-9C72-4CB1-B8EC-BE5380C244CF[ at ]microsoft.com... > >> >I have a big MSSQL2000-Database. I want to query the data. I have no > >> > SQL-Server yet. Is it a good Idea to install SQLExpress, attach the > >> > Datafile > >> > and connect to Access 2003? Who has experiences? > >> > >> > >> > > >

Re: SQL2000-Database, SQLExpress, Access "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 08.06.2006 00:24:09 Did you install the SQL-Server Express Management Studio (or something like that) and yes, what does it give? With Access, you should be able to connect to an instance of SQL-Server Express for retrieving data in either ODBC (for MDB file) or OLEDB modes. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message news:20AE2421-F88C-4205-9529-504288405987[ at ]microsoft.com... [Quoted Text] > Hello Silvain, > thank you for the good resources. > I tryed sqlcmd -S.\sqlexpress. The SQLCMD window pops up, is waiting a > while > an then disapears. > The SQLExpress-Server is running, I can see in the task bar. SQL Server > Management Studio Express is working well. > What can I do? > > Thank you for helping. > Theo Weidmann > > > "Sylvain Lafontaine" wrote: > >> First, take a look at these: >> >> http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 >> >> http://www.datamasker.com/SSE2005_NetworkCfg.htm >> >> http://msdn2.microsoft.com/en-us/library/ms345318(SQL.90).aspx >> >> http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx >> >> -- >> Sylvain Lafontaine, ing. >> MVP - Technologies Virtual-PC >> E-mail: http://cerbermail.com/?QugbLEWINF >> >> >> "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message >> news:96ABD235-0D16-4F2A-9F22-3267F6FD1385[ at ]microsoft.com... >> > Hello Silvain, >> > installation of SQLExpress and attachment of the database to SQLExpress >> > are >> > without problems. But with Access I can't get connection to the data. >> > Now I try MSDE. >> > >> >> IMHO, iIf the database is smaller than 4Gigs (if I remember >> >> correctly); >> >> you >> >> shouldn't have any problem detaching it, copying it and reattaching it >> >> to >> >> SQL-Express 2005. >> >> >> >> You can also try with MSDE 2000 if you want to be absolutely sure to >> >> not >> >> have any compatibility problem but I don't thing that you will any. >> >> >> >> If you want only to query data and that you already have your Access >> >> 2003 >> >> application (MDB or ADP), Access 2003 will be fine for both; however, >> >> if >> >> you >> >> want to make some design changes in ADP, I'm not sure that you will be >> >> able >> >> to do so if you are using SQL-Express 2005 instead of MSDE 2000. >> >> >> >> -- >> >> Sylvain Lafontaine, ing. >> >> MVP - Technologies Virtual-PC >> >> E-mail: http://cerbermail.com/?QugbLEWINF >> >> >> >> >> >> "TheoW" <TheoW[ at ]discussions.microsoft.com> wrote in message >> >> news:C2230002-9C72-4CB1-B8EC-BE5380C244CF[ at ]microsoft.com... >> >> >I have a big MSSQL2000-Database. I want to query the data. I have no >> >> > SQL-Server yet. Is it a good Idea to install SQLExpress, attach the >> >> > Datafile >> >> > and connect to Access 2003? Who has experiences? >> >> >> >> >> >> >> >> >>