Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sundaram123
Starting Member
15 Posts |
 Posted - 2004-07-16 : 09:41:49
|
| We have a VB application accessing MS-SQL Server, now we want to install this on remote machine. I am thinking of using MS-Access for this.Basically I want to convert MS-SQL Server Database to MS-Access. Are there any tools available for this purpose?Is any other procedure to achieve this?ThanksSR |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-07-16 : 10:20:03
|
downgrading  ... maybe MSDE would work for you? I've never used it before though... Anyone??Corey |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-16 : 13:08:40
|
| I suppose you could use DTS for this. Are you considering Access due to the cost of licenses with SQL Server? If so, check out MSDE as Corey mentioned.Tara |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-07-16 : 13:11:41
|
Thats 7000 Tara....  Corey |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-17 : 03:46:34
|
| We have a SQL database with an Access front end which we deploy for "solo" users using MSDE. Works just fine, and we only had to change the connection string in Access.Setting up the backups in MSDE is a bit fraught. I never managed to get the wizzard to work in MSDE ... but.Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-17 : 09:31:02
|
| I would still pick MSDE over the jet database any day of the year.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-19 : 12:23:45
|
quote:
Originally posted by Kristen
Setting up the backups in MSDE is a bit fraught. I never managed to get the wizzard to work in MSDE ... but.
Why though? Just script out the jobs from another server that you have and run it with osql on the MSDE server.Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-19 : 13:25:56
|
| Indeedie, I'd do that now, but back then I didn't have the knowledge - which I expect is true of plenty of visitors to these pastures!Kristen |
|
|
|
|
|
|
Convert MS-SQL Server Database to MS-Acces