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?
what I want to be able to do it take data from one of my Access 2000 queries and automatically export that to an XML file. then that XML file is going to be loaded with Google Maps API for use. What options do I have in exporting the data in access automatically? would it be just implemented everytime i call the function, lets say an ASP page?
to give a little more (hopefully helpful) information, I want users to go to my site which has the Google Maps API implemented, and it will show them the rainfall and lake level data in my area. I figured XML would be best as I have seen someone implement a similar design in Canada using an XML file, however, I need to be able to get the information from the query in Access so it can be loaded onto the map for people to see recent data. Again, I'm guessing ASP would be the best bet in accessing the data from the database.
I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads but very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially since it's said that an Access DB can have about 9 users or so accessing it at the same time. But is that a general rule or is it about many people writing to the DB? In other words, if an Access DB has hardly any writes and 99.9% reads can it be used as efficiently as it would be used on SQL Server 2000?
Does anyone know of a simple (and I stress simple as I'm a beginner with this asp stuff!!) script to allow for basic functionality of Add/Edit/Update/Delete ASP page which works with an Access 200 mdb. Something I may easily adapt for what I have?? I'm running Windows 2000 Professional with IIS 5.0.
I have created an Access database with an Autonumber field and set as promary Key. When I insert a record from my ASP web page it insists on making me add a value to this field. Is there anyway to set this as an IDENTITY field.
I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while .
I have a database which inputs usernames, passwords, and email addresses into the database. I'm trying to create an asp page that lists the data for a specific user when they are logged in so that they can change details (password, email address etc) any ideas how i can retrieve the data and append the new data to the database???
Our graphic designer is developing our new company website. We have switched providers and currently she is working on the new website which currently ressides on the new providers server as they support the ASP development environment. Their server is a Win2K3 server.
She is writing an ASP module to connect to an MS Access 2000 database and is having problems connecting. In this database there is only one table.
She has tried many different connection strings all to no avail and then found from investigating that the best and fastest method is to use the OLE connection string. However, each time she runs the ASP code she gets the following error... Code:
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
does anyone know of a free utility that allows you to alter/create tables through the web for access 2000. I'm talking about the table/db structure, not creating records.
Could someone highlight any known problems in converting an access 2000 to access 2002 database....should I expect a painful transition or can I expect a quick turnaround time to get my existing 2000 apps into 2002 format?
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
I have been doing adodb connections and using Access2000 for several lightweight websites. I have never had any problem with any of the SQL commands to insert, update, delete, etc.
I can insert a record into a memo field just fine ... up to a certain number of characters (nowhere near the 65K limit). After several hundred characters, the insert fails ... nothing happens ... the execute just idles and no insert is done. Anyone help? I have read about data types, etc., but everything I read sounds as if ASP and Access 2000 are suppose to handle the type conversions. They have been doing it up to this certain size.
I have 2 web servers both running win server 2003 with iis 6.0. On my PROD server I have a virtual directory called CONV. It points to a folder on the C drive of this PROD server.
On my TEST server, I defined a virtual directory called CONV. It points to a share called prodservernameCONV. Note that the share name is the same name as that of the virtual directory.
Using IIS on the TEST server, I can navigate to this CONV virtual directory and via right mouse, click EXPLORE. I see all the content I should but when I try to doubleclick on a file I get a message saying "Security alert" - "your current security settings do not allow you to perform system commands on this item".
I've tried everything I can think of on the security settings for the physical folder on the PROD server. I extended EVERYONE from READ, etc. to FULL CONTROL. I added the user called INTERACTIVE and gave it full control. In short, I am stumped and guessing now.
Basically, I just want to avoid duplicating all the data files on my PROD server over to my TEST server.
I have two machines, one generate files, and copy to the other. I try wscript.shell in my program, but it dit not work.
The two machines are not in the same domain. I saw some people's question but not suitable for me,their machine are in the same domain. They can assign permission to do the job.
Is it possible to read a file from a local computer? I know how to read a file that is in the server, however I would like for the user to read a values contained in a file that is loacted in his/her computer and then load these values into a database.
A way around this would be for the user to upload his/her file into the server, but reading the file directly from the local computer would be much faster.
is there a way i can read into two tables in the same database access file?and if so.. how would i write the code?the code below is already connected to a database reading from table1.. and i wish to read it from table2 as well...
rsMap.Source = "SELECT * FROM table1 WHERE (State = '" + Replace(rsMap__MMColParam, "'", "''") + "') OR (City LIKE '%" + Replace(rsMap__MMColParam2, "'", "''") + "%') ORDER BY City ASC"
I want to do one of two things and I not sure which until I know the difficulty level (knowing a little asp but not alot) of each. I am helping in the office and we will have several small access dbs using the FrontPage forms methodology.
So, now that I have some data bases, I will want my users to be able to 1)copy the database to their own machine where they can massage and do whatever they need to with the data, or 2) perform a query against my data bases, and have that result sent in db form to their machines to do whatever.
I've seen somewhere that asp has some file system components but am not sure how that works. I am willing to read and figure it out if I can get a push in the right direction.
i've bunch of files in a directory which need to be displayed in a html page. is there a way to display those files by order (dateCreated (descending))?
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
I worked on a database on PWS (Personnal Web Server). But transferring the database and all the files (html is used for inputting "search" words, asp used for results from database table). Here is my code:
1. I want to import a dbf file to access through ASP Programm. When i import a dbf file with filename greater than 8 chr, it gives an Server error saying File Not Found,Maker sure if the path is correct or filename is spelt correct. what should be done do import a dbf file with a longer name.
2. In the dbf file i want 3 fields to export to MS Access table. for eg : - Name, Address,City.
How can i make sure if all the field Names (Columns) ie: Name, Address and city is present in the dbf file programatically. for eg : if There is Only 2 fields in the dbf file while importing to Access rather than giving an server error message, it should display my customised Error .
i am trying to write something to an existing file. but i got error msg: Error Type: (0x800A0046)
I have done research on this error, i have change the write permission, setted up IUSR_(my computer name) account in authentication method, unchange the read from the parent folder.
i have done every thing, i dont know what can i do to allow me write something to a text file using asp. I can read the file no problem. here is my code:
I usually use SQL Server, but have occasionally had to use Access. This is such an occasion. My research, mainly at aspfaq.com, has been that you need to put the file path in your connection string, like this (watch out for the wrap):
on my asp page i have a list of results pretty much printed out the same way the access database is structured, so its nice n simple. although i want to let users download the results into an excel file or text file.
Was asked to take a look at a script and to adjust the file uploading limit to more than 1MB. Currently, only files (.pdf) not more than 50kb can be uploaded to the database. Other than that, the script works fine.
I am methodically working my way through the Sitepoint 'Build your own ASP.NET website' and have been successful in every lesson up to page 279. However I've come stuck when trying to add information to an Access Database. When I try to do so I get the message:
Operation must use an updateable query. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
I have tried the solution described in the book but still get the message. I am using IIS and XP Professional. The database works for queries so how do I get it to accept information entries?
I have one COM (.dll) for uploading files to server. Its working fine on server A but same code and file not working on server B giving error Path/File access error .