Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Corrupt data

 
   Database Help (Home) -> ODBC RSS
Next:  SQL Server Ingrated services 2005  
Author Message
Justin

External


Since: Aug 12, 2008
Posts: 4



(Msg. 1) Posted: Wed Nov 12, 2008 11:15 am
Post subject: Corrupt data
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

I'm using ODBC to connect SQL database to an Access front end. The coonecnt
works unless I look for a cetrain part number. I believe this data is
corrupt. I cannot delete the data from Access. Is there a way to handle
this corruption on the SQL side?

 >> Stay informed about: Corrupt data 
Back to top
Login to vote
Sylvain Lafontaine1

External


Since: Dec 13, 2003
Posts: 301



(Msg. 2) Posted: Sun Nov 16, 2008 1:09 pm
Post subject: Re: Corrupt data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yes, you can start Query Analyser if you are on SQL-Server 7 or 2000 or SSMS
(Sql Server Management Studio) if you are on SQL-Server 2005 or 2008 and
handle this problem. However, before proceeding any further, you should be
sure to know what you are doing; otherwise, you could end up in a much worse
situation than before.

Finally, there is no certainty that your database is corrupt and maybe that
you simply have a problem with your Access interface unrelated to any
corruption problem. You should really ask someone who knows a lot about this
and/or about your system instead of starting to play with it.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Justin" wrote in message

> I'm using ODBC to connect SQL database to an Access front end. The
> coonecnt
> works unless I look for a cetrain part number. I believe this data is
> corrupt. I cannot delete the data from Access. Is there a way to handle
> this corruption on the SQL side?

 >> Stay informed about: Corrupt data 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Can MSQUERY update data? - Can MS Query be used to update data within a database? I have tried replacing SELECT with UPDATE but no luck... Thanks Richard

Data import revisited - I have posted on this previously but can't find my post. So my apologies for asking this again. We have a unix DB that I want to import into an SQL 2005 server. We have a 3rd party ODBC driver to do this but when I try to import a table from the DB I...

how to mapped the ms access db data to ms sql server - I need to create an ASP.Net page that connects to an MS SQL server as its dbase. But the MS SQL server is really connecting to an MS Access db to get the data.How can I mapped the data of the ms access db so that when my ms sql server connects it can....

Exporting Rich Text Field data - I have an SQL 2000 database (used by a CRM package), and the field that contains what we call 'History' is a Rich Text Field. It basically starts like this: {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;} [more follows here]. If I cut and paste..

miising oracle odbc data provider - Hi Gurus, This is a question that I may have asked in the past on another forum I think it was not the right forum well here goes... I have an instance of sqlserver2005 64 bit and I need to be able to link it to an oracle 11g server for the transfer of....
   Database Help (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]