It's also missing an END statement to match up with the BEGIN. Some other things to look at include the error log, if any, that would be associated...

Well, as to creating a simple GUI, Access has the ease of development, AND, it has the means to use the same code as VBScript in terms of accessing the...

Gee, that sure was helpful... Remind me why I needed that?

Not everyone can know everything, and I fail to see that any of the apps I've developed over...

Wow... trivial effort, eh? I think not. I migrated my queries, of which it created only those that didn't have parameters as views, and instead of...

Apparently, one can't have local queries in an adp file - at least that you use as a recordsource for a combo box anyway. Thus I'm going to...

Ok, so I created a new project, and connected to the database, which then made all that databases tables appear, all with the same names I had them as as...

Ok, I'll do that, but no sp's for now - that will have to come later for technical reasons. As I absolutely detest the record navigation that Access...

Whatever my frustrations were 10 years ago, I've long since forgotten. I just remember converting and then having no means to make changes, and nothing I did from...

Minimal effort? I've been working with Access for a long time, and while I haven't spent much time making the attempt, the effort I did spend led to...

While I agree that the .adp is nice as a best practice, many larger companies simply no longer have the time to invest in the additional complexity, and would more...

Brandie,

I'm going to have to side with Gila Monster on this one - THERE"S NOTHING IRRATIONAL about your fears in that case...

Steve

(aka smunson)

:):):)

GilaMonster (9/12/2008)

Brandie Tarvin (9/12/2008)

"Don't let that developer touch...

Hi All,

Perhaps I can add a few thoughts here... I've been working with Access, Crystal Reports, and SQL Server databases for the last 13 years, and I can...

Perhaps the most important thing for people to realize is that the energy level of the collisions that will take place in the LHC is actually less than the energy...

I tried SELECT-ing those two items from an SSMS query window, and regardless of which server I connected that query to, both items were the same as the ID used...

Interesting. I didn't have a temp table, but I do have a table variable in my query, and once I eliminated a DELETE FROM statement by moving that...