Viewing 8 posts - 1 through 8 (of 8 total)
Thanks William - I have fixed the problem although I can't quite put my finger on how. I think you were right in that some of my code was not...
July 26, 2007 at 4:39 pm
You need to index the table at the database side of things - ie set a primary key.
July 22, 2007 at 9:46 pm
Found the problem - I installed Visual Studio 2003 after Office 2007 Pro - I ignored the issues warning - must have overwritten on or more of Access dll's -...
June 4, 2007 at 11:19 pm
I did a bit more on this and did a trace on the ODBC DSN and picked up the following error message:
DIAG [S1000] [Microsoft][ODBC Driver Manager] General error: invalid window...
June 4, 2007 at 7:59 pm
Found the problem - I had the wrong secutity level for the users in the SQL Server database....
Barry
May 29, 2007 at 11:02 pm
Sorry - i forgot. if you are running XP with the firewall on you will also need to enable port 1433.
Barry
April 4, 2007 at 12:14 am
When you install MSDE engine the network protocols are disabled by default. You need to run SVRNETCN and enable TCP/IP before external devices can talk to your database.
Barry
April 3, 2007 at 10:44 pm
Why not sp_detach_db from Vs7 and sp_attach_db to 2005 - database will be automatically updated to new version during attachment. Also easy to test with copy.
July 24, 2006 at 11:43 pm
Viewing 8 posts - 1 through 8 (of 8 total)