I'm new to programming databases with MS Access. I'd like to know how I get user input for a database, in a form, read from it and do "if" statements. Does anyone know how to do this? I've tried ASP approaches (with the FSO function and .txt files) but none are as effiecient and organized as databases appear to be.
View RepliesI can edit information in tables no problem with insert delete etc etc. My question: is it possible to edit the tables themselves ie make new fields, tables etc! If so can someone provide a simple example or point me to a tutorial im sure I will pick it up pretty quick but I have no idea where to start!
View Replies View RelatedI have asp page needs to access remote database, I got error"The Microsoft Jet database engine cannot open the file 'Unknown'. It is already opened exclusively by another user, or you need permission to view its data. "
Could anyone show me the steps to configure permission (I tried creating IUSER_DBMACHINE local account on the database box, give this account full permission on the database folder, doesn't work.
I am connecting to remote access database through my asp script. The Access database is on a different domain and my webserver(where asp scripts reside) is on a different domain.When i ran the script i got this scary error message:Code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3a8 Thread 0x7c4 DBC 0x2770ff4 Jet'.
i think this is related to some permissions issue, but not sure how to correct it.
What I am trying to achieve here is a connection to an access database on another server on our network. Every method that I try I get SQLerrors or DNS errors nothing seems to work. Does anybody know a solid method I can try to gain the connection i require?
View Replies View Relatedi want to run a website on a server with an sql database ( that in itself is no problem, i've done this before) but with a possibility to update the sql database with data stored on a local harddrive in an acess database, can ianyone give me some hints or websites with
related info ?
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.
Has anyone had any luck editing the Microsoft Outlook Web Access pages? I am setting up my company's new OWA 2003 server. Now here's the problem, I had to create new logon pages because we authenticate to a different domain then the server is on (stupid mergers).
Now when the logout button is clicked on the page, it takes you back to the default logon page. Were a user to try and log back in from here it wouldn't work. Now simply adding a "response.redirect" to that page seems to break their code completely. So has anyone managed to do this and could let me know how?
I have a roster of people from a db showing up in a frame containing ans asp page. In order for the client to edit a record on the roster, I have an edit page opening up in a javascript pop-up.
I know how to edit the db but what I don't know is how to 'bind' the text boxes in the pop up to the correct record in the db (based on which record they selected to edit). Here is how it looks:
John Smith 12 123 Main Street Your Town State edit this
the 'edit this' is a link that opens the pop-up. How can I get the correct record to show up in the pop up?
actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,
I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.
If I have the line adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("produkten.mdb") to access an Access Database local to the site, is it possible to have something like adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=http://www.somesite.com/somedb.mdb" To allow the site to connect to a db on another site/server which also belong to me?
View Replies View RelatedHow do I connect to a remote Access DB from my desktop? I have a MS Access DB online adn wish to hook up to it from my desktop absed DB?
View Replies View RelatedI have a access database on my server which my users can download it from my website. I have update.asp file which will update the database on the client. So say if there are 2 users each will download a copy of the database on to their machines.
When they run the update.asp file, the information will go to their respectively database(the one's on their machine). The architecture of the DB's remains the same but each client will have his only data. Is this possible? IF yes then, why do I get this error...
Microsoft JET Database Engineerror '80004005'Could not find file C:Test.mdb.
Wish I'd found the thread yesterday before spending half the day fighting
the same battle and finding a workaround. But at least it explains why my
final approach worked.I set the remote folder as a virtual folder on the webserver, assigned web rights to a domain user and used fso.copyfile(server.mappath) to copy a
file created locally.I'm not thrilled that access to the remote location can't be controlled at the user level this way but at least access to the calling script can.
Strange though, the problem showed up during a migration. Server A had been
hosting this asp page and connecting to server B sucessfully. I was moving
the application to server C when I ran into the problem. All three machines
are W2K, same service pack, same domain, same users, same access
rights/method configuration. Go figure.
I was given the following by my host:
Database name: asdfafasf
IP/Host: 11.111.11.111
Server: asfafaf
Username: afafdadaf
Password: adfadf
Every program I use (excluding Enterprise Manager - I don't have it) to connect is unsuccessful. Access Projects for example, when I try to establish a connection, it doesn't ask for IP/Host.
I'm trying to access the ADSI data on a remote machine in my network usng ASP and the GetObject("IIS://...") call, but I keep getting an "Access Denied" message. It works perfectly on the localhost. Did anyone pass by this problem?
View Replies View RelatedI have admin privileges on a remote server and would like to use a web interface (asp) to manipulate various files. It seems that when I access the remote web pages I only have IWAP and IWAM privileges. Is there a way to automatically send my admin username and password via the asp pages so I will have admin privilages?
View Replies View RelatedI'm trying to use the Stream ADO object, and I need to access a file that is on a remote server.
I tried using the FileSystemObject object, but I need to save a CSV file that contains some funky characters.
The documentation I have access to does not tell me that I can or cannot enter in a remote location...(e.g. "http://10.10.10.10/foo/foobar.csv")
I receive this error:
ADODB.Stream error '800a0bba'
File could not be opened
Code:
I want to access files from a remote server so I mapped it in my
server under z: for myserverwebmysiteimages
I added this UNC path to my IIS virtual directory and name it as
"upload" but I still cannot use any FSO to read it. Here is my code:
Is it actually possible for a local access 2000 database to link to a remote database online via linked tables. I just wanted to know how feasible a LINKED TABLE scenario would be.
If this was possible it would solve so many administration problems and save development time when it comes to building asp-admin pages to manage the backend.
IM trying to put up a small database in my website and having my visitors to search it. A record of this database will have four fields: The first one will hold a number, the second one a Street name, the third a City, and the fourth a picture. The database will be searched either by the number or by the city.
View Replies View RelatedI try to get data from a database which is on an other server. I can view the files on this server via the directory "t:" from the machine the ASP pages are on.
Constring:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=t:database.mdb"
Error:
't:Database.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
In my latest school project, i would need to use ASP to connect to a remote database that is NOT located on the ASP server. I was wondering if this is possible?
View Replies View RelatedIs there a way of making a connection to a database on a remote server? The intention is not to hack, but I have a customer who would like to perform a search in several identical databases on different web servers (with the owners permission) and show the result on the customers own web page.
Could this be done? Of course there must be some level of security, the db owners will if necessary give permissions to our customer.
I have my access database on a xp workstation setup as a web server using IIS. I am trying to access the mdb from another web server, but when I run my code below I keep getting :
Microsoft ADO/RDS error '800a20ff'
Internet Server Error. Code:
I eventually managed to create a connection between my IIS LocalHost ASP WebPages and my database located on a website on the net. Here is the solution:
Dim conn, connect
set conn=server.CreateObject ("adodb.connection")
connect = "Provider=MS Remote; Remote Server=http://www.example.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("database_filedatabase.mdb") & ";"
conn.Open connect
When I point my connection to my database on the net like in the code above I get the following error:
Error Type:
Microsoft ADO/RDS (0x800A2011)
Internet Server Error: Object/module not found.
Any Suggestions?
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>
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?
I have a script on my asp page which takes values entered from a form and inputs it into a database, in their appropriate fields. It's been working fine, but lately I'm noticing that I've been getting some blank records being entered in my DB table.
I know it's not my form becuase there is no way to leave it entirely blank, so even if you don't enter anything... their are hidden fields which already contains a value that get's passed and goes into the DB.
I am wondering if this is a result of many people entering data into the access db at the same time, and i'm wondering if i have the right locktype parameter.
I am using adLockPessimistic right now... should that be adLockOptimistic or adLockBatchOptimistic????
and should the cursor type be adOpenDynamic???
I'm in the process of 'trying' to write a very small CMS which will allow me update an existing XML script I have.
Unfortunately I just cannot get the script to work, my script falls over with an objRoot error when I try to set the objField using selectsinglenode. XML looks like this:
Is it possible to edit an asp file using filesystem? when I read a
text file using filesystem it doesnt show me the asp code in the <%
tags as this code is run server side, but is there a way to read ande
edit this code from another asp file
It is saturday night and guess what i'm doing. Friggin geek.
anyway. I have another question for you guys. I have a form to send emails. But i want the user of the form to be able to edit the html content, so if he wants to add bold text he can just click a button and the <b></b> tags apear in the body textbox. Much like the options we have here press the button # and you get the quote tags on screen.
I looked all over but nobody seems to have anything on that particular feature. So i was wondering if any of you could tell me or at least point me on the right direction.
I have a .js menu file that runs in all of my intranet
files.I have an asp calendar system where I can add
calendar names to a db and it will display these new
calendars. What I don't have is a good way to edit my .js
menu file to add a new menu item.
Can fso add a line to a .js file that is "live" on an
intranet or will it run into file locks? by iis?