Data Access Pages Using A Relational Database
Aug 11, 2005
Im creating a data access page overtop of a relational database. the database is simple... it has customers and workorders. there may be more than one workorder for a customer.
When I create a new customer record through my data access page, I want it to automaticly create a new workorder (filled with 0's)
Does anyone know how to do that?
Thanks
--Ben
PS: I understand SQL... I just need to know where to enter it (if necessary)
View Replies
ADVERTISEMENT
Jan 17, 2013
I'm attempting to set up a relational database utilizing a composite key of several data fields. I had no problem doing this with FileMaker Pro yet with Access 2003 I'm having problems. For example, in Design View I select the field names needed for the composite key.
Yet when I click save I get a message "Microsoft Access can't save property changes for linked tables." As a result I'm not able to construct a composite key of the several data fields selected.
View 1 Replies
View Related
May 13, 2005
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 1 Replies
View Related
May 13, 2005
I am getting very frustrated(and surprised) to see there was no answers to my question regarding Data Access Pages yet. I searched the web and manuals and help in Access, but no luck yet...
Can anyone tell me if Data Access Pages really works? I just came to know about it while developing MS Access application...I just thot it will be cool to go web with less effort...
Thanks very much...
------------------------------------------------------------------------
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 7 Replies
View Related
Aug 9, 2005
I'm setting up data access pages that will be accessed over the internet. Because of this I want to make sure that everything is secure. I am using IIS 5.0 (Windows XP) as the web server. I used the three-tier authentication approach discussed in the microsoft article here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp) So I'm pretty sure that the authentication is secure. But what about the communication between the browser and MSDE during databinding? Is that secure?
Wanting to make sure I set up a SSL certificate which secures the page and set the Remote Server in the connection settings in the data access pages to "https://domain.com". Does this secure the comminication between browser and the server?
Thanks in advance
View 1 Replies
View Related
Dec 6, 2005
If I build an access database that uses data access pages, are all users required to have a copy of the MS Access software, or does the database run strictly off of the browser?
View 1 Replies
View Related
Nov 19, 2007
Novice user here. I have created a database with tables,queries,forms and reports. I'm now trying to create a webpage that will run the reports i have created. At the moment i'm the only user that will run these reports (via webpage) so the database is on my computer.
I have created a data access page using a query but the records are displayed 1 by 1. I need it to display like my reports.
Sorry if you're confused. Thanks for any feedback.
View 1 Replies
View Related
Sep 9, 2006
I have generated a data access page from a table. I want this page to be used on the Internet where users can enter their data and the info is automatically sent to the access database.
But when I accessed the page in the browser, I can not edit the fields and do any inputs. Have I missed something?
tks
View 1 Replies
View Related
Sep 30, 2007
Hi,
When I create the Data Access Pages, I put the table values fields on the page, but it does not allow the user to edit the data. If I just create Textbox there, we can type it. So, Does the Data Access pages only view data? It doesn't allow the user to edit data. And also, I create a few button over there, and I want to create a few different function of each button, such as Update, Add, Delete. But, The properties of the buttons do not have the click event. Actually, I know that the forms can do it.
Actually, what is advantage of using Data Access Pages? I feel that Data Access Pages can give me a lot of help. It has many limits. It just created by HTML format, and save it external (I mean that it will not save inside the db file, but it just link the file to db file)
I thought it is just simple webpage, only view data, and search data. That's it. It doesn't allow us to edit data on Data Access Pages, create button.
View 1 Replies
View Related
Aug 3, 2005
Hello all
I have fell into Data Access Pages (yes, it hurt :p ), and have absolutely no knowledge of HTML or Javascript (though fairly competent with vb), so please bear with me!
When you are using normal forms in Access, you can launch a separate form from a command button, and bring up a record based on a value in a combo box - for example, Form A has a combobox1, and when cmdbutton1 is pressed it launches Form B and displays the appropriate record, using the criteria of combobox1.
My question is, is there a way to duplicate this functionality when using DAP?
Cheers for any insight..................
View 2 Replies
View Related
Feb 2, 2006
I have a table with three fields:
AutoID : AutoNumber
Name: Text
RecordID: Number "Long Integer"
I have created a form that aytomatically starts a new record and I have also
placed the following Code in the form's module:
Private Sub Form_Current()
' Comments: If this is the first entry then set the RequestID to 1,
' else find the maximum RequestID and add 1 to it.
If Not IsNull(DMax("[RequestID]", "tblMain")) Then
Me.RequestID = DMax("[RequestID]", "tblMain") + 1
Else
Me.RequestID = 1
End If
End Sub
I have saved the form as a Data Access page but the code doesn't work and
I couldn't find a code simialr to that which I can use in my html page?!
Maybe I can use ADO to open a recordset ans search for the maximum value
but I don't know the exact code and how to write the result back to the
recordID field in the html page?
Thank you.
View 2 Replies
View Related
Dec 26, 2006
Sir,
In MS Access there is a separate option to create "data access pages". Can we publish these pages on web.. Please help me
From
somashekhar
View 1 Replies
View Related
Jan 30, 2007
Hey there,
I have created a tabular style DAP using the page wizard before. I used to have the option, but now I only seem to have columnar style. Is there an option I have to select somewhere?
View 2 Replies
View Related
Dec 18, 2007
G'day,
Putting together some data access pages to display data from tables.
All is good except a property that I do not like, when there are multiple records in the returned recordset from the query to the page, I have grouped these by ID (for example).
Each time you move to next record the display contracts back to just the top level of display, that is with the the ID number displayed in a text box and a "+" to expand it out to see the details of the record under that group.
I would like have it always expanded to show the details of the records as I scroll though the ID numbers (the top level of grouping), rather than having to expand for each ID number to see the details.
Not sure that is clear, but any ideas..........
View 1 Replies
View Related
Oct 11, 2005
Hi all,
I am a new user to Data Access Pages, I have no idea what I am doing. I have been reading some things through this form and have not found anything really of any use. So I am asking myself if anyone can help me. I have a database all ready created and I would like to change that into Data Access Pages. I have file save as my Form to Data Access Page, however when I look at it in webpage view the command buttons dont work. I have no idea what is going on with the code. could anyone help me please, thanks in advance.
View 1 Replies
View Related
Jan 1, 2006
HI Sir....
I want TO Attach my ASP PAGES WITH ACCESS DATA BASE THROUGH DSN...WHAT WILL BE MY CONNECTION STRING IN ASP PAGE???
RIGHT NOW..I HAVE MENTION DATA SOURCE NAME IN MY ASP PAGE...AND MY CONNCTION STRING IS.....
conn.connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Mydb.mdb"
..........
Now..i want to connect through dsn...plz tell me what altration i have to do in my Connection string..and secondly what will be the location of my Access Data Base
waiting for ur Quick Reply
Thx
View 2 Replies
View Related
Mar 18, 2007
I have a database that I want to share with everyone on the company intranet.
Many people upgraded to IE7 (because they have auto update on). I can access
the DAP on every computer using IE6 without a problem. However, on every
computer that has IE7, upon attempting to open a DAP, IE7 crashes. Only one
computer with IE7 has no problems opening it.
I am not a hard core tech geek, but can muddle my way through. Can someone
please help me? Is there any settings in IE7 that needs to be changed etc? I tried running IE7 with add-ons disabled. Then the DAP loads but the fields have no links to any data and I get a message saying, OWC is needed (which is predictable as I have the add-ons disabled). I compared the add-ons running on two different machines running IE7 (where the DAP loads on one machine and causes IE7 to crash on the other), however could not see any difference. I would appreciate any input.
View 1 Replies
View Related
Jul 24, 2007
Is there a way in data access pages to have where the user tabs to a numeric field in an existing record, that it highlights the data? Or....... is there a way to have currency values null instead of $0.00 in an existing record on a data access page?
The problem I'm having is: For my data access page, the user queries to pull up an appointment. The user then enters various amounts in different fields. I have the tab order set up ok, but when they tab to a field to add an amount collected, it tabs to the end of the $0.00 which makes the user have to backspace 3 times to enter data, or highlight and delete and then enter data....... All of this, of course, is time consuming.
These values are null, but show as 0 in my data access pages.
How can I get these to remain blank, or how can I get it to highlight the data in each field on tab?
Thanks in advance.
View 1 Replies
View Related
Feb 18, 2008
Hi folks, I'm new here - pretty hot at Excel but a total newbie at Access, So..
OK, I've got my database up and running. It keeps records of about 500 staff - everything is working fine but I now want to do stuff beyond my capabilities.. I've got a master record (Master Staff List) and a main input form (Data entry/amandment form). One of the input controls (via a sub-form) is for recording the time staff have spent working at a higher grade. Now if this was a one-off occurrence I could handle it but any one person could have multiple occasions that need recorded and I don't want to 'overwrite' the previous record. I have tried researching the problem and I think I need a 'one-to-many' relational table and a way to add a new period from the subform when required. The subform would also need to show blank when I opened it.
Any help would be appreciated.
View 5 Replies
View Related
Jan 19, 2008
Hi guys, I'm fairly new to databases and am just creating sample ones at the moment and following tutorials from books. I tried to create my own cinema/movie database yesterday and there's something wrong.
I really wanted to work this one out for myself but after trying many different combinations of various relationships I just can't seem to get it working.
I have four tables..
A member table: MemberID
A booking table: MovieID, Screening Number, MemberID
A movie table: MovieID
A screening table: Screening Number
So the booking table is a composite key that links the member tbale (via the memberid), the movie table (via the movieID) and the screening table (via the screening number)
The problem occurs when I try to make a booking form for members to book a movie.
I use the form wizard and take the following fields:
The MemberID from the member table, the Screening Number and MovieID from the booking table. Then I add other relevent information from the Movie and screening table (for example, screening time, date, price etc from the screenig table and movie name, information from the the Movie table)
The MemberID is displayed on the main form with the other information in a sub form.
The problem I am having is when I enter a booking on the form, I get an error telling me the Microsoft Jet Engine cannot find the screening number in the screening table or something like that.
It lets me enter the other information but not with the screening number.
Thanks for any help.
Benn.
View 2 Replies
View Related
Apr 14, 2012
I am trying to set up some data access pages as data entry into a table with access 2000. I can see the records in both the data access forms and the HTML forms, but cannot create new records into the table. I have tried to change the property to DataEntry etc... but nothing seems to work.
View 2 Replies
View Related
Jan 29, 2006
Hi,
I'm currently putting together a database for a medical NGO in Cambodia (http://www.medicorps.com/updates/cambodia.html) and am looking for some advice. The simple database is for logging client referral cases by Cambodian doctors to a team of international doctors. I haven't used access in 10 months and despite programming in access for 5 years progress is very slow. At the moment I'm designing the input and search forms. I was thinking that a more logical approach would be to convert the forms to access data pages and put the database online. I haven't used data access pages but from what i know their fairly limited?
The goal would be the ability to log/search the data with auto updated pull downlist based on the actual data. Ultimately I want the data compiled and emailed to a email list from withing the website. The trouble is I have no idea how to do it.
Thanks in advance for your help.
View 5 Replies
View Related
Mar 20, 2006
Hello
At our firm we have a mix of Microsoft Office (2000) Standard licenses and Microsoft Office(2000) Professional liceneses.
After reading through a lot of literature from Microsofts own site it is possible to create Data access pages to enable users to view and have basic inputting into an access back end database.It also states that you need a qualifying License to use microsofts 'web components' to be able to do this.
Now another of our offices has decided to 'check' with microsofts helpdesk about wether or not you need a seperate access license for each user and suprise suprise Microsoft state you do.
Their own site states that Office standard IS a qualifying license see here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp
but microsoft are saying otherwise....
Anyone know if i am commitiing an offense or am i just being bullied by microsoft.I have asked them to produce the legislation that states i am doing wrong but they have not yet responded
cheers
View 1 Replies
View Related
Oct 2, 2006
I am building a database for users to input escalations in. The users that are actually keying the information in, do not have MS office. When they try to access the DAP html file, a message appears at the top of the page that states "The page requires the Microsoft Office Web Components.
See the Microsoft Office Web site for more information."
Can data access pages be used without office being installed? I have heard that it could also be the users internet explorer security settings.
Any help would be greatly appreciated.
View 3 Replies
View Related
Mar 15, 2005
Hi all, i have a relational database. In a form, Transactions, i have a text box, CustomerID, which relates to the primary key of the customers table. At the moment, if i enter a number that has no related record in the customers table, it will alert me only when i try to close the form or move to another record. I am wondering if it is possible to check for a related record immediately after the text box loses the focus.
thanks
joe
View 2 Replies
View Related
Jan 22, 2008
The first time a person tries to use Microsoft Access, they are likely to miss the whole point of what a database is and how to use it. When they start having trouble making it work for them, they think in terms of what they may be doing wrong in their use of the obvious tools of Access. But often their problem is that they are unfamiliar with the principles that make databases so useful and they have started with a flawed database schema.
This tutorial is intended to explain the underlying principles of relational databases. It is, admittedly, rather theoretical and perhaps even boring. But without an understanding of these principles, a beginner cannot hope to use Access for any really useful purpose. If you are a beginner, I urge you to read through the entire tutorial.
There are several issues that arise time and time again, such as:
. Storing multiple values in a field.
. Storing calculated values in a table.
. Determining primary keys.
. Using Autonumbers.
. How many tables does this database need?
. Why don't my queries work?
Sometimes answers in the forum make it sound like these things are a matter of preference, or "which is the best?" But in most cases, they are not--there are well established rules that determine the one correct answer. It is only with an understanding of the principles of relational database theory that you can determine the answers.
So I hope you will find it worth your time to study this 7-page tutorial. If you think you've found something in it that's incorrect, incomplete or impossible to understand, please feel free to contact me. I have been known to make mistakes!
View 5 Replies
View Related
