logo

Create table using SQL in MS ACCESS DB, Problem:: Table Deleted after some time . (SQL Server)
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
February 0 $0.00 0
January 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. Pete Tweets at peterbromberg
  Rank Winnings Points
February 0 $0.00 0
January 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
February 0 $0.00 0
January 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
February 0 $0.00 0
January 0 $0.00 0


Didn't Find The Answer You Were Looking For?

EggHeadCafe has experts online right now that may know the answer to your question.  We pay them a bonus for answering as many questions as they can.  So, why not help them and yourself by becoming a member (free) and ask them your question right now?
Ask Question In Live Forum

If you have an OpenID and do not want to become a member of the EggHeadCafe forum, you can also sign on to Chat Chaos and post your question to our real time Silverlight chat application.
Ask Question In Chat Chaos










  $1000 Contest    [)ia6l0 iii - $228  |  Jonathan VH - $161  |  Huggy Bear - $135  |  F Cali - $95  |  egg egg - $94  |  more Advertise  |  Privacy  |   (c) 2010