Search results for query: *

Actually, it was the Access object model that was giving me problems -- I was using CurrentDB instead of CurrentProject. If I use Application.CurrentProject.execute([some sql statement]), the VBA code uses the project's connection to the SQL server database.

Hi there, I apologize for the cross-post -- I should have started with this forum. I have an MS Access project that connects me to a SQL Server database. My forms are all working fine, but I've been trying to figure out how to get at the data programmatically, using VBA. I'm assuming that...

Hi there, I have an MS Access project that connects me to a SQL Server database. My forms are all working fine, but I've been trying to figure out how to get at the data programmatically, using VBA. I'm assuming that since the project is already connected to the database, that I don't have to...

Ahhh I see. I'm storing the values from form1 as hidden values in form2. That's how they're ending up back in form1 when the user returns, and getting in the way of a second submission. So I guess I'll have to update to the database on each form. It seemed like a harmless decision at the...

Hi mwolff00! Sorry, I should have been more explicit. After form1 is submitted, the value is added to request.form and the user goes on to form2. Values are updated to the database only when all forms (form1, form2, etc) are complete. I'd like the user to be able to return to form1, enter a...

Hi! I'm working on an online questionnaire (ASP with SQL Server db). I fear i've painted myself in to a corner.... I'd like to let the user return to a question that they've already submitted to the request.form object, and provide a new answer that replaces the old one. If I just submit a...

Hi there! I just installed SQL Server 2000 Developer Edition on a machine running XP Professional Edition. For some reason, I get an error whenever I try to connect to the local server. The error messages are login errors -- server does not exist or access denied. I've tried through...

Fixed it! Master.dat was busted somehow...just used the Fix Master.dat option in the setup utility...

That's fantastic! See, I'm new to SQL Server (and on the beginner side of ASP). I've just upsized this from Access to SQL Server, and I've been wondering which executions would be prime candidates for stored procedures -- sounds like this is one! Time to learn about stored procedures What's a...

Hey mwolf00, Thanks for the response. I am the only one using this server -- wacky, eh? I'm not sure what the problem is. The only workaround I've found is to create a second connection that the re-iterating recordset uses. This solution tolerates a slightly larger Answers recordset, but not...

Hi There! I'm having a hard time with my ASP connection to SQL Server 6.5. I'm looping through a recordset, and each iteration sets and frees a couple of other recordsets. (Code below.) I think I'm being really good about creating as late as possible and freeing as soon as possible, but I'm...

Hi There! I'm having a lousy afternoon! I'm trying to connect to a registered server with Enterprise Manager (SQL Server 6.5). The server is running, my ASP app can connect, Query tools all work fine, but I can't connect. I double-click on the server, and here's the error message: "A...