Search:

Ok, I'm giving up.

I am encrypting every data on my website before saving it to a MS Access database. The encryption used is RC4 and I found the script on the net.

Everything works fine, the...

Hi there,

I am copying a database(MS Access) with ASP, how would I set the password for the new database through code ?

Thanks in advance.

Exactly Al42, Bruce, I am thinking sort of like a cursor, I would have something like "text text text{1}text text text{2}text text{3}text text text text" in my string, that's why I was think if it...

Sorry, not sure I get what you are saying ?

A 100 was just for an example...

No, not yet...

If the Replace function could return the location of the string replace, I could do my next replace from there. Unless I do a InStr just before my replace and then I tell the...

Imagine I have a variable that has a lot of text in it, let's call it strLargeString, and in it, there's string like {1}, {2}, {3}, etc.. what would be faster?

For x = 1 to 100
strLargeString...

FINALLY !

I figured it out, I used some of the code I had to backup our sql database.

Anyway, the trick is to create the link from code:

DoCmd.TransferDatabase acLink, "ODBC Database",...

Yeah, I just tried, it says that there's no linked tables :(

Nah, it asked me for the password and when I put it in, it just refreshed the table.

I need to be able to query the database thru asp.

I found this piece of code:


Option Compare Database
...

Small update !

I created my own dsn, now when I select it in the dsn list, I do not get prompt for my password, but as soon as I close MS Access and reopen it, I get prompt for it again.

If I...

Geez, that's what I've been reading on the net, but I double triple checked and I cannot see that damm option :(

I have read somewhere that you could store the password in the tabledef of the...

Hey,

I have a linked(from MS SQL Server 2K5) table in MS Access 2K and I cannot query it because it is asking me for the password everytime.

I do not see an option to save the password in my...

You need to go by the IP and the port, you can just open up the file from the network, you have to open it through the IIS so it process the asp!

Something like http://192.168.0.9:8072/

Good...

Where in the statement, I never used the @@Rocount before.

But why is the AffectedRows not working, it's suppose too !!!

Thanks

Why would the recordset not return the number of rows affected, I have example in a book that show a select returning the number of rows selected !!


Public Function RunQuery(ByRef QueryString)...

You'll need the XMLHTTP opbject:


Dim objXMLHTTP

Set xml=Server.CreateObject("Msxml2.ServerXMLHTTP")

xml.Open "GET" , "http://www.somesite.com" , False
returnedContent = xml.responseText

Here's what I would do, that is if there's not too much info being submitted!

Use the get method to submit your data and in your frameset, when you specify the filename, do something like
...

Hmm, the program is an old dos Book Manager, I don't think that we can ask for a change.

I will have to tell my client to run a backup and run my program on the backup file.

Why the engin is...

Damm, good thinking, I linked it and opened it but then I close it and open the DBF and went back to Access and open the linked table and I get the same error I get it VB !!

Thanks for you help, I...

He just told you what to do !

You should be nice with the people that tries to help you, y'a know :mad:

Yes, I have MS Access...

Sorry Fishy, not too familiar with ADODC, is it in the components ?

Also, just a note, I tried with DAO and it gave me a different error, "Open exclusively by another user", I guess that is the...

Oops, I didn't put my path from the code you gave me :blush:

It's works if it's not open, but it still does not let me if the database is opened.

Thanks

That's what I have...

Hmm, now it tells me that my table does not exist...

How would I do a select ?

I tried:

FROM tablename
FROM tablename.dbf
FROM [tablename#DBF]

Specify it from VB ?

The thing is my client has a store inventory program that use those DBFs database all the time and I am making a program that is reading that database and updating his online...

Damm thing!

I want to open a .dbf db and do a SELECT, I am using ADO

It works when no one is using the .dbf, but it wont be the case, so I get this error:
Could not lock table 'tablename';...

Nice, it worked with the OLEDB, I just need the extended properties and it works.

Thanks Fishy,

I tried a different approach, I am connecting to the DBFs with OLEDB instead, we'll see if it works now.

I will let you guys know.

In which package can I find the vfpodbc.dll ?

My client has an outdated version and I tought that MDAC was including those drivers, am I missing something ?

Thanks once again.

Looking good, way better, did you noticed a performance increase ?

Use InStrB to check if your string is in another.

Example:

If InStrB(strLines(i), "MAXCLIENTS:") > 0 Then strMaxClients = Trim(Mid$(strLines(i), 12))

Be carefull, because if you want a...

Yeah, if you do not want to declare it as a Variant, which I agree, in most cases is bad practice, you should just have two parallel array...

Dim deckNumbers(12) As Integer
Dim deckFaces(12) As...

Yak, this is PHP :p

Today's date:

date("d-m-Y");

By default date is now, otherwise, the syntax is :

date ( string format [, int timestamp] )

There's problably a CSS style you can use, but if you want it cross-browser and don't care about having a true indent, just use space!!

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You text starts...

ok, since you're in Access then, use

WHERE Not IsNull(your_field)
and
WHERE IsNull(your_field)

Dim deck(1,12)

deck(0,0) = 1
deck(1,0) = "A"
deck(0,1) = 2
deck(1,1) = "2"
deck(0,2) = 3
deck(1,2) = "3"
etc...

Do you have permission to write files ?

If you do, then make sure that

Response.Write strUploadPath & "/" & strNewFileName equal a valid path.

But that will only returned clients with sites, you might want this:

SELECT client_name, COUNT(Site.CLIENTID) AS numOfSite FROM Client
LEFT JOIN Site ON Client.ID=Site.CLIENTID
GROUP BY...

Just a tought:

SELECT your_field FROM your_table WHERE your_field <> null ORDER BY your_field
UNION ALL
SELECT your_field FROM your_table WHERE your_field = null

Didn't try it, but it should...