problem: write conflict in ms access

solution...

make sure the table has a primary key

make sure no bit field has a null value

and ensure that the table has a timestamp field.

i'm currently using a thread in the ms access section to post my findings as i go along. I am sure that there are others who experience these problems every...

You have helped a lot actually. It was tru these discussions that i am talking to my self and realizing the best approach.

Anyways, i will continue to use this thread...

WendellB (9/3/2012)

---

There's a common misperception that Access is an insecure system that is also unreliable. As long as you use the .mdb format, you have Access User Security. ...

Thanks for the reply. I got a really good solution to this.

Appreciate your help.

The idea is to use ms access accdb file as front end rather than adp

Gives...

Okay,

after thinking long and hard as to how I will go about doing this, I decided that I will use ADP file to creat stuff, stored procedures especially and...

It is a brave ask...cause i searched all over and still cant come up with a solution.

I was thinking input parameters..but still havent got that to work fully yet.

I havent...

Hi Jeff,

Thanks for the reply.

I got the whole running total thing sorted out...I have a running sum setup in ms access but what this sql server update is doing for...

Okay, I need your expert advice which can only come from years of experience...

I have a list of stored procedures...

I only just realized that I can group a set of...

Okay, well I am sort of like Columbus with this whole server thing...

anyone else who has the same problem...here is your solution:

SQL Server 2005. Management Studio Express. Front End -...

I'll keep using this thread to post updates as I go along for anyone who is like me...have no idea what I am getting into and its all just trial...

im not quite sure that one person would want to wait until the first person finishes with the data before running his report.

I am not saying that i would prefer...

what the quirky query is doing is that it is update a column in the table called running total...suppose two users hit previewing the a running total report out of...

Ps.... I never took a computer class in my entire life so it means a lot to me that you helped.

N I only started SQL server three days ago...

Thanks.

Well I can think of a senairo where cursor would actually be better...

Suppose you have a large database and lots of users. Using the update method, I doubt that two...