Search results for query: *

How do I turn off the sync logs. I want to run in cache mode, but I don't want to have 42 items a day in the sync issues folder. Thanks Rusty

I'll try it. Thanks

How would I.... I have a query which produces a list like so: REP Customer Date sold -------------------------------- John S Ajax 1/1/05 John S Comet 1/5/05 John S Hotel 1/17/05 John s Miami 1/29/05 ..... John s San jose 3/14/05 John...

We are trying this. This seems to be specifically for a "workgroup" not a "domain". I will report back shortly.

I try it thanks.

We don't have one on the inside. We are expecting the PDC and BDC to take of this. (NT 4.0)

I am stumped. I need to upgrade my 40gig to 100gig using a 2.5 laptop drive. I have a PCIMCIA device that allows me to access a second drive on the system. In the past I have been able to use this (and its software) to make a perfect image or bit copy to the new larger drive which then boots...

After setting up W2k pro, I can't seem to get the machine to see the Domain. There is one and I can ping all of the dhcp addresses and the gateway, plus I can get to msn.com. I just can add the new system to the domain and then see the domain. This has happened before, though it is rare. Any...

Thanks! I figured it out. What had happened was, that under XP Pro, Windows updates had loaded a driver for my system's Video card. This "updated" drive somehow check the box in the settings to allow you to run over the edge of the screen. MP was going full screen in a "virtual" screen that...

System Restore was not enabled. Sound is there. on the program bar, WMP shows as minimized, but will not go bigger. Just no video or visualizations.

Media player 10 runs, have a tool bar icon and sound, but no display. Any ideas. Just happened today. thanks

Hi, We have a wired problem here. There are two tables A and B, the primary key (see CID) of table A is the foreign key of table B. Table A is in SQL 2000, table B is in Access 97. When two table join in Access 97, the records will not be returned in the result if CID > 999. We didn't have...

I have a similar problem. In the list box showing the file types, I have a (None) for the extension. This is on several dozen entries. Is there any type of repair process or tool to fix this? Thanks

I made a pass through query to the SQL DB on the biggest table. No help. I am going to do the same for the other 3 smaller tables

Thanks. I understand the principles of the passthrough queries, I don't quite understand the actually mechanical use of them. The description of the query above is this. The query in question is a Make Table query. It contains 11 tables 4 querys that are joined in various ways, all indexed...

Interesting Threads. I am having a similar problem. I have a small desktop, running MSSQL 2000 and Access 97! Yest Access 97. I have a very complex query running in 97 with linked tables to SQL. The query takes about 7 - 10 mins. Not to bad for what it has to do. I purchased a much more...

Thank you for your quack responds. Yeah, I guess I have to change my code then. --Shamous

Thank you for reply. The reason is because this kid of queries are in my VBA code bound with forms. User may a value for ID or they may leave this field blank. If they put 10 in ID, the query will be "INSERT INTO TestTable (Name, ID) VALUES ('userName, '10')", if the user leavs this field blank...

I have a system which Access 97 is front end, and SQL server 2000 is back end. Currently, I am upgrading my Access 97 front end to Access 2000 front end. Some query don't work after the upgrade. There is an example: Table Name: TestTable (in SQL Server 2000) Fields: Name (varchar)...

The fields are only numeric or text, and there are no OLE fields present.