hey there, is it possible to use Access 2007 to access the data in the database via forms etc while all the data is stored in a SQL 2005 Express Database?
if this is possible could someone please help me set this up? im going crazy :S
slider
Last Activity: Jan 17 '08, 07:52 AM
Joined: Feb 7 '07
Location:
-
Access 2007 SQL 2005 Express
-
multi access database
hey all, first question i have is, can i create a database using Microsoft Access 2003 and run it on a local network for multi access and simultaneous access? or do i need to use a program such as SQL.
If i do need to use SQL could someone point me in the right direction of a cheap/free version of SQL that i could use but still interface with Microsoft Access 2003.
Also, the local network would be comprising of 8 workstations... -
set a time out on a value
Hey all is it possible to tell a value in a db to expire after a certain amount of time?
for example when a user logs in it sets a value to 1 and after 10 mintues it needs to be set to 0
any ideas?
im using sql 2000 server and vb asp thanks -
ok i have solved the problem..someth ing so simple!
This line here works perfectly in asp but in asp.net the userid=username needed to be
just adding the space fixed it :DCode:<%Dim strConn As String = "Data Source=myservert;Initial Catalog=mydb;User Id=username"%>
-
hey there thanks but nah that didnt work.
i believe that the query isnt getting executed for some reasonLeave a comment:
-
inserting into db not working
hey all..i am using sql server 2000 and writing my code in asp.net in visual basic language.
the code i am using to connect to the database is
[CODE]Dim strConn As String = "Data Source=myserver t;Initial Catalog=mydb;Us erId=username"
Dim cmd As New SqlCommand("INS ERT into Pictures (USER_ID) values ('" & userID & "')", New SqlConnection(s trConn))
cmd.Connection. Open()
... -
Hey thanks for your help but nah that dosnt work either. im still fair sure its the for next loop which is causing the error..because when i take the code which converts it back to a string and place it outside the loop.it works but it defeats the purpose :(...Leave a comment:
-
ok i have made some progress but still no prize.
if i use this code
...Code:dim counter, newcode, oldcounter, newnewcode, x, l oldcounter = 1 for i = 1 to len(code) counter = counter + 1 curchar=mid(code,i,5) select case curchar CASE "33104" newcode = mid(code, oldcounter, counter-oldcounter) response.write newcode newcode
Leave a comment:
-
ne one at all? i stil havnt been able to resolve this issue.Leave a comment:
-
hey! i am only using numbers in the string and i believe that the problem may lie in this line of code here
because i tried converting a string to a long out side of my for next loop and it worked. it seems like that when i use the mid code to shorten the string to avoid overflow it just dosnt like itCode:newcode = mid(code, oldcounter, counter-oldcounter)
it is very strange...Leave a comment:
-
yea i am outside the range so i tried using clng and once again im out of the range so i made the numbers within the range and i still get the same error message.. type mismatch.
to clearly explain what i am doing i am converting a letter into a numeric value and running it through a calculation, placing the value into a cookie or database and then reversing the calculations to end up with the original letter.
so if...Leave a comment:
-
ok i worked that problem out but now im getting an error message saying
Type mismatch: 'cint'
/site/enc.asp, line 227
just so i dont have to paste all my code.. at the beginning of the code a number is turned into a string so it can be placed next to another number by using the + function.
and here is my code to convert it back to a number so it can be calculated
x = cint(newcode)...Leave a comment:
-
determine number of characters up to a certain point
hey all, i have a set of numbers which looks like this
within this block of numbers are the numbers 33104 repeated where necessary. This is practically like a space or a comma to space out the numbers.Code:21551878283310414135344613310414135344613310468612568833104686125688331043180057716331044879441661331045148067733104487944166133104
I need a vb asp code which will determine the number of characters for... -
ok i worked it all out
if anyone else is having the same sort of problem this code will let you replace on value for another
hope this helpsCode:Dim string_var,string_find,string_replace string_var= "slider's" string_find= "'" string_replace="^" response.write Replace(string_var,string_find,string_replace) slider^s
Leave a comment:
-
ow thats a great idea thanks a lot!. so i would have to create a function which looks for the ' signs and then replaces them before it writes to the database and then when retrieving the values it replaces the " with '.
hmm seems simple enough. can any one point me in the right direction of how to do this?...Leave a comment:
-
' marks and sql trouble
Hello all!
i have a page where a user can type freely whatever he or she desires and it gets written to an access database via the Microsoft.Jet.O LEDB.4.0 connection using the following sql statement
...Code:sSQLB = "Update Profile SET txt1 = '" & txt1 & "', txt2 =' " & txt2 & "', txt3 = '" & txt3 & "', txt4 = '" & txt4 & "', txt5 = '" &
-
Hey! Thanks a lot it all works now!
However my only problem now is the USER_ID. I can insert other cookie values into the database such as nicknames but not the USER_ID which is a numeric value such as 123.
When i run the page i get this error
System.NullRefe renceException: Object reference not set to an instance of an object.
EG
...Code:dim userID userID = request.cookies("USER_ID").valueLeave a comment:
-
umm that is the full SQL query....not unless you want the rest of the HTML page
i get just a error message saying i have caused a syntax error. It comes up becuase i have no clue what so ever.
The script works when i do not change it. It will get a first name and a last name out of two text fields and write them to the database. I need this script to write a USER_ID which is extracted from a cookie and...Leave a comment:
-
Inserting into Access Database
Hey all! need some help editing this script. The problem i keep running into is that i do not know how to change the insert into statement to insert the USER_ID and two other variables called path1 and path2. I keep getting syntax errors when i try to change it my self. Also the USER_ID which is coming from a cookie is not working well either. It tells me that its not declared when i put it into the insert into statement. Im using Windows XP with... -
Hey thanks for your help! Ive got it all working now..all i did was write the first SQL statement, use a record set to get the data out of the table and then run another sql statement to insert it into the other table!Leave a comment:
No activity results to display
Leave a comment: