Problem by design - MS-SQL Server 2000 and MS-Access 2000 project.

Problem by design - MS-SQL Server 2000 and MS-Access 2000 project.

Post by JHB » Fri, 30 Jul 2004 05:13:40


Hi.



Sorry for cross posting!



After I've installed MS-SQL Server 2000, I've got a problem each time I open
a table, view or diagram in design, in a MS-Access project.



Something like a table is popping up, but only the headline of the table,
there is no name in the headline. The (ghost) table is automatic getting
focus, (like a dialog box), and I can't do anything.

I can close the (ghost) table using ALT-F4 combination, but it is very
annoying me.



I've tried to uninstall both the MS-SQL Server 2000 and MS-Access 2000, I've
also tried to compact and repair the database without luck.



If I connect to MS-SQL Server 7 on another computer, (same database),
everything is fine.



My OS is Windows XP Home edition; the MS-SQL Server 7 is running on Windows
98.



Does anyone here have had the same experiences?



TIA

Jn
 
 
 

1. Interface between the MS Sql Server 2000 and the MS Exchange Server 2000

2. OpenQuery Problems with Date Function Different MS-SQL 7 / MS-SQL 2000

hi,



Currently we move a couple of SQL Server 7.0 to SQL Server 2000 and right
now we habe big problems with a OPENQUERY Statement

The SQL Server 7.0 and Windows 2000 is a german version, the MS-SQL Server
2000 and Windows 2000 is in english



The Query on the MS-SQL Server 7 works fine

SELECT * FROM OPENQUERY (ABKG002,

'SELECT DISTINCT NODP.AU_AUD_BENUTZER AS BA_AUD_ERST_VON FROM
V3FADM.AUODP_ORDERPOS_OTAB NODP WHERE NODP.AU_AUD_ZEITPUNKT >
''01.03.2005''')



With the same Query under MS-SQL 2000 is the result

Server: Msg 7330, Level 16, State 2, Line 1

Could not fetch a row from OLE DB provider 'MSDAORA'.

[OLE/DB provider returned message: ORA-01843: not a valid month]

OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowset::GetNextRows returned
0x80040e07].





if we change the Query like below, the OPENQUERY is fine. IS THIS REALLY
only the way the OPENQUERY works fine? That means for us we have to recreate
a lot of VB Applications

SELECT * FROM OPENQUERY (ABKG002, 'SELECT DISTINCT NODP.AU_AUD_BENUTZER AS
BA_AUD_ERST_VON FROM V3FADM.AUODP_ORDERPOS_OTAB NODP WHERE
NODP.AU_AUD_ZEITPUNKT > to_date(''22.03.2005'',''dd.mm.yyyy'')')





Has anybody an IDEA?





thx

klaus

3. executing a stored procedure on MS SQL Server 2000 within MS Excel 2000

4. I cannot upgrade MS SQL Server 6.5 to MS SQL Server 2000

5. Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000

6. CPU usage changed after upgrading to MS SQL Server 2000 from MS SQL Server 6.5

7. best pratices for transferring MS SQL Server 7 database to MS SQL Server 2000

8. Moving data from MS SQL Server 2000 or MS Access XP to UniData 5.2.9

9. MS Project Server 2003 and Ms Project 2000 integration

10. what is equivalent of format(date) function of MS Access in MS Sql Server 2000

11. MS SQL Server 2000 / MS Access - ODBC connection question

12. MS Project Central Server 2000 w/ MS Project 2003

13. MS Project Server 2003 and Ms Project 2000 integration

14. linked and imported tables in MS Access from MS SQL Server 2000

15. MS Project 2000/MS Project Server 2003