470,591 Members | 1,558 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

How to convert into MS-Access in ASP

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
2 1168
"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

"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.

Similar topics

5 posts views Thread by Hank | last post: by
2 posts views Thread by Nathan | last post: by
1 post views Thread by Fritz Switzer | last post: by
2 posts views Thread by Husam | last post: by
4 posts views Thread by Brad | last post: by
reply views Thread by Reedick, Andrew | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.