Link table from SQL Server

Hello, I am using Microsoft Access97 and using a linked table from MSQL7.0. I can link the table with no problem, but when I try to add data or change data, 1 of two things seem to be happening. 1ST I will get a message saying that someone else has changed the current record... which is impossible, since I am the only one who has access to this db... after while it will let me add records, however, when I look at the linked table, every other row is filled across with the word #DELETED
When I look at the table using sql Enterprise Manager, everything looks fine. Does anyone know what is going on here?

Tagged as: link table sql server


Probable answsers

of course I searched google and I saw all the results. However, the documentation is kinda spotty. but no matter, I was finally able to get it to work. I will place a tutorial on this hopefully ...

you need to paste your exact code as well as the exact errror here...

I don't know the exact effect you want, but the REPLACE or UPDATE keyword should be explored.http://www.google.com/search?hl=en&q=sql+REPLACEBefore you ask. I will not supply your sql command. It's my policy ...

Dear John, does your motherboard accept ECC RAM? http://www.newegg.com/Product/Productcompare.aspx?Submit=Property&N=2010170541&OEMMark=1%2C0&PropertyCodeValue=521%3A8080%2C523%3A7859%2C523%3A8477%2C523%3A15794%2C526%3A7868%2C527%3A7870&bop=And&CompareItemList=N82E16820134312%2CN82E16820146525%2CN82E16820148114%2CN82E16820148115 ...

I generally use the web to research things I need to do. Unless you are trying to learn it from the ground up, go for it!


Similair questions

I am trying to update all recors in one table with records from another table. My script is only updating one record. How do I fix this? This is what I have:set rec1=con.execute ("SELECT * FROM Cancels ORDER ...

I am a Network Administrator going back to school for a degree. I am mainly taking BSIT classes with electives in Web Programming. I have heard a few people talking about this book (and I ...

Hi, i was wondering if there are anyone tat can assist me or perhaps enlighten me on this sql problem i have; i need to create a dynamic table in sql; it has X number of columns. X is based on the number of records ...

hey guys, I need your help again. I am on Redhat 8 machine and need to be able to access a MS sql server 2000 database on win NT machine using ODBC. I know there are some perl Modules for ...

I need to be able to direct my backups to the network. However, when I create the backup, my only option is to put it on one of the drives on the server. My server is running out of space, so I really ...

Hi I have a database that was made in sql server 2000....I have the mdf and ldf files. Due to certain constraints and requirements, I want to have the same database in Access 2007. So, is ...

I have experience using Oracle 10g, but was wondering if anyone knew of a simular free sql server I could use? Preferably something that can be run on a Windows Machine. I will go Linux if ...

hi guys....can someone expert guide me how to connect a database in sql server with visual basic, ive read other tutorial but seems its hard to understand and failed to applying in my program. ...

Hey, We have a bunch of DTS packages that copy data to sql server 2000. I need to find out where data gets capitalized. Can a DTS package perform capitalization on its own (via settings/parameters), or ...

anyone knows where I can get a studenti edition of Visual Basic and sql server ? I'm thinking of starting a personal project with .Net and Visual Basic and sql server. It would be very expensive if I get everything ...

Hello, I installed sql server Management Express edition for a user to access the main sql 2005 server but they want the agent as well so that they can schedule jobs. However the express edition doesn't ...

an article regarding the Spida worm infecting sql servers. source: http://theregister.co.uk/content/55/25392.html - - - - - sql server worm throttles bandwidth By John Leyden Posted: ...

i want to virtualize a 2k8 server with a small sql database, a hosted program we use here, and "Remote Applications" feature of 2k8 for terminal services type hosting of that app.... i was told ...

For all you dba types out there, here a break from the usual linux threads. Our dba just got let go. so, I'm back at it after a four year hiatus. Unfortunately it is Msoft related but ...

I have a 480 VAC, 3 PH MCC with feeder cables of 3 parallel 500 MCM/phase. One of my buckets feeds a 45 KVA transformer; 480-208/120 vac, 3 PH. The primary feeders to the Xfr are 3-#4. The secondary ...

Yup came across it at another forum. http://neworder.box.sk/tomread.php?newsid=2870

What I have is a dinningroom table that my roommate cooled a glass muffin dish on and now I have burnt finnish that has turned white. My question is how do I fix the spots ??? Can anyone help me ...

Intel P-4, 2.4GHz, 533MHz Bus, 1MB Cache 160GB SATA150 HD 512MB Dual-Channel DDR400 SDRAM 2,000GB Monthly Transfer 5 IP AddressesWoo, can't wait to use that hard drive space. Hellooooooooooo ...

May be anybody knows. Is it possible to use Nokia 770 like Wacom's (or others similar) table ?