ASP :: ASP, XML, MS Access.

ASP Attempting To Access MS Access 2000 On File Share
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.

The error is similar to:

The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.

I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.

Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?

Access A MS Access Database Using ASP But On A Linux Box
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.

<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>

MS Access - Table Access Problem
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".

If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.

How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.

Access Remote Access Database From ASP
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".

The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.

How Many People Can Access The Same Access Database
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...

If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?

Query Works In Access But Not In Asp->access
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join

SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC

Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?

Write Access To MS-Access
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.

Access And ASP
I am trying to develop a simple form where the information supplied is sent as mail and inserted in a DB. Right now running IIS 5.1 on a XP pro machine. The database is a simple Access table. I am able to read the data of the table but not able to write in it. Code:

ASP And MS Access
is it possible to ascertain which fields are the primary keys from an Access table just using asp? If so how?

Access Into ASP Or PHP?
I have a MS Access file that consits of 500 movie titles, I already upload this file onto Brinkster.com, but I don't know to code this into ASP or PHP so I can have an on-line database. Please help me code this Access file into an ASP or PHP file.

Access ASP
I have a front end with all the code and a backend with some tables. Want to convert this into website database. Most probably convert the frontend into ASP. Is this the only way? Can one use the VBA code inside ASP with translating the VBA into ASP?

Access Look Up
I have a field in my Access db which is used to put a category against a company, rather like Yellow Pages. The categories are held in another table in the same db. The Category field in my companies table is a look up field using this syntax

SELECT [categories].[ID], [categories].[Category] FROM categories;

My problem is when I want to list a company and do a response.write rs("Category") I get the ID relating to that category rather the description. How can I get the description instead?

Access Help
I am using Access and ASP.I am just trying stuff out.I created an access database and put some validation in access on some fields.
I created an ASP program to insert into my database.
When I try to insert a record that validates OK with access rules all is fine.
Then I type input that violates the access rules; I hoped to get a helpful message back.
All I got was my message saying an error had occured and it was Error number 0 and native error 2097228.
As I was testing I know it is due to failing a validation in access.
I am learning I wanted to look up this native error, I cannot find it in access help or internet searches where would I look for native errors please?
I know I need to validate client side that is not the issue it is understanding native errors!

Access DB
I'm trying to search the Access database using 3 fields and I think there's a problem in my If statement...pls check it out for me.....I'm using ASP...this is what I'm trying to do:

If Request.Form("txtUser_Id") = "User_Id" and Request.Form("txtWeekNo") = "WeekNo" Then
strSQL = "SELECT (MSD + Methods + Analysis + Architectures + Models + Studio + Elective1 + Elective2 + Elective3) AS PersonTotals, FirstName, LastName, WeekNo, Semester, StudioTeamName FROM tblpersons"
strSQL = strSQL & " WHERE Semester=" & Request.Form("DaInBox")
'strSQL = strSQL & "WHERE Semester ='" & strSemester & "'"
End If

ASP / Access
I have a memo field that I'm using in Access via my development in Dreamweaver MX 2004.
In this field, rather than having it as a text field, I'm using it as a memo field to collect information
for our company. My question - is there a way for the text to do a hard return when I hit a hard return rather than
continuing to wrap.

Example, I would like the field to display as:
4+4=8
5+5=10

Rather than: 4+4=8 5+5=10, etc.

Access DB To SQL DB
I'm planning to change my database from MS Access to an SQL database. So, what do i have to change in my code for that?Is it possible to have multiple tables in SQL which are linked to each other?Are there pro's and contra's ?

YES/NO In Access DB
I made a little app that selects data from a database depending whether there is a NO, in the YES/NO column. The data is exported to a txt file with aso. What i'm wondering is, is after the data has been downloaded to that txt file, how to write to the database saying all they were marked NO, go to YES.

