Viewing 15 posts - 1 through 15 (of 18 total)
Amit,
I think you are right, but I am not dropping it, Enterprise Manager is dropping it. I wonder why it decided to drop and recreate this particlar function and not...
May 21, 2005 at 6:59 am
Thanks for your reply robrador. I since have learned that our problem was the result of People Soft scripts that use the Y in PSY as a way to generate...
March 12, 2005 at 6:53 am
I hope this aligns ok:
| name | PSYSCHOOL_TBL | PS_SCHOOL_TBL |
| id | 261680080 |
September 20, 2004 at 7:26 am
As others have mentioned, running the application from the user’s local drive has several advantages. One big advantage is the ability to use code to...
June 10, 2004 at 12:49 pm
You could have your ACCESS users build a base ACCESS query against the linked table rather than using the linked table directly. This base query...
June 10, 2004 at 12:09 pm
Your OR statement is the most suspicious. Try putting parentheses around the entire OR associated clauses like this:
… pat.pat_id > 0 AND
June 10, 2004 at 10:28 am
I am running SQL Server 2000, service pack 3, and still have the problem. So perhaps it will be fixed in service pack 4. I did not try to install...
April 29, 2004 at 7:30 am
You could try using the MAXDOP 1 hint to see if parallel processing is the culprit. Also, I have read in these forums that breaking...
March 29, 2004 at 8:26 am
Of course. Many thanks,
JFW
March 10, 2004 at 10:09 am
mkeast,
Thank you for your suggestion. I could probably make it work ignoring unused columns, but I ended up using code similar to Antares686 example above.
Thanks to everone for their ideas.
JFW
February 12, 2004 at 12:28 pm
lenmcmanotony,
Great idea. Thanks, JFW
February 11, 2004 at 10:43 am
Antares686,
Thank you for your very quick response. I will report back if I hear from MS.
JFW
February 11, 2004 at 9:05 am
I developed a small application (10 users, 12 tables, largest table 38K rows) using Access 2000 front end and SQL Server backend with linked tables. It has been running fine,...
November 25, 2003 at 9:21 am
We are running SQL Server 2000, SP3 Standard Edition on Windows Server 2000 SP4 with 4 gig of memory and a 4 gig swap file. My current settings in EM...
November 18, 2003 at 12:29 pm
If the view and table are in the same database, EM, table, All Tasks, display dependencies is a nice interactive way to view all dependencies. It's a shame it does...
November 12, 2003 at 8:34 am
Viewing 15 posts - 1 through 15 (of 18 total)