Mamatha said:
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.