Click here to Skip to main content
15,910,773 members
Home / Discussions / C#
   

C#

 
GeneralRe: Math question Pin
Stephane Rodriguez.22-Aug-02 8:11
Stephane Rodriguez.22-Aug-02 8:11 
GeneralRe: Math question Pin
leppie22-Aug-02 9:19
leppie22-Aug-02 9:19 
GeneralNew developments :) Pin
leppie23-Aug-02 6:07
leppie23-Aug-02 6:07 
GeneralRe: New developments :) Pin
Stephane Rodriguez.23-Aug-02 6:58
Stephane Rodriguez.23-Aug-02 6:58 
GeneralRe: New developments :) Pin
leppie23-Aug-02 7:14
leppie23-Aug-02 7:14 
GeneralRe: New developments :) Pin
Stephane Rodriguez.23-Aug-02 7:49
Stephane Rodriguez.23-Aug-02 7:49 
GeneralRe: New developments :) Pin
leppie23-Aug-02 8:10
leppie23-Aug-02 8:10 
GeneralTwo Access database questions Pin
Luis Alonso Ramos22-Aug-02 6:18
Luis Alonso Ramos22-Aug-02 6:18 
Hello,

I have my application working perfectly on MSDE, now I want to downgrade it to using an Access database locally.

I'm using OleDb* classes, so I just changed my connection string to point to the database and it worked. Well, just partially.

I'm having two little problems.

First, all my INSERT queries are throwing exceptions on invalid syntax. I copied one of those queries to Access and created a query and it worked. Just that it reformatted and added those brackets around one parameter name.

INSERT INTO Users ( LoginName, Name, [Password], Permissions )<br />
VALUES ('pepe', 'Jose', 'p', 1007);


I added those brackets to my program, and it worked (on that particular INSERT query). It also worked (that query) using MSDE. My question is, what are those brackets, and how do I know which parameters I should enclose in them? Do I have to fix all my INSERT queries?

The second problem is that when using the Access database, an immediate refill of the list with the records (users in this case) does not show the new just-added record. Using MSDE it comes up.

Any ideas?

-- LuisR


──────────────
  Luis Alonso Ramos
  Chihuahua, Mexico
  www.luisalonsoramos.com

"Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein
GeneralRe: Two Access database questions (update) Pin
Luis Alonso Ramos22-Aug-02 6:28
Luis Alonso Ramos22-Aug-02 6:28 
GeneralRe: Two Access database questions Pin
David Stone22-Aug-02 6:30
sitebuilderDavid Stone22-Aug-02 6:30 
GeneralRe: Two Access database questions Pin
Luis Alonso Ramos22-Aug-02 7:09
Luis Alonso Ramos22-Aug-02 7:09 
GeneralRe: Two Access database questions Pin
David Stone22-Aug-02 7:20
sitebuilderDavid Stone22-Aug-02 7:20 
GeneralRe: Two Access database questions Pin
Luis Alonso Ramos22-Aug-02 7:39
Luis Alonso Ramos22-Aug-02 7:39 
GeneralRe: Two Access database questions Pin
David Stone22-Aug-02 7:56
sitebuilderDavid Stone22-Aug-02 7:56 
GeneralRe: Two Access database questions Pin
Luis Alonso Ramos22-Aug-02 8:12
Luis Alonso Ramos22-Aug-02 8:12 
GeneralRe: Two Access database questions Pin
David Stone22-Aug-02 8:25
sitebuilderDavid Stone22-Aug-02 8:25 
GeneralRe: Two Access database questions Pin
Luis Alonso Ramos22-Aug-02 8:35
Luis Alonso Ramos22-Aug-02 8:35 
GeneralRe: Two Access database questions Pin
James T. Johnson22-Aug-02 9:40
James T. Johnson22-Aug-02 9:40 
GeneralRe: Two Access database questions Pin
Luis Alonso Ramos22-Aug-02 12:37
Luis Alonso Ramos22-Aug-02 12:37 
GeneralRe: Two Access database questions Pin
David Stone22-Aug-02 12:47
sitebuilderDavid Stone22-Aug-02 12:47 
GeneralRe: Two Access database questions Pin
Luis Alonso Ramos22-Aug-02 16:31
Luis Alonso Ramos22-Aug-02 16:31 
GeneralRe: Two Access database questions Pin
James T. Johnson22-Aug-02 12:50
James T. Johnson22-Aug-02 12:50 
GeneralRe: Two Access database questions Pin
David Stone22-Aug-02 12:59
sitebuilderDavid Stone22-Aug-02 12:59 
GeneralRe: Two Access database questions Pin
James T. Johnson22-Aug-02 13:12
James T. Johnson22-Aug-02 13:12 
GeneralRe: Two Access database questions Pin
leppie22-Aug-02 6:32
leppie22-Aug-02 6:32 

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.