By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

How to convert into MS-Access in ASP

P: n/a
Hi

I want to convert SQLServer database into MS-Access
through ASP program.Is there any possiblity to covert?If
possible please let me know and thanks in advance.
Mamatha
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Mamatha" <ma***********@yahoo.com> wrote in news:1d5301c4e7ec$939cee50
$a*******@phx.gbl:
Hi

I want to convert SQLServer database into MS-Access
through ASP program.Is there any possiblity to covert?If
possible please let me know and thanks in advance.

Sort of... but if you use a lot of MS SQL specific functions such as stored
procedures, you'll need some manual reprogramming.
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #2

P: n/a

"Mamatha" <ma***********@yahoo.com> wrote in message
news:1d****************************@phx.gbl...
Hi

I want to convert SQLServer database into MS-Access
through ASP program.Is there any possiblity to covert?If
possible please let me know and thanks in advance.


You mean you're writing an application.
1) It's ASP
You want THIS APPLICATION to kind of export a sql server database as access?

or

Do you mean.
You're writing an ASP application.
2) It's currently using a sql server database.
You want to convert to using an access database instead.

For 2) you could export the tables from sql server to a blank access
database using DTS.
Then your problems start. Stored procedures, relationships, anything but
the bare structure ( and content ) would need rewriting.
MSDE might be a cheaper solution if the SQL licencing cost is the issue.
You don't get cheaper than free.

For 1). I suppose you could kind of automate running a DTS like above.
Problem is that the package will want to stick the file somewhere specific
and it'll be running on the server. I suppose you could make that a
directory exposed via iis somehow.
--
Regards,
Andy O'Neill
Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.