Access :: By Mistake

Wireless Mistake

Mar 8, 2006

Okay I know i've been incredibily stupid and made a tremendous mistake but what i need is the best solution to the problem i have right now...
I have a database its msaccess with SQL Tables at the moment. There were an expected 40 wireless users expected but after horrendous crash on day one and only 10 users and after some digging i see that this is just not going to happen (why i assumed it would be ok is my own naivity and taking the word of the IT Manager)... the connection is totally unreliable and corrupts the database beyond repair.. infact i'd go so far as to say the wireless network murdered my database.. strong words but its my baby..

So what are my solutions here... the staff need this database... so what i have come up with are the following solutions and i thought i should ask for some advice before i plough ahead and make another fatal error..

use DAP? Or another internet based way of getting round it?

Get network points put in all the rooms?

Or can I make it totally SQLServer?

Help.. any advice would be greatly appreciated cause at the moment i have a fantastic application that just cant run and i feel such a complete failure.

View 1 Replies View Related

Mistake With Security

May 25, 2006

Guys, i need some hlp from u.
i created a db and i was testing the security options. I remove all the ticks from the check box and now i can not do anything. i cant even use the right click.

how can i recover my access? any suggestion?
thx max.

View 5 Replies View Related

Spot The SQL Mistake

Nov 24, 2004

Here's my code

Code:Dim mysql1 Dim childid As String Dim Info As String Dim inputch as string dim inputin as string inputch = "Please enter the ID number of the young person" inputin = "If you have any comments about the young person" childid = InputBox(inputch, "Add young person", "") Info = InputBox(inputin, "Comments", "") Text16.SetFocus mysql1 = "Insert into [Activity ID] (ActivityID,ID,Information) Select [Forms]![Activityinfo]![Text16].Text, childid , Info" DoCmd.RunSQL mysql1

When I run it, It does the two input boxes fine, but it then asks you for the value of childid.. ?

any help is appreciated

Paul Kent

View 2 Replies View Related

Made A Mistake, Now I Need Help

Feb 8, 2005

i named one of my fields in a table with spaces "quantity on hand"

Now i cant refrence is in vba.

If rsSa!D < rsInv.Fields!"quantity on hand" Then

this does not work. I cant go back and change the field name on the table.

thanks

View 2 Replies View Related

Basic Access Mistake

Nov 3, 2005

Due to me still trying to grasp the basics of access, I have what I call the "Command Centre" which is basically a form where our administrators verify all records placed and control them from here.

As different stages of each record requires Authorising/Further Authorising by other users, they will require to update the same records as displayed on the admin control from.

The problem I have is that when the administrators make a change to a record which prompts an authoriser to go into the db and authorise, if the admin users keeps their form open (which is what I want), I understand that it doesn't save changes to the record until they exit the form. Naturally this causes problems for the authoriser.

Is there a way of saving changes to records as they are made so other users can edit the records as see it up to date. I'm thinking along the lines some vb code to save on an action.

Many thanks
kempes

View 1 Replies View Related