INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Error when running access file in a network

Error when running access file in a network

(OP)
Hello, i have built an access database and form, stuffs...

everything done and run fine , absolutely without any error on my laptop.

But when i copy it to a network.
And run the file from a computer belong to that network.
I got error on sql execute.
The problem is that that pc has microsoft access2007 with other language (my is english, that pc is dutch), so i dont know what is that error.

But the visual basic editor point to this code:
CurrentDb.Execute (strSQl)

and this is the strSQL
strSQl = " UPDATE tblBetaal SET restand = " & restand & ", voorSchot = " & voorSchot & ", huisHuur = " & huur & ", verzekering = " & argreement & ", betaald = " & bank & " WHERE week = " & i & " and empNr = " & empNr & ";"

the thing here i think that pc need to get some privilege
to update a table because the file is on a network???

if no then can someone help me , i will try to translate the error into English later...

RE: Error when running access file in a network

What is the error message? Even post it in Dutch.
Do you have an error handler routine? This will give you more specific error messages.
Try edit the database in Access, if you get an error then it can be network permissions.

RE: Error when running access file in a network


For the values used in your sql statement, use single quotes around strings, and for number values with decimal or thousand separators, use the STR() function on the numeric values so that a foreign numeric value on a system set with those country settings (concerning the separators) are converted to US Format, (also any date values must be converted to yyyy-mm-dd, mm/dd/yy or yyyymmdd using the FORMAT() function)

RE: Error when running access file in a network

In addition to SBertholds excellent advice - should any of the fields be boolean - for some countries/localized version you might be getting a localized version of true or false, so you might also consider using Clng(TheBoolean) to coerce it to -1 or 0 winky smile

For further questions related to Access, check out the Access fora - there are at least seven fora dedicated to Access on this site.

Roy-Vidar

RE: Error when running access file in a network


Boolean: Yes, this is very good to use on foreign set systems.

heroddaji, you might want to also consider using a Command object with parameters to get around some of the problems.

RE: Error when running access file in a network

(OP)
Thx all for your help
I solved it

The reason is that the dutch system use the comma"," for decimal number, not dot "."  

So if i have a number 2 and a haft(2.5) it will be (2,5)

that why i got the error.

thx all for help

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close