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 RepliesHello 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.
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.
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
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 RelatedNovice 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.
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
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.
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..................
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.
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
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?
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..........
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.
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
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.
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.
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)
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.
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
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.
Hi,
My database consists of some personal data and a photo of each person.
I am trying to include these photos when I browse the database via ADP.
I have found instructions how to do so at Microsoft website (article ID: 285820)
Link for it: http://support.microsoft.com/?kbid=285820
The problem is I cannot make it !!!!!!!!
Where exactly should I paste the VBscript in the page code to execute displaying of the photos???????
I am happy to send you the head portion of my page code if anybody knows where to paste it.....
Please help,
Jimmy
Hi. Does anyone know a web hosting company that supports Data Access Pages? Thank you.
View 4 Replies View RelatedI've made an adp (access project ) file. I want to permit some users to look in the data but i'm not certain they have access installed, can i give them read-only rights by placing a data-access page in a network map? Can they use the functionality of a data-access page without having access installed?
View 1 Replies View RelatedI am a newbie at Access. I have uploaded an Access 2013 file and an Excel 2013 file to show what I am trying to do.
(I also incorrectly uploaded this question under QUERIES - since marked there as 'Solved")
The Access tables that I have created are meant to mirror the individual fields on the Excel spreadsheet.
On the Excel spreadsheet, I would enter data in the rows as the data becomes available.
The Access file contains the excel fields as tables. Some of the table fields consist of only one field and others have many fields.
I have created Primary Keys in all the tables. But I don't understand the process well at this point in time.
I need to know how to create proper relationships, and then, to create a query or a form to enter new data as it becomes available so that I can keep adding rows of data (query to enter and update data) and subsequently run queries to analyze the data
Need to create the correct relationships and a query that lets me update all the data for new cases, as an individual row (like on an excel spreadsheet) .
I have a table with 715K records. Each record is an inventory product, and the sixth field of each record is a short description. The tenth field is a single-letter category designation, and is currently blank. What I want to do is search through the description field of every line, and where the word "Paint" is contained, enter a letter "P" in the category field.
View 2 Replies View Related