Search results for query: *

I have an Access 97 database attached with an SQL Server 2000 database I have an nvarchar(255) field that i fill normally with a large textbox in a form. Later, when i see the record, the string i typed is broken in several lines (SQL Server adds some CR-LF) WHY???? Please, help me

I have an Access 97 database attached with an SQL Server 2000 database In Access the query is: SELECT * FROM Table1 WHERE Field1 like FNFilter(); the function FNFilter is: Function FNFilter() FNFilter = IIf(Len(trim(StFilter)) = 0, "*", StFilter) end Function How can i make a...

I have an SQL Server database and an Access97 database linked. When i open some linked tables from Access97 i see this error message: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented (#0) But i can access the data programmatically whithout errors!! (the error message is a...

I have an Access application. I "upsized" the tables to an SQL Server database. I did a lot of tests with a program wich the result was always the collapse of the access and each time i must cancel the task via Windows. After a lot of tests i maked a link to a table and when i opened...

How can i detect if a record (or records) has its Record Selector "enabled" (the record or records are selected)???

In a table my users must view ONLY these records that have a concrete value in a field. Must i make this programmaticaly ???

'When i try to open a linked table i see this error message: ******************************************************************* 'Error in connection: 'SQL State: '01000' 'SQL Server Error 10110 ' [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()) 'Error in...

I have a customer with an Access connected with an SQL Server Db. The problem (i suppose) is that ALL USERS ARE USING THE SAME .MDB (exactly the same file, not a copy!!!) After some weeks of normal use, progressively, the connection Access-SQL Server failed. Today, they can open the Access DB...

Is it possible to link a web page with an Access database to get images???

Is it possible to link image controls to an Access Database ?? How????

I access to a SQL Server 2000 database from an Access 97 aplication. I'm not able to make an error-handling program that works fine. I can't catch the Error number. I get the same error code even if i try to delete or to add a record. I looked the Errors collection, but...

I HAVE AN ACCESS TABLE WITH A LOT OF PHOTOS. I WANT TO CREATE SEVERAL WEB PAGES BUT I DONT WANT TO RE-CREATE A PAGE WHEN I MUST CHANGE A PHOTO. HOW CAN I "EDIT" A WEB PAGE GETTING THE PHOTO FROM AN ACCESS TABLE ???

I WANT CHANGE AN IMAGE FROM A WORD DOCUMENT (FORM VB, OF COURSE), BUT I CAN'T ACCESS TO THE 'PICTURE' PROPERTY (THE PATH OF THE IMAGE FILE). I FOUNDED THE DOCUMENT.SHAPE.OLEFORMAT OBJECT, BUT ...

I have an Access table with a lot of photographs. I must create a program that allows the creation and MAINTENANCE of web pages based on that photos. I tried with templates, but the images are not Exported !!!!