<p>I have an Access database in which I drop the table and then create the table afresh.  However, I need to be able to test for the table in case the table gets dropped but not created (i.e. when someone stops the DTS package just after it starts -roll-eyes- ).  If I were doing this in the SQL database I would just do:</p>

<pre><code>IF (EXISTS (SELECT * FROM sysobjects WHERE name = 'Table-Name-to-look-for'))
BEGIN
drop table 'Table-Name-to-look-for'
END
</code></pre>

<p>But how do I do that for an Access database?</p>

<p>Optional answer: is there a way to have the DTS package ignore the error and just go to the next step rather than checking to see if it exists?</p>

<p>SQL Server 2000</p>

[{'answer_id': 26045, 'author': 'Ross', 'author_id': 2025, 'author_profile': 'https://Stackoverflow.com/users/2025', 'pm_score': 2, 'selected': False, 'text': '<p>I would reccomend sticking to what you know - PHP is more than capable.</p>\n\n<p>I used to play a game called <a href="http://www.hyperiums.com/" rel="nofollow noreferrer">Hyperiums</a> - a text based browser game like yours - which is created using Java (it\'s web-based quivalent is JSP?) and servlets. It works fairly well (it has had downtime issues but those were more related to it\'s running on a pretty crap server).</p>\n\n<p>As for which framework to use - why not create your own? Spend a good amount of time pre-coding deciding how you\'re going to handle various things - such as langauge support: you could use a phrase system or seperate langauge-specific templates. Third party frameworks are probably better tested than one you make but they\'re not created for a specific purpose, they\'re created for a wide range of purposes.</p>\n'}, {'answer_id': 26051, 'author': 'jamting', 'author_id': 2639, 'author_profile': 'https://Stackoverflow.com/users/2639', 'pm_score': 2, 'selected': False, 'text': '<p>Check out <a href="http://code.google.com/p/django-mmo/" rel="nofollow noreferrer">django-mmo</a>!</p>\n'}, {'answer_id': 26059, 'author': 'Konrad Rudolph', 'author_id': 1968, 'author_profile': 'https://Stackoverflow.com/users/1968', 'pm_score': 4, 'selected': True, 'text': '<blockquote>\n  <p>I would reccomend sticking to what you know - PHP is more than capable.</p>\n</blockquote>\n\n<p>That\'s true of course, but:</p>\n\n<blockquote>\n  <p>I don\'t mind, and I would even like to use this as an excuse, learning some new thing like Python or Ruby.</p>\n</blockquote>\n\n<p>Then writing a browser game is an excellent opportunity to do this. Learning something new is never wrong and learning an alternative to PHP can never hurt (<a href="http://www.codinghorror.com/blog/archives/001119.html" rel="nofollow noreferrer">eh, Jeff?</a>). While neither Ruby on Rails nor Django are especially useful for writing games, they\'re still great. We had to write a small browser game in a matter of weeks for a project once and Rails worked charms. On the other hand, all successful browser games have enormous work loads and if you want to scale well you either have to get good hardware and load balancing or you need a non-interpreted framework (sorry, guys!).</p>\n'}, {'answer_id': 29414, 'author': 'Markus', 'author_id': 2490, 'author_profile': 'https://Stackoverflow.com/users/2490', 'pm_score': 2, 'selected': False, 'text': "<p>I'd definitely suggest PHP. I've developed browser based games (pbbgs) for about 10 years now. I've tried .Net, Perl and Java.</p>\n\n<p>All of them worked, but by far PHP was the best because:</p>\n\n<ul>\n<li>Speed with which you can develop (that might be due to experience)</li>\n<li>Ease/Cost of finding a host for a game site </li>\n<li>Flexibility to change/revamp on the fly (game programming seems to always have a different development cycle then normal projects)</li>\n</ul>\n\n<p>Ruby is not to bad, but the last time I tried it I rapidly ran into scaling/performance issues.  I have not tried Python yet...maybe it's time to give it a shot.</p>\n\n<p>Just my two cents, but over the years PHP has saved me a ton of time.</p>\n"}]
['https://Stackoverflow.com/questions/26062', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/730/']