Click here to Skip to main content
15,902,939 members
Home / Discussions / Database
   

Database

 
QuestionHow to set null values in dataset ? Pin
susree9-Nov-03 19:46
susree9-Nov-03 19:46 
AnswerRe: How to set null values in dataset ? Pin
Mike Dimmick11-Nov-03 10:22
Mike Dimmick11-Nov-03 10:22 
GeneralRe: How to set null values in dataset ? Pin
susree11-Nov-03 17:53
susree11-Nov-03 17:53 
GeneralMS Access Database Connection with VB.NET Pin
EdZa8-Nov-03 12:21
EdZa8-Nov-03 12:21 
GeneralRe: MS Access Database Connection with VB.NET Pin
Pauwll8-Nov-03 16:27
Pauwll8-Nov-03 16:27 
GeneralRe: MS Access Database Connection with VB.NET Pin
Mike Dimmick11-Nov-03 10:24
Mike Dimmick11-Nov-03 10:24 
GeneralRe: MS Access Database Connection with VB.NET Pin
Member 59242011-Nov-03 19:20
Member 59242011-Nov-03 19:20 
GeneralConverting from SQL server to MS Access Pin
pankajdaga8-Nov-03 12:05
pankajdaga8-Nov-03 12:05 
Hi all,

I know most people want it the other way around.

The application I am developing uses the data that is on an SQL server. However, most of my clients are mobile and do not always have access to that server from outside for security reasons. Basically, what I want to do is have them go to my ASP.NET page and have the option to have the database exported as an access database so that they can use it when they are mobile. Most of them do not have an SQL server installation on their laptops and will never have it. The company provides them with the laptops and they do not have the rights to install anything. I would go for MSDE, but there is no way they will agree to this. It is all too damn beaureucratic! So MS Access is the only option.

So, my question is that is it possible to convert a SQL server database to Access (only the tables and constraints..no views or stored procedure). Is it possible to do it through some custom stored procedure. Any help would be greatly appreciated.

Sincerely,
pankaj


Without struggle, there is no progress
QuestionExecuteScalar with COUNT causes Exception? Pin
Pauwll8-Nov-03 1:21
Pauwll8-Nov-03 1:21 
AnswerRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin11-Nov-03 11:54
jeff_martin11-Nov-03 11:54 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll12-Nov-03 6:00
Pauwll12-Nov-03 6:00 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin12-Nov-03 7:25
jeff_martin12-Nov-03 7:25 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll12-Nov-03 16:27
Pauwll12-Nov-03 16:27 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin13-Nov-03 3:41
jeff_martin13-Nov-03 3:41 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll13-Nov-03 5:07
Pauwll13-Nov-03 5:07 
GeneralPutting fixed array into DB field Pin
EddieSD647-Nov-03 11:31
sussEddieSD647-Nov-03 11:31 
GeneralStored Procs, parameters and IN Clause Pin
stephen woolhead7-Nov-03 5:00
stephen woolhead7-Nov-03 5:00 
GeneralRe: Stored Procs, parameters and IN Clause Pin
jeff_martin11-Nov-03 12:04
jeff_martin11-Nov-03 12:04 
GeneralSQL Server does not exist or access denied Pin
yyf7-Nov-03 2:50
yyf7-Nov-03 2:50 
GeneralProblem with _Connection::Open ! Pin
nigs_krec7-Nov-03 1:53
nigs_krec7-Nov-03 1:53 
GeneralManaged .NET Embedded Database Pin
Andrew Shapira6-Nov-03 10:11
Andrew Shapira6-Nov-03 10:11 
GeneralRe: Managed .NET Embedded Database Pin
Mike Dimmick7-Nov-03 2:54
Mike Dimmick7-Nov-03 2:54 
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira7-Nov-03 10:17
Andrew Shapira7-Nov-03 10:17 
GeneralRe: Managed .NET Embedded Database Pin
Arjan Einbu10-Nov-03 11:01
Arjan Einbu10-Nov-03 11:01 
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira10-Nov-03 13:57
Andrew Shapira10-Nov-03 13:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.