Viewing 13 posts - 1 through 13 (of 13 total)
I think we are going to rebuild the server as am really stumped about what is the problem...I recreated the tables and imported the data onto my computer (without indexes),...
March 5, 2004 at 6:54 am
Hia All,
This is driving me mad.... I moved the database to a different server to see if it was still as slow, and it was.... As this database is a...
March 5, 2004 at 3:33 am
None of the tables have any indexes on them as they are not that big....The queries were running fine until yesterday morning. I am a novice so am not really...
March 4, 2004 at 6:42 am
I didn'tdesign the schema - I inherited it. We do have a members table with a memberid for each person and a supporter number linking back to the original supporter...
December 19, 2003 at 4:35 am
quote:
I have used an ActiveX task, or an execute command task that runs a VBScript to open the Excel file, refresh the...
November 28, 2003 at 2:43 am
Sorry for being dense, but does the sql server startup account have to have Administrator rights?
November 3, 2003 at 4:05 am
oops- my fault for not reading BOL properly.
thanks!
October 31, 2003 at 3:37 am
Having one payments table would work fine for one-off payments such as credit card, cash etc, as I could record the amounts and then have a 'transaction key' to link...
September 22, 2003 at 2:31 am
Thanks for the response.. I have a few quick questions though..
Would the 'staging' database be an exact copy of the 'live' database?
As I get an entire copy of the database...
September 16, 2003 at 1:48 am
Hia Frank
No I didn't revoke access for the Builtin\Administrator.
Noone has change anything, yet the Administrator is listed as being 'via group membership'. If all i need to do is...
June 17, 2003 at 5:01 am
The problem is that when i test IsDate on it (in the access module visual basic test - i have no other way of testing!), it converts the date of...
June 12, 2003 at 2:45 am
thanks for the prompt reply! Is it better then to have data that may be null for many customers in table1, than splitting it out to table2? Table6 is for...
April 11, 2003 at 3:50 am
Viewing 13 posts - 1 through 13 (of 13 total)