Saving into a Database

[MadCrazyNewbie]

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]

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

 

[Matt S]

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.

 

[bonehead]

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]

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.