Changing access db to sql db web application.

I am experiencing problems with databases for the web application that i am developing. The problem is that I have transferred the database from access to sql which initially seemed to work ok. I am now however struggling to solve the problems with one of my fields titled 'notes'. The trouble is that in the original database the notes field contained different notes from different dates for each record, and each note is separated by carriage returns. It is the carriage returns that are now proving to be a problem in the sql database but i am not sure what to do. Any advice would be appreciated.
Thanks
Dan
0
dan1980
6/28/2005 10:51:57 AM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

3 Replies
975 Views

Similar Articles

[PageSpeed] 11


You can use Word through OLE to store the notes in Access then import the Word file into SQL Server Image column.   Hope this helps.
Kind regards,
Gift Peddie
0
Caddre
6/28/2005 2:24:50 PM
sorry am not too sure how i would go about using word, what is ole?
0
dan1980
6/28/2005 3:30:56 PM
OLE is Object linking and embedding it allows one office application to import files to another by dragging and dropping.  Try the link below to get started.  Hope this helps.

http://office.microsoft.com/en-us/assistance/HA011472041033.aspx#WhyOLE
Kind regards,
Gift Peddie
0
Caddre
6/28/2005 3:39:11 PM
Reply:

Similar Artilces:

Convert from Access DB to SQL DB....
Dear All,  I would like to convert from Access To SQL DB undervisual Studio.Net 2005... How can I do it easily, or if there any software to do this automaticlly, please your help..  Awaiting your valuable reply. Many thanks in advance for your cooperation and continuous support....Aح What version of MS Access are you using?Most of the Access versions like XP/2003 all have an upgrade wizard that allows you to convert your existing database to SQL Server.In Access 2003 I believe you can use the Upsizing Wizard which can be accessed from Tools -> Database Utilities -> Upsi...

access db to sql db rewright
I am changing a page from Access to SQL express database.  I usually use Dreamweaver Datasets and no problem with them but my hit counter is different.  Can someone rewright this code to work with a SQL database?  If t is possable to use it with a dreamweaver dataset that would be even better but i will take what I can get to learn. ThanksRusty  _________________________________________________________________ <%@ Page Language="vb" Debug=false %><%@ import Namespace="System.Data.OLEDB" %><%@ import Namespace="System.Drawing.Imag...

Access DB instead of SQL DB?
Hi folks, Is it possible to set up a Membership-Type Access DataBase in the same manner as an SQL DataBase with ASP.NET automatically configuring all of the DataBase components so that the DataBase will be the same as an SQL DataBase? In other words, could I do something like create an empty .mdb file, put it in the App_Data folder, and ASP.NET will set up the Tables, Views, Functions, etc. and configure it as I add the Login, Password, etc. Controls? Many Thanks. hypercode: Hi folks, Is it possible to set up a Membership-Type Access DataBase in the...

