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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.