Search results for query: *

On Access form with 2 sub forms Find works at first then stops working. Message is displayed too quickly to read. End of search diaglog box message is not displayed which indicates all records are not being searched for some reason. Specifying form rather than field and any part of field as...

Hi, I am wondering why this SP does not return any rows when executed from Access 2000? [CREATE PROCEDURE [dbo].[UspContaks] @clyent nvarchar(7) AS select * from tabContacts where ClientID = @clyent order by ClientID, ContactKey GO] Access 2000 VBA: [conLocal.Open...

Hi, I am wondering why this SP does not return any rows when executed from Access 2000? [CREATE PROCEDURE [dbo].[UspContaks] @clyent nvarchar(7) AS select * from tabContacts where ClientID = @clyent order by ClientID, ContactKey GO] Access 2000 VBA: [conLocal.Open...

Hi, I am wondering why this SP does not return any rows when executed from Access 2000? CREATE PROCEDURE [dbo].[UspContaks] @clyent nvarchar(7) AS select * from tabContacts where ClientID = @clyent order by ClientID, ContactKey GO Access 2000 VBA: conLocal.Open...

SQL Server 2000 on Win 2000 shows me local drives and shared directory (E$) on a seperate machine when I use "Create new backup device" action in enterprise mgr.

SQL Server 2000 on Win NT 4.0 does not show drives on other servers when I try to create a backup device. On Win 2000, drives on other machines are shown. Why the difference? Thanks.

Original problem has been solved. Thanks.

That virus may have been running on my server while I was installing SP3.

Tried to start SQL Agent through control panel\services. Message is "Procedure entry point SFMAPIOGETPROFILES could not be located in the DLL SEMMAPI.dll". Tried to replace SEMMAPI.dll. Not allowed.

Thanks for help on this. Even though documentation says shut down not necessary, experience says it is.

Result of this error is that Service agent will not start.

Error is occuring during SP installation.

Forgot to shut down SQL Server before installing SP3. Error message "instmsdb.sql can not be opened for write". Subsequent attempts to install SP3 with system shut down fail. Is there a solution short of reinstalling SQL Server 2000? Thanks.

Hi, I just installed SQL Server 2000, the Truncate log on checkpont and Select into/Bulk copy options are missing from the database options screen. What happened to them? Thanks.

The linking fields are ok. Am not adding blank records, the form skips to a new record as if I did want begin a new record before I have a chance to finish the current record. The problem seems to be associated with the key field text box on the main form. The control source is set to the...

After the first of several fields is populated, the sub form saves the record and skips to the next blank record. The tab stops are set correctly. The sub form acts like there is only one field to be populated. Since I am not allowing edits I can't go back and populate remaining fields. Any...

I am working with Access 2000 on Win NT. I created a new workgroup but did not assign password to Admin. I get the message "Not a valid password" when I try to open the database. I don't get a logon screen so I can not enter a password even if I wanted to. I am identified as user...