Hi, I went to school over 4 years ago learning ASP but I forgot almost everything.
I am able to setup a connection to a an Ms Access file and get information using Windowx XP's IIS.
I need to change the code where the location of the Access file is on my computer to my webhost.
In other words, I have uploaded all the pages and the Access db file but now the pages can't find the Access db because the file was original on my computer in a certain folder. Now that it is uploaded, I need to change the location where it searches for the db from my computer to my webhost.
I have not dealt with ASP for almost 5 years ago.
Please give advice, or websites or 3rd party programs that can do this for me.
I am trying to build a webiste where you enter the username and login then be able to retrieve information or update, or add new or delete from the Access db.
This should be a simple problem for most you professionals out there.
I've searched and could not find what I was looking for. I have NO database experience but need to learn quick
I have an html page with an iFrame (flash menu on left - iFrame on right) When I click a product image on the left this is what I need to happen. - Flash send a variable - The iFrame to load an HTML page that will populate with an image, 2 text fields, and 3 hyperlinks dependant on what product is clicked in the flash.
I am using access since it is what i have at work, and i can just add all the products in a table pretty quickly and easitly. I set up a table in access with the image, hyperlinks, and text that needs to populate in the html page. The HTML page is set up in tables if that makes a difference...
I just don't know where to go from here to make my connections and how to set it up.
I have a combo box that is populated by a query. The problem is that the query pulls data from a different database than the rest of the form and it prompts the user for a password to access this database. Is there any way of coding the password into the form so that the connection to the database is opened automatically without prompting the user? Thanks.
I'm trying to use a banner ads .asp program called Admentor. My problem is that this uses DNS less connection and I can't get this working on both the pages showing the ads and the admin panel.
I know it's the path to the database that causes this. If I change this to suite the webpages showing ads, it work's, and if I modify it to suite the admin panel it work's. But not both at the same time.
Should'nt this path be relative to the sites root ?
when using this string, the webpages showing banners is working, but when clicking on these, the site calles a redirect .asp page that also uses this database connection. Then it fails, since this page is located in another folder in the site and therefore also gets another path to the database.
How can I get this to be a relative path working on all pages not been worried about folders, subfolders and correct paths to the base ???
hi, below are the codings i input. I just cannot get the connection to open. error is at "objConn.open" I have also given the user full access right. folder attribute however, always reverts back to "read-only" whenever i try to turn "read-only" off. Please help!
Set objConn = Server.CreateObject("ADODB.Connection") Set objRs = Server.CreateObject("ADODB.Recordset")
I apologize first of all if this question is bounced up and down through out the forum all the time, and if there's already a topic on this, then it'd be perfect for me. But im not having any luck.
I do not know how to upload my database in a way that it will work when i try to use a page through microsoft frontpage to display results from it.
What are the accurate steps into creating a database connection? Thanks a bunch
Really don't know the answer to this question and I thought I'd come to the experts. I have created an Access database that I use to push & pull data from an SQL database through linked tables. I created an ODBC connection on my PC and set it so the links keep the username and password for the ODBC connection. All that works great...Now my question - Is it possible to somehow "store" the ODBC connection within the Access database so that I don't have to go to every PC that is going to be running this database and create an ODBC connection? The Access database and the SQL database both exist on our network and all those that will be using it have access to both. If someone has the answer I would really appreciate it.
Im doing a login page for my website, and i am having trouble connecting to the DB:
'Database connection info and driver strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein; DBQ=" & Server.MapPath(strAccessDB)
where strAccessDB = "cs334-45/Kosy/Kosy.mdb"
cs334-45 is my computer name in the virtual directory.
Im getting this error:
Server.MapPath(), ASP 0172 (0x80004005) The Path parameter for the MapPath method must be a virtual path. A physical path was used. /Kosy/check_user.asp, line 21
I dont understand. I thought that the virtual directory was mapped to the physical directory anyway? So why do I have to enter a virtual path?
We have split a database and have about 6 users connected to a gigabit switch. There is a noticeable delay of about 5 to 15 seconds when we search by an account name. We are working with a split form, where it has the database records listed at the bottom half of the screen.
Is there a way to improve the performance? I tried a persistent connection, but it didn't seem to work and would occasionally get an error message.
hi guys, this is my first thread on this forum...,, i am new out here..
i am not able to establish a connection with a MS Access database. I am using DSN Connection for it..
The error that i am getting is...//
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] 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. /airtickets/scripts/dbconn.asp, line 4
I have a back end 2002 DB. I would like to disallow access to this through odbc connection. Is there some way this can be achieved? Thie directory where it is located is unfortnately cannot be restricted as the front end mde also resides there.
I am looking to automate the process of linking my Access DB with an ODBC connection to an SQL DB with VBA (unless there's an easier way to do it?) - some sample code - if this is possible at all?
we have Oracle 11g as main database and for viewing purpose, we have created an mdb (Access 2007) using Link tables via ODBC connection (system DSN).While querying, count queries are working fine with accurate record counts but, all select queries are not working fine. It filters and displays with wrong records. There is no issue in query building.how to get correct records through odbc connection to Oracle database.
I have MDB database linked to SQL SERVER through VPN connection.I created links to the sql server Links are dsnless..Everything works fine but when I lost VPN connection or sql connection has been broken I can't refresh links to the tables.I receive message 3146 sql connection failed..I must close database and start again...
I tried different methods like ado,dao, and vba docmd.transferdatabase,aclink... but no success, table cant be relinked.
Only way I can relink is to change ip adress in conn.string
E.g. 192.124.0.2 (1st ip- router server ip) and after connection failed i can use 192.124.0.32 (2nd ip - server local ip) and that's it if i lost connection for the 3rd time... i must restart application.
It seems that access database keep the previous connection..how to reset or drop database connection to the sql server and refresh links to the tables with vba code without closing access database...
Right Ok i hope i can get some help cause im absolutely stumped.. i cant get my login page to work since moving it from my PWS(iis on xp) DSN connection to a 24/7 server on the net with DSNless connection here is the code for the include file "conntopwd.asp" http://www.pritchardwebdesign.pwp.blueyonder.co.uk/conntopwd.txt the username and path has been changed slightly for security purposes, and the code for the login page which attempts to access the database is here http://www.pritchardwebdesign.pwp.blueyonder.co.uk/login.txt the connection has been tested by one of the tech support guys at brinkster and he told me it was ok, the problem was the way that the data is called from the data base is wrong .. The tech support guy said that it was this line that was causing the problem.. MM_rsUser.ActiveConnection = MM_conntopwd_STRING Any help would be much appreciated as im stuck for now..
I have created a new Access database and need a few additional things that I would like to add. I created a database for inventory within my company. Only a few people will have access to it so security will not be an issue. However, I have a couple questions. Is their a way to have a popup when you open the database to insert let's say the serial number of the computer (already in my forms) and then it will automatically bring up that information. Also, I do not want any of my forms edited. I want this done strictly through the tables. So this leads to my next question. Is their a way once you have a form up that you can enter a different serial number and the information will automatically populate. If not, can you add a search query or option or what needs to be done. Thanks in advance for your help.
I'm not sure if I have posted this in the right section, but i'm sure someone will tell me.
I have 2 questions, first is about concatenation. I've looked endlessly & have tried a few scripts, but all to no avail.
eg db: Name: Dpt: Tom sales John sales Jerry mgm Albert sales Keith mgm
eg report that I want Sales - Tom, John, Albert MGM - Jerry, Keith
What is the best way to do that?
2nd Question. In the same db, what i'm wanting to do is if I change the data in any record, it will track the changes.
eg Albert has changed departments from sales to management (mgm as above), and so when you view albert's information, you can do something to pull up any & all changes made to that particular person. Any ideas there! Once again, i've searched the net and can't seem to find the best result.
I am just a new greenhore learning ms access and I am planning for a warehouse/inventory storage database.
My question :
1) I have 4 product division (Do you think it is good to have 4 tables):confused: 2) The calculation field. (How does the mechanism work when I take the the item out from the inventory, it will show as total storage -1 (eg, the storage have 5 units and I took 1. it show balance left 4).:confused:
About question 2, is it that I have a to do separate table again.
Temporary, I have these 2 problems and hope all access expert can help.
I am fairly new to access and am trying to put together a project for work. I need to be able to create a list of all of the employees and which team they are in. So no problems with this.
I also need to be able to mark in their records where they can advertise and the quota they have. Each employee may be able to advertise in more than one location.
What I would like to create is a form for each team that displays the employees and where they can advertise. So far I have managed to get a subform to show this for each office but each employee has record for each job board. See Picture1.http://i112.photobucket.com/albums/n170/nharri/1-1.gif
Ideally I would like something like picture 2. http://i112.photobucket.com/albums/n170/nharri/2-1.gif
Hello!First of all I am new to these forums and I'm also a beginner with Access so have patience :) and I don't know if this thread is in the correct part of the forums so if a moderator feels like it's not feel free to move it.Me and a friend are interns at a company in US and the company assigned us to gather data from several excel sheets and build a completely new database. This database contains several tables.This isnt the correct names of the tables, it just to give you an idea how it looks at this moment.Customer information. (key: Customer ID)Resellers (Key: Reseller ID)Newsletter subscriptionsProducts (Key: Serial Number)Software (Key: Licence) Product2 (completely different product from the others) (key: Serial number)Invoices (Billing information, debit, credit, etc) (key: Invoice ID)OK, that explains how our tables looks like. And ofc in the tables we have different fields.Our problem at this moment is our form. Because we want to use a form to enter the data. We believe that it will be the fastest way and the easiest.I have a picture for you to show you our problem.It seems like the FORM is looking in the same table. But we want all the "fields" in the form to represent its own table. We tried to gather all tables into 1 Query and use the query when we created the form, the problem dissapears BUT a new one comes along. If we use a query in the form we can fill out all the fields but we can't create a new "record" with empty fields to enter more data hence leaving us with only one record of information. This is realy starting get on our nerves. Can someone help us?
Hi there, Heres my situation I have a basic form for a customer shopwing all general details the top field is Customer ID in which I would like to enter a customer ID and for the rest of the data to appear for that customer in the remaining fields, I have a small amount of knowledge with access and believe I need to a Dlookup but I am unsure where and how to put this expression i'm thinking maybe in a query. Any help would be great, My field names are listed below to make any help a little clearer
Hi this should be very simple, but it's not for me. I am creating a database logging machine error's. Each error has a recorded start and end time, which I enter. I want the database to enter the elapsed time into a third field, 'ElapsedTime'. I see how to do this in the builder, just subtracting the two fields. But I know not to make it a condition of my query, that doesnt make sense. Where do I put my expression so that my table updates itself with the new field?
I am creating a database concerning products sold.
I am a beginner of using Access Database and would like to know if this is possible...
At the designing stage of tables and relationships is it possible to link and construct, so that the stock quantity of each product is kept up to date. so, when an order is made of produc '123', product '123' updates it stock quantity be deducting the quantity ordered.
I need to figure out how to program an expression that will reset a value on a form to zero if the product of it's calculation is less than zero.
I am figuring out sales commissions for listing Ebay items and there are some instances where the item doesn't sell, so it's a net loss because of the fees Ebay charges to list the item. I have programmed the form to take 10% of whatever the net gain is and use that as the salespersons commission. But in instances where the item doesn't sell, it actually takes money away since 10% of a negative number is a negative value.
In cases like this, I need the expression to just show a zero, if the number is negative.
If anyone could help, I would be greatly appreciative.
For a couple of years now I have been keeping a spreadsheet record of UK football match results and statistics - I use this as the basis for gambling on future matches. I now want to migrate this information into a database so that
1) It is much easier to enter the new data(via picklists) 2) I can generate reports on particular teams to help me on future betting decisions
Being almost completely new to Access I am struggling with the design. The information I'm capturing is: Match Date Competition(table including five) Home team/away team(table including many depending on competition) Home formation/away formation(table with standard list) Home goals/away goals(numerical) Home corners/away corners(numerical) Home bookings/away bookings(Numerical) Referee(from a standard list) All the above is in a match results records table with relationships to each data element table.
For the form for data entry, I want pick lists for all non-numerical values - eg team, formation etc. I would like to get a little cleverer and for the team pick list to only contain teams that are in the competition I've selected(eg Uk or European).
I've created some tables and relationships, but when I create a simple form with combo-list boxes, the list itself comes up blank even though I've linked the field to a particular table of options(eg a competitions table).
Can anyone help on suggestions for the overall design(should I have separate match results tables and team tables for each competition?) and with this particular combo-box problem please?
