Search results

Thanks again. I have a recordset (one table) that I open, update(one field) and close the rs with ADO. After doing all of this, the table remains inaccessible and I can't access it through Enterprise Manager or Access. Is there something that you can think of that would cause the table to...

thanks. boblarson, So this would have no effect on locking tables/recordsets? As long as the recordset is closed?

hello, quick ADO question... Must I (set rs = nothing) when I'm done? I've always done that, but seeing a lot of code that neglects doing so. Is it advisable to do or can I merely use. (rs.close) What are the consequences of not setting = nothing? Also, should I wait until I'm finished with...

This error was being caused by RI rules that were setup in SQl and not in access. Thanks to all who responded.

I'm using linked (Access 2000-SQL Server 2000) connection. The code is written as if updating tables directly in Access, but they're linked to SQL. I've never used this type of setup. Not sure why there would be any differences bewteen the two. Most of the ado code works fine. It's just a times...

Good point! The code opens a table and updates a few fields and closes it. Then opens the same table and tries to AddNew or Update records and the application crashes with an ODBC failure. Is it possible that SQL Server-Access linked databases lock the tables after the recordset is closed with...

Hello, I have an Access to SQL Server linked database with a VB front-end. It seems to be linked correctly and permissions seem to be set up fine. I am able to execute queries of all types, select, insert, update from vb. I am also able to run ADO code to update the recordset. However, when I...

Gottchya!!! Thanks.

Thanks for your reply. Hmmm. I thought I got this syntax from Access help. Wierd. I'll have to check that again. Still confused though...Are Access temp tables different than say, SQL Server temp tables w/ in SQL you put a ## in front of the name to make it a temp? Can you give me an example...

I would like to create a "global" temp table that can be viewed by all users. The syntax is: Create [TEMPORARY] TABLE tablename (field type) QUESTION1: When I put the optional [TEMPORARY] in, I get a syntax error... Create [TEMPORARY] TABLE t (ID int) I've tried... Create TABLE [t] (ID int) Is...

Thanks for your response. this is a private company's application and I can't post the code directly due to company policy so I may be on my own here. Any ideas are welcome though.

I'm supporting an app. that I did not create that has different "types" of users. There's a button that's supposed to fire an event. It works fine when I'm one type of user, but if I log in as another type of user, the event never fires when the button is clicked. I've set a breakpoint in the...

pbaldy, Great! I'll look at that and see if it works. Thanks a lot. Casey

pbaldy, My function does just that...loops through the StoreNumber fields for each LogNumber and creates a string with all the StoreNumbers in one field stored in a temp table. If your solution requires the string to be stored in a field in a table somewhere... then this is what I'm trying to...

Thanks for your response. Any ideas how i could get this from a query? Right now i have a function to do just what this article suggests, but this information is used in several places so a temp table is being used to hold this de-normalized data and the "concatenated" string may exceed the...

Hello, i am trying to join the results of a many-side of a query into one result field separated by commas... Table: tblWorkOrderStoresFinal Row 1: LogNumber: 1 StoreNumber: 2 Row 2: LogNumber: 1 StoreNumber: 3 Row 3: LogNumber: 1 StoreNumber: 4 I would like to make a query that combines...

Thanks everyone for you help on this.

Thanks. Yes, setting a filter works. Thanks for your help.

Hello all, "Filtering" a recordset I have a DAO.recordset that gives me sales for a range of dates pulled from SQL Server. Once I've connected to the Recordset, I would like to apply a "filter" to the same Dataset several times to find a particular salesperson, crunch some numbers, then remove...

I thought that I could create this module and then reuse it when I needed to. Maybe I have the wrong idea as to what modules are intended to do.