Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Operating SysArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Lounge
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

  View Other SQL Server Posts   Ask New Question  Ask New Question With Power Editor

Create table using SQL in MS ACCESS DB, Problem:: Table Deleted after some time .
Pinakin Patel posted at Thursday, September 06, 2007 6:36 AM

Hi,

I m create a table using SQL statement in MS Access DB.

Code is given bellow.

conn.Close();

conn.Open();

OleDbCommand com = new OleDbCommand(sb.ToString(), conn);

com.ExecuteNonQuery();

conn.Close();

after executing this code Table is created.

But after some time Table automatically DELETED.

Please replay fast.

Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0
A Table doesn't just get "automatically deleted".
Peter Bromberg replied to Pinakin Patel on Thursday, September 06, 2007 8:55 PM

There is some code somewhere in your app that is doing it. How's that for a fast "replay"?
Reply    Reply Using Power Editor
Peter Bromberg is a C# MVP, MCP, and .NET expert who has worked in banking, financial and telephony for over 20 years. Pete focuses exclusively on the .NET Platform, and currently develops SOA and other .NET applications for a Fortune 500 clientele. Peter enjoys producing digital photo collage with Maya,playing jazz flute, the beach, and fine wines. You can view Peter's UnBlog and IttyUrl sites.
Please post questions at forums, not via email!
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0

not any code because table was deleted after 5-10 minuts
Pinakin Patel replied to Peter Bromberg on Friday, September 07, 2007 1:09 AM

There was not any code for deleted table.

Because after some time table was deleted.

 

Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0

Generating timetables
subha sri replied to Pinakin Patel on Friday, February 20, 2009 12:22 AM



No friend .........i'm not asking to generate "table" in sql......

i'm asking to create "timetable" schedules for students and staffs without any

clash with each other using asp.net with C#.....
Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0