what needs to be done so can let any users access my sql server db from a web application?
 Hi: There are couple of sql server questions bother me for a while:1. can you please let me know how you make a sql server setting, so all web application users can access the database (create user account, change user account info, add products in shopping cart..., all the processes need to link to server database, do you set a schema called "guest" to those public users? how the connection string tells the database this is a guest, let him/her get the data from this database?(even there is no server login account to match them?)2. Similar to question 1, if I don't want ...

Convert SQL Server DB to Access DB
Hi, I'm trying to convert a SQL Server 2000 database into a Access database because my hosting provider does not support SQL Server. I have tried the DTS, however it can only convert the tables, not the stored procedures. So is it possible to convert the stored procedures as well? I'm looking forwards to your response Phan Nguyen Hello, I believe you need some third-party components to do so, check the links below: MSSQL-to-Access 1.0 MSSQL Migration Toolkit v1.0 All are shareware tools, yuo can download and use them as a trial version. Regards.Bilal Hadiar, MCP, MCTS,...

How to keep SQL DB and Access DB syncronised
Hi, I have a project which i'm trying to do for a client. It starts with an access database on the local client machine, plenty of fields but the main ones are DealerID, VehicleID, Make, Model There is also an SQL server on the internet which drives a website, it has the same fields, DealerID, VehicleID, Make, Model. I need to write an application that reads the local access file and updates the SQL server. What is the best way to do this?, At first I thought delete everything from SQL server then upload everything from Access but that doesn't seem like the best way, Really I ...

BCP Sybase SQL Server db to SQL Anywhere db?
Anyone, I am searching for an automated way to take an entire Sybase SQL Server db on a Unix server and get it into a Sybase SQL Anywhere db on my laptop. I dont feel like going table by table through the Pipeline not to mention that I have RI proplems with this approach as well. Ideally, I would like to have explained to me a way to perform a BCP from the Unix SQL Server world into the windows based SQL Anywhere world. If this is even possible. The model itself is not as important as the data because we use ERwin and I am able to forward engineer the model onto the SQL Anywhe...

BCP Sybase SQL Server db to SQL Anywhere db?
Anyone, I am searching for an automated way to take an entire Sybase SQL Server db on a Unix server and get it into a Sybase SQL Anywhere db on my laptop. I dont feel like going table by table through the Pipeline not to mention that I have RI proplems with this approach as well. Ideally, I would like to have explained to me a way to perform a BCP from the Unix SQL Server world into the windows based SQL Anywhere world. If this is even possible. The model itself is not as important as the data because we use ERwin and I am able to forward engineer the model onto the SQL Anywhe...

BCP Sybase SQL Server db to SQL Anywhere db?
Anyone, I am searching for an automated way to take an entire Sybase SQL Server db on a Unix server and get it into a Sybase SQL Anywhere db on my laptop. I dont feel like going table by table through the Pipeline not to mention that I have RI proplems with this approach as well. Ideally, I would like to have explained to me a way to perform a BCP from the Unix SQL Server world into the windows based SQL Anywhere world. If this is even possible. The model itself is not as important as the data because we use ERwin and I am able to forward engineer the model onto the SQL Anywhe...

Changing the default db from SQL Express 2005 to SQL 2000
How would I change the database from SQL Express 2005 to SQL 2000 on another server. I am using the Small buisness kit that I have downloaded from this site....

How do I synchronise local SQL Server Express db with my online SQL Server 2005 db?
For various reasons, I have a situation where the data in the SQL Server 2005 database hosted by my ISP is more up to date than the data in the matching SQL Server Express database on my own PC. I now want to synchronise these two databases but don't know how to do it. Because I am still developing my ASP.NET 3.5 app, which has not yet been opened up to users, I am only used to synchronising in the other direction by first using the Database Publishing Wizard within Visual Web Developer 2008 Express to create a suitable script associated with my SQL Server Express database and then runn...

Transfering tables and data from one MS SQL DB to another MS SQL DB
I need to transfer tables and data from one SQL DB to another SQL DB. I know it can be done with Server Management Studio and I have searched Studio and Help but can't find any info on the database migration wizard. Hi,jayd  Follow This Link U can Get Help From This For Ur Case    http://forums.asp.net/t/1352620.aspx   PLZ MARK AS ANSWER IF IT HELP U. THANKS. RAGHAV MVP ASP/ASP.Net Read My Blog MARK THE POST AS ANSWER IF IT HELPS U. "Success doesn't come to you…you go to it."--Marva Collins "Success does not come to those who w...

In WSS Backing up DB of SQL 2005 and restore in DB of SQL 2000 giving error
Hi, sometime ago, I have installed WSS and configured using typical option whereby be default SQL server 2005 used for creating the content DB. Later I realize that I need to use SQL 2000 instead because of licensing problem. Therefore, I have re-installed the WSS but now using advanced options and selected SQL 2000 instead. Earlier when using SQL 2005, I have created nearly a complete site and backed up the whole farm. Now with the newly installed WSS, when I try to restore the backed up WSS farm, the restore process giving error saying “the backed up DB is using structure version 611 but c...

publish web application with sql server db
I need immediat help, I have developed web site using visual studio 2005 (ASP .NET 2) and sql server db when I finished testing my site I desided to publish to the web.and then I have the following problem: the host server has sql server 2005 database which OFF the remote connection by default so my web site doesn't work my clients can't login or register or search my db. this error occures  An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL S...

Web resources about - Changing access db to sql db web application. - asp.net.sql-datasource

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Second visa application 'likely' to be approved
The family of a terminally ill Pakistani student can 'hopefully come to Australia sooner rather than later' says Immigration Minister Peter Dutton. ...

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

Tashfeen Malik's visa application under scrutiny - Business Insider Deutschland
The US government has released the visa application for Tashfeen Malik, who along with her husband killed 14 people in an attack in San Bernardino, ...

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 34% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 1.1 percent from one week earlier, ...

Lawmaker: Immigration Officials Didn’t Fully Vet Tashfeen Malik’s Visa Application
"It’s unacceptable that U.S. Citizenship and Immigration Services did not fully vet Malik’s application and instead sloppily approved her visa," ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

Visa application of San Bernardino shooter released
CNN Visa application of San Bernardino shooter released CNN (CNN) The visa application of one of the San Bernardino shooters was released ...

ZTE to develop smartphone application processors in house
ZTE has stepped up its efforts to internally develop smartphone chipset solutions, aiming to re-capture the title as one of the top-three smartphone ...

Resources last updated: 12/24/2015 11:58:14 PM