Access Db
I have trying to help a friend out with his web site... I am more of a php person but he need my help so here I am... The he is having is that he is using ADODB.Connection to access an Access DB(mdb) on his website.

He switch from one webhosting company to another and not his website can not connect to his access db. I have provided the code for your review.. Where is the problem.. How can I get the code to find the (MDB) database?

Also I am connecting and testing is new web site via ip... His domain name is still pointing back to the old DNS address.. Code:

Access ASP
I have a middle-tier written using Foxpro. I'd like this tier to coommunicate
(that is pass some variables to ASP). I defined a Session variable somewhere
in my ASP file, e.g. Session("Usercode") = Somevalue. Now somewhere else, I
want to change this value. I tried this:
UserSession = CREATEOBJECT('ASPTypeLibrary.Session')
UserSession.Contents("Usercode") = TheUsercode
However, it gives the error: ASPTypeLibrary.Session is not found. However,
VB's object browser lists this

ASP & Access
I'm still very much on the learning curve when it comes to writing ASPs and have always used Access for my db. A colleague in work has told me that I should never use access on a commercial site where I'm likely to get a lot of traffic. Is this correct, is Access totally unsuitable?

ASP, Access XP
Alright, I am opening an Access XP database via ASP. One of the fields is a numerical field, and I would like to force it to display the number + 1 digit to the right of the decimal. For some reason it is only displaying digits to the left.
In Design View, my Access Table (names 'arlist') looks like this:
Field Name: level, Data Type: Number, Field Size: Integer, Format: Fixed, Deciaml Places: 1

My SQL Statement: SELECT * FROM arlist;

