Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 17th, 2007, 03:30 PM
Friend of Wrox
 
Join Date: Dec 2006
Location: , , .
Posts: 176
Thanks: 0
Thanked 0 Times in 0 Posts
Default access question

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
 
Old April 17th, 2007, 03:38 PM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

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
================================================== =========
 
Old April 17th, 2007, 11:02 PM
Friend of Wrox
 
Join Date: Dec 2006
Location: , , .
Posts: 176
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old April 18th, 2007, 06:27 AM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

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
================================================== =========




Similar Threads
Thread Thread Starter Forum Replies Last Post
Access security question kuznickic Access 2 August 4th, 2008 01:22 PM
Access question sprocket Access 7 July 10th, 2006 08:23 AM
Best way to access data.... question flyin ADO.NET 7 March 24th, 2004 07:20 PM
Access alias question badgolfer Access 2 December 15th, 2003 04:47 AM
Access alias question badgolfer VB Databases Basics 1 December 12th, 2003 11:56 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.