by Tod Thame » Sat, 22 Jun 2002 03:58:16
by Johnn » Sat, 22 Jun 2002 04:46:52
Quote:> I had an access database that was converted to SQL Server
> 7.0. I did this
> to get automatic updates and to share it across the
> network. When I imported
> the tables, one table had several memo fields. These memo
> fields were converted
> to text in SQL Server. When I try to manipulate the data
> from with Access
> (which is my frontend), I get an error message. When I
> change the field
> to nvarchar with a size of 4000 which would be enough, the
> access frontend
> only allows 255 characters. Is there any way around this??
1. Dr. Watson Errors (SQL-Server 7.0 backend, MS Access 97 frontend)
Hi!
I am running a multi-user MS Access 97 database as a front end to a
SQL 7.0
backend on Windows NT 4.0
My customers get a lot of unexpectable Dr. Watson errors at various
times. I appended a part of the Dr. Watson log-file at the end of this
message.
Each Dr. Watson error causes the Access front end to crash and the
users have to start it new :-(( - this way they can't use the program
....
On my computer, I never get the Dr. Watson ...
My customers have a newer version of the odbc-driver than me and they
have SP6 installed (I have SP 5) - may this cause the problem ?
Please help me !
Thanks in advance,
Christine
The log-file of Dr. Watson:
Application exception occurred:
App: (pid=334)
Exception number: c0000005 (access violation)
*----> System Information <----*
Computer Name: H02813
User Name: KRALAPI
Number of Processors: 1
Processor Type: x86 Family 6 Model 8 Stepping 3
Windows Version: 4.0
Current Build: 1381
Service Pack: 6
Current Type: Uniprocessor Free
Registered Organization: ABB Power Generation Ltd
Registered Owner: ABB Power Generation Ltd
*----> Task List <----*
0 Idle.exe
2 System.exe
21 SMSS.exe
24 CSRSS.exe
35 WINLOGON.exe
41 SERVICES.exe
44 LSASS.exe
68 SPOOLSS.exe
82 amgrsrvc.exe
89 cpqalert.exe
95 WEBDMI.exe
98 CPQWMGMT.exe
103 PDS.exe
111 wuser32.exe
122 ISMDIST.exe
134 Mcshield.exe
137 VsTskMgr.exe
157 RPCSS.exe
163 SNMP.exe
179 Win32sl.exe
183 wm.exe
194 XFR.exe
203 PSTORES.exe
207 mstask.exe
212 MSGSYS.exe
238 cpqdmi.exe
252 NDDEAGNT.exe
269 EPopU.exe
59 EXPLORER.exe
277 systray.exe
275 nwtray.exe
285 chkadmin.exe
272 EM_EXEC.exe
177 PPTD40NT.exe
265 INSTAN~1.exe
278 fpdisp3.exe
235 shstat.exe
236 LOADWC.exe
307 AcroTray.exe
303 NLNOTES.exe
284 NWRDAEMN.exe
318 NUPDATE.exe
64 NALDAEMN.exe
316 excel.exe
315 IEXPLORE.exe
334 Webshots.scr.exe
355 WebshotsTray.ex.exe
282 DRWTSN32.exe
0 _Total.exe
3. MS-Access 97 to SQL Server to MS-Access 97
5. Writing datetime to Sybase 4.2
6. Migration from MS Access 97 to SQL Server 7.0
7. Help: sequencial numbering/flattening a table
8. Merge Replication against Access 97 with MS SQL Server 7.0
9. Very slow response from SQL Server 6.5 with ACCESS 97 frontend
10. Getting Image from BMP file to SQL Server w/ Access 97 Frontend
11. MS ACCESS 97/SQL server 6.5: deadlock problems when accessing server tables
12. MS Access 97 SQL to MS SQL SQL SQL SQL