hi expert
i visite the access forum but that was locked

i have 3 question
i would like to thank any one help me

1)in access how can i declare a stored procedure like stroed procedure inside the sql

2)how can create backup from database (sql and access) inside the c# application

and finally tha is more important
3) how can restor backuped database file for sql and access inside the c#?

any code,sample and article is usefull
thank again

1) Access doesn't support Stored Procedures. You can create Queries inside of access however I never used access much so i cant advise you one way or another in using them.

2) Are you asking how to run a backup job in Access and SQL from C# or are you asking how to Backup a SQL Database into an Access Database from C#?

3) This I am unsure of.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

hi dparson $ thanks for your reply

i wanna to back up sql database or access database from C# // not backup sql data base into access database

about question (1) .. can you explain more ?

and about question 3 : this action is verry important // please find a solution for it

i'm writing a program and i have to inser a section for back up and restoring database inside my applicaton

thank again

Ok first about this comment:

and about question 3 : this action is verry important // please find a solution for it

I am not your personal gopher here to go out and search the net for an answer to YOUR problem; you will need to investigate this further on your own.

Question 1: As I have said, you can not create stored procedures in Access, however you can create Queries which as the name implies is a Query that does something. This can be created from inside access on the Queries tab.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========