Then the VBScript I'm using to access the table looks like this:
Response.Write"<TD align=""right"" bgcolor=""" & strBG & """ width=""10%""><P class=""body"">" & rsDC.Fields("level") & "</TD>" & vbCRLF

I am opening the table via ADO Statically with a Read-Only pointer because the page just displays the contents of the table. I've tried everything I can think of to preserve the decimal place. If I view the table in Access, the decimal places are correct.

Asp & Ms Access
I'm trying to connect an access database to a asp page, but whatever i do, it just doesn't work. Code:

UTF-8, Access And ASP
How to I get MS Access to return unicode string in ASP? It returns?

Access DB
I'm Running IIS and have the Db "file.mdb" in the root directory. I'm running on windows 2000 Pro and i'm having trouble connecting to the db. the code i'm using is:

<%
dim conn, rs, sql
set conn=server.createobject("ADODB.Connection")
conn.connectionstring = "DRIVER=[Microsoft Access Driver(*.mdb)]; DBQ=" & Server.CreateObject("file.mdb")
conn.open

but it doesnt work.

ASP / Access
I have got a display page where im displaying Company ID Company Names with Their Products Added
The data im extracting from the access DB
The thing is as im adding a lot of products for a each company so im adding them in a loop in my Products table
so each time i add a new product with the particular company id the the id gets repated as its in the loop as well and thus each time a new record is being genarated
what i want to achieve is that on a display page where i want to see the data that has been added i just want to get the Company ID not repated and with all the products related to that company id and then the next Id with the products
like ive got 20 products for a company ID 1 so i just want to show that company ID once and with all the 20 products and then go on for the next company ID
how will u do this
do i have to use the distinct thing or do i have to open another recordset and match the id

Asp With Access
how can i provide the password for the database access using asp
note that i'm using the recordset object

set dbrs=server.createObject("ADODB.Recordset")
dbrs.open "select *from table_name ","DSN",0,3

and i don't like 2 use the connection object

Access DB
At work, My database (Access) is used by many people for update or order. I didn't think about it and I'm using this database on my web site.
Now when someone at work is using the database, I get an error since the DB is aldready used.Is there a way to bypass this? I can't really copy the DB since I won't get the update.I hope there is a way to resolve this, since I have to work with the databse.

ASP And MS Access
I can't figure out what the problem is with this code. When just loop the data coming from the table, I see the ID I want updated, so I know it's pulling the data from the table. I can also see that the data from the form is coming across. Can someone look at this and tell me what I'm doing wrong or post a sample for me to look at? Code:

ASP And MS Access
I have an ASP based form on a webpage. When someone fills in the data and click submit, the data gets sent to me via email.

How easy is it to get that data pushed into an MS Access database?

Also, how long would it take a competent programmer to set that up? Assume that the Access database is just one table and it is already created.

Access And Asp
I have an ASP script that opens an Access DB and tries to record an IP address if the user has never visited the site. However, when the script is run, I get an error saying the the DB is read-only. I checked to DB propoerties and it is notlisted as read-only, and when I run my Query on it, it does not open the recordset as a read-only connection. I can only assume that something else has the DB r the table open, but Ihave no idea where.

Use Of .ASP And MS Access
I am trying to create a SIMPLE webpage which will just register the user for a service.

I have a create the database in MS Access with fields fname, lname and email but I don't know what the HTML code will look like in order to connect 1) the HTML page to the Database and 2) the tag fields to the appropriate fields of the database.

I have spent a lot of days searching around the Internet to find this extra simple thing, but unfortunately everything that I found was either too difficult or inappropriate (in means of what the author wanted).

I just want to create a webpage which will add records to the table 'user' of the 'registration' database.

Asp / MS Access
I have an MS Access DB that has some subroutines in it. I want to be able to call those subroutines via an ASP page. Can anyone help me with the syntax or provide an example?

Using Asp Or Access
Seems like something so easy to do

Need to make 123456 be 1234.56 while either displaying the page in asp or by changing the data type in access 2000.in the database, the number is a 'number' 123456 tried formatcurrency and formatnumber in asp'missing something though
everytime I try to do something, I get 123456.00

MS Access
Is there any way of creating a database without having to use MS Access software or is there anyway to download MS access freeware?

MS Access SQL
I have the following code which returns an error when run as part of my ASP SQL

strquery = strquery & "FROM (Customers INNER JOIN Orders ON
Customers.CustomerID = Orders.CustomerID) INNER JOIN (Products INNER
JOIN (OrderLines INNER JOIN StockMovements ON OrderLines.JobNumber =
StockMovements.JobNumber) ON (Products.ProductID =
OrderLines.ProductID) AND (Products.ProductID = OrderLines.ProductID))
ON Orders.OrderID = OrderLines.OrderID"

I have copied this direct from MS Access Query SQL. How would I adapt this code to work in ASP?

MS Access Bug
The code I am currently modifying uses SQL to count items that have not been changed (blank). When I open the database and delete "Selected" from the field being counted it diappears to Access.For example, I have 4 items being counted by the field Review_Completed.The SQL statement used is:Code:

SELECT count(*) as rec_count FROM January where Problem_Owner = 'andmart' AND Review_Completed<>'Yes' AND Review_Completed<>'Skipped' AND Review_Completed<>'Selected'

The blank fields should be counted if they are blank. The page modified them all to "Selected" and I erased those changes using Access. After this, the page ceased counting the blank fields and I cannot get it to count them. Is this a bug with Access?

Access FE
I have a small Access FE connected to a SQL server.I am thinking of converting the Access FE to ASP.I would appreciate some suggestions on the best way to accomplish this? I have seen some programs that offer to do the conversion but I don't know how thorough they are.

Some of my forms contain Event Procedures and I also have a couple of modules (I'm not very experienced with databases but have gotten a lot of help from the forums).

Ms Access
i had a slight problem though, but it seems that most of it comes on my database. since theres not enought budget on having a good database like sql server, i just stayed on the access. my problem is, i can run my applications on multi-user enviroment using sql server but not on the access. running my applications simultaneously on a multi-user enviroment using msaccess causes my applications to crash down. is there any way i could turn on the access into a superman?is there any site in the web that i could see regarding this problem?

To Access Mdb
help me create a file which I can call from a Flash button which will insert yes or no into a table in my database. My table is called users and the column is called completed.

MS ACCESS SQL
does anybody know a better way to write this:

---------------------------------------------------------------
rs.Open "notes WHERE status = 'active' AND cid=&getuid AND uid ="& getuid , Connect, 2, 3
---------------------------------------------------------------

IIS/ASP/Access
I'm trying to set up a IIS webserver on win2k. My ASP application is in a virtual directory, which is located at d:services. This folder is shared on the network, with only myself and one other employee having access. The application worked fine for us, but when someone who didn't have access to the share tried to use it, it gave strange errors when doing a database operation.

should SERVERNAME/IUSR_SERVERNAME be the account used for anonymous access? Do I then need to give IUSR_SERVERNAME permission to the share?

MS-ACCESS DB
I would like to use some SQL facilities on my site which doesn't have any SQL Server functionalities. Can I create a Database with Microsoft-ACCESS and simply copy that DB
onto my site so I could then create the ASP code to access it through a normal Server.CreateObject("ADODB.Connection") ?

MS SQL To MS Access
I need to get this ASP program to work with ms access instead of ms SQL... I have converted the DB now I just wanted to know should I just change the DB connection settings or there is more to be seen and taken care of. will I have to change the intire sql commands or its just the database connection setting.

Access DB To SQL
I have an access database on a 2003/asp IIS server. I use a simple asp script which calls a variable throughout the site to input and display a simple phonebook in asp. I have already DTS's the access database to the SQL 2005 server. Would it be fairly easy to convert from access to SQL? Here is the connection string -

<%
DBpath=Server.MapPath("/AddressBook/addr.mdb")
%>

What about the queries? Will they be compatible?

Can't Access Web
I'm sorry I'm not sure if it's the right place to post this, but this is about my asp application that i wrote on my desktop. Since all my work is done here, I hope I can access it from my laptop when I'm not at my office.

I checked that my desktop's ip is something like 192.168.0.4 so I try to type this into the browser on my laptop. http://192.168.0.4/myapp

but that fails, it just says page cannot be displayed. I checked with my IIS setting and I have allowed anonymous access. My desktop and laptop are on the same network at home (I can actually exchange files between the 2 machines with the windows explorer). What is it that I'm missing?

Access DB
I have an Access Database; e.g., DB.mdb, which has 10 Tables; e.g., Table1, Table2, ..., Table10; in a directory; e.g., Directory1.

Using ASP copy method:
FileObject.Copy(destination[,overwrite]) I have made a copy of this entire database in another directory; e.g., Directory2.

The Tables from Directory2 has been and will be changed via writung new data into the 10 Tables in Directory2. I need to copy only one of the Tables, e.g., Table5 from the original database in Directory1, to the database in Directory2. Replace Table5 from the DB in directory2 witj Table5 from Directory1 without affecting other 9 Tables. How can I do that?

Csv To Access
Can someone point me in the direction of a good guide to converting a csv file to a access mdb file using ASP.

Basically Client will be updating a csv file quite often, I have tried just connecting to the CSV file but as the file tends to be over 10 000 lines, it is taking forever to run sql statements against it, and figured it would run faster if it is turned into a mdb file.

MS Access
How many people can update my table in Access if i have a script which i have written in ASP which lets user access the orders from a table and update it.

is it multi user?I hope there wont be conflicts while updating or inserting the record in ASP if more then 10 people are going to use it at the same time?

Asp/access Db
Some how I lover looked this in testing of my web app for my company before launching, now I have a big problem. I am using an ASP to read and make changes to an access database. use a DSNless connection. Another program accesses the same database through DSN that is checked Read-only and not Exclusive.

When the other program access the DSN I can no longer access the database from the ASP, it says "file already in use". I can open it using Access and make changes without a problem.