Hey Group,
I wounder if somebody could possibly help me a little?
Is it possible to store XLS and DOC files into a MSaccess Database, or SQL
Database?
If so anybody got any links or tips?
Also Looking at SQL on and offline. I mean I would like to have a SQL say in
the office and have 3 Latops, I would like to be able to Syncronise the SQL
data to the Laptops so that we could view and run CR offline.
I could live without been able to update it offline, but is there a way to
like syncronise that data from the laptops back to the Main SQL server?
Again, anybody got any links to some info?
Many Thanks
Regards
MCN 6 1434
"MadCrazyNewbie " <te**@nospam.co m> schrieb im Newsbeitrag
news:QR******** ************@ka roo.co.uk... Hey Group,
I wounder if somebody could possibly help me a little?
Is it possible to store XLS and DOC files into a MSaccess Database, or SQL Database?
If so anybody got any links or tips?
Also Looking at SQL on and offline. I mean I would like to have a SQL say
in the office and have 3 Latops, I would like to be able to Syncronise the
SQL data to the Laptops so that we could view and run CR offline.
I could live without been able to update it offline, but is there a way to like syncronise that data from the laptops back to the Main SQL server?
Again, anybody got any links to some info?
Many Thanks Regards MCN
Hi MadCrazyNewbie,
Write the files as BLOBS to the access database: http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp
Greeting
Thomas
SQL Server supports replication which sounds like what you need.
Have a look in SQL Servers Books On Line under replication.
Hope this helps.
Matt.
"MadCrazyNewbie " <te**@nospam.co m> wrote in message
news:QR******** ************@ka roo.co.uk... Hey Group,
I wounder if somebody could possibly help me a little?
Is it possible to store XLS and DOC files into a MSaccess Database, or SQL Database?
If so anybody got any links or tips?
Also Looking at SQL on and offline. I mean I would like to have a SQL say in the office and have 3 Latops, I would like to be able to Syncronise the SQL data to the Laptops so that we could view and run CR offline.
I could live without been able to update it offline, but is there a way to like syncronise that data from the laptops back to the Main SQL server?
Again, anybody got any links to some info?
Many Thanks Regards MCN
SQL Server supports replication which sounds like what you need.
Have a look in SQL Servers Books On Line under replication.
Hope this helps.
Matt.
"MadCrazyNewbie " <te**@nospam.co m> wrote in message
news:QR******** ************@ka roo.co.uk... Hey Group,
I wounder if somebody could possibly help me a little?
Is it possible to store XLS and DOC files into a MSaccess Database, or SQL Database?
If so anybody got any links or tips?
Also Looking at SQL on and offline. I mean I would like to have a SQL say in the office and have 3 Latops, I would like to be able to Syncronise the SQL data to the Laptops so that we could view and run CR offline.
I could live without been able to update it offline, but is there a way to like syncronise that data from the laptops back to the Main SQL server?
Again, anybody got any links to some info?
Many Thanks Regards MCN
thomas wenning wrote: Hi MadCrazyNewbie,
Write the files as BLOBS to the access database: http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp
Either that or upload the files to some other directory, and create a
hyperlink field, and store the fullpath as a hyperlink. I wasn't even
sure if that would work until I just tried it for kicks a couple of
years ago. If the app and file directories are on the same machine it
works like cake, and if they're networked you can just use a unc instead
of a drive letter. Plus it makes file size management much easier.
thomas wenning wrote: Hi MadCrazyNewbie,
Write the files as BLOBS to the access database: http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp
Either that or upload the files to some other directory, and create a
hyperlink field, and store the fullpath as a hyperlink. I wasn't even
sure if that would work until I just tried it for kicks a couple of
years ago. If the app and file directories are on the same machine it
works like cake, and if they're networked you can just use a unc instead
of a drive letter. Plus it makes file size management much easier.
bonehead wrote: Either that or upload the files to some other directory, and create a hyperlink field, and store the fullpath as a hyperlink. I wasn't even sure if that would work until I just tried it for kicks a couple of years ago. If the app and file directories are on the same machine it works like cake, and if they're networked you can just use a unc instead of a drive letter. Plus it makes file size management much easier.
PS You can also upload the files to a directory you create on a web
server and just store the urls in a hypertext field. That's even easier. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Roy Gourgi |
last post by:
Hi,
Is it possible to save to a database as opposed to saving to a flat .txt
file? It could be any database program, such as FoxPro (preferably), SQL
Server, MySQL. Furthermore, I would also like to know if I would also be
able to retrieve information from these databases?
TIA
Roy Gourgi
|
by: manning_news |
last post by:
Has anyone had a problem with Access 2003 not saving their coding?
I've been using 2003 for a couple of months now and just this week
noticed that some coding I'd done for a database was not there anymore.
I reentered it and didn't have any problems for a couple of days.
Today I entered some coding, saved it, opened another database, and
when I opened my original database again, the coding I had entered was
missing.
Access 2000 always...
|
by: Robm |
last post by:
Since googling this issue only brings up the April fool's problem, which was
solved years ago, I hope that somebody can help me with this. I have a large
vc++/mfc application which needs to know when DST is in effect. This has
been working fine for years, but I am worried about the upcoming change in
2007 in the US, which will be followed by a number of Canadian provices
(where my application is used). The function that I use is very...
|
by: Pedro Leite |
last post by:
Good Afternoon.
the code below is properly retreiving binary data from a database and saving
it. but instead of saving at client machine is saving at the server machine.
what is wrong with my code ??
thank you
Pedro Leite From Portugal
------------------------------------
|
by: sameer |
last post by:
Hi all,
..net framwork 1.1
sql server 2000
I have a vb.net winforms application using webservices\ remoting to
upload documents\ images to the webserver and i am gong to store them in the
sql server 2000 database and before these are saved to the
database client wants me to scan them for any kind of viruses i.e do a virus
scan,
how can i do that, have any body done this before. if it was a matter of
| |
by: sameer |
last post by:
Hi all,
..net framwork 1.1
sql server 2000
I have a vb.net winforms application using webservices\ remoting to
upload documents\ images to the webserver and i am gong to store them in the
sql server 2000 database and before these are saved to the
database client wants me to scan them for any kind of viruses i.e do a virus
scan,
how can i do that, have any body done this before. if it was a matter of
|
by: Mark Denardo |
last post by:
My question is similar to one someone posted a few months back, but I don't
see any replies.
Basically I want to be able to have users upload photos and save them in a
database (as byte data) and be able to load them to an image webcontrol, but
system.web.ui.webcontrols.image only seems to have a control to load the
image from a URL.
There's no way to load this directly without saving the image as a file and
then using...
|
by: Allie |
last post by:
Hi, all.
This might be a silly question... but I am very new to programming in
SQL so please bear with me :)
So. I'm using MS SQL Server 2005 Management Studio Express. I have a
table that was created via an existing .sql file. Included were a
bunch of stored procedures. I went in to re-format these procedures.
(They were written in haste by another programmer. It is my task to go
back and improve their readabilities.) However, I am...
|
by: madhu raju |
last post by:
iam saving the data into Ms-Access database using Vb.net Application
In that application iam using Data grid view to save the data into the database
Here in the below code iam saving the name of stalls into the database
i have to save according to number given in the textbox .but first i saved only two stallnames and next time i want to save the remaining stall names then it is not possible it checks the starting two stallnames and...
|
by: Nathan Sokalski |
last post by:
I am using ASP.NET 2.0, and need to know how to save and use an image that
is stored in an SQL Server image datatype. How can I do this using ASP.NET?
Thanks.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |