Recent content by ljvb7

Added SET ROWCOUNT 0 (no change in number returned) SELECT * FROM DCRDeptEncounters, DictPT WHERE DCRDeptEncounters.PtType = DictPT.PType (I've moved the order around without any affect) query returns 10 rows. If I add another parameter (e.g., and PType = 'O', or the other value, I get that...

Thanks for responding. I switched the statement form without change. When retrieving data from the table, view, or table joined to view seperately, I get expected data. I copied the view into SQL Query analyzer, changed the view name +1, added a space for a new created date, and reran the query...

In SQL Server2000 in our production environment, I use a SQL statement to create a view that isn't working in the latest implementation. I isolated the problem to a select statement to retreive records from a view and a table; Select (multiple values from table) where View.PtType=Table.Ptype...

I need to create a command button in my VB6 project which will open a particular Access2000 database up in form view. I thought I could use the OLE Control from the toolbox, however, it does not offer Access as an option. I tried to add it as a component, but couldn't select it. Anyone ever done...

Dougp, you know I inherited this part of the code, the writer linked & unlinked each table before updating, he's long gone, but I assume it was to maintain or ensure the jet connection. In further development, I could experiment with rem'ing out that code, but this is daily production, and I...

The code in question unlinks then relinks a SQL table thru an ODBC connection, then initializes the table, then transfers comma delimited text. I am getting the error 3155 regularly lately, and the table values are valid, and the permissions are ok, so it seems that I am losing the ODBC...

Getting an getting error - Microsoft jet engine cannot find object, "MSysDb" when opening a Access 97 database in Access 2000. We like to create, modify or delete permissions or object?