asked on

EXCEPTION_ACCESS_VIOLATION???

hi, when i trying to import a table from MS Access file, i got this error msg:
EXCEPTION_ACCESS_VIOLATION

what does this mean?

SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

InNoCenT_Ch1ld

ASKER

my code? i dun use any code.
i am using enterprise manager to do the import/export.

first, i export the table from sql server located at my server into MS Access file.
then i copy the MS Access file into my notebook and trying to import the table into the sql server on my notebook.
i thought that it is just a very straight forward thing to do..

Anthony Perkins

You would think so, but I am afraid I have no idea.

Anthony Perkins

See if this helps:
FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server 2000
http://support.microsoft.com/kb/830773

And yes you are using DTS.

Anthony Perkins

On second thoughts, that is unrelated.

Sorry I could not help more and good luck.

InNoCenT_Ch1ld

ASKER

;-(

Guy Hengel [angelIII / a3]

how exactly are you trying to do this?
what version of sql server / service pack?

InNoCenT_Ch1ld

ASKER

>>how exactly are you trying to do this?
i did everything in Enterprise manager. right click, all task, Import Data/ Export Data

>>what version of sql server / service pack?
sql server 2000.

the server's sql server = unknown ( i believe it has never been updated)
notebook = sp4

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

InNoCenT_Ch1ld

ASKER

hmm, result return is service pack 1.
alright, i think i will update the sql server to sp 4.

tks everyone.