I am not a programmer, nor do I use MS Access with any frequency, so I'm not very confident in what I've been doing. I have read everything I can find about Data Access Pages and I've tried everything that relates. I have serveral DAP's for use on our company intranet. I can see the pages with no problem, but none of the data from the database is there. I've created connection files, connection strings, change the UseRemoteProvid er to True, configured IIS server and the MDADC, created the DAPInternetAcco unt and I still can't see data. One of the pages is a directory. The datbase has three entries. If I look at the page from the host server, everything is fine. When I open from any other client the page is there, but no data. I've used several combinations of office products. The original was MS Access 2003 and FrontPage 2003. I couldn't get the pages to open. So I recreated the database in MS Access 2000 and FrontPage 2000 and FrontPage 2003. I got the pages but no data. I now have a database in MS Access 2002 FrontPage 2003 and FrontPage 2002. Does anyone have any other suggestoins.
4 2838 nico5038 3,080
Recognized Expert Specialist
I would advise you to drop your effort in using DAP's as Microsoft did drop the DAP's in Access 2007....
Best to use MS SQL 2005 or MySQL as database for your application directly from e.g. Frontpage.
Nic;o)
Thank you, sorry about the delayed response. I actually have the same database as a SQL database, but I'll need to see how to use it in FrontPage.
In case anyone else has this problem. It took a while,but I got the pages to work by creating another database (db1), imported the original database elements into the new database. When I modified the data access pages to create the links I linked to the original database. In Frontpage, I imported the database into my web, but not in the folder with my original database. My pages work now. And they can be updated from the webpage.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: John Baker |
last post by:
HI:
Does anyone know a good manual or web site that addresses the development of applications
using the Data Access Capability (HTM) in Access. I need to have something on a web site
that, at minimum, feeds controlled data to an Access data base, and have no idea how to
approach it. One key is that we must ensure that the data fed to the data base is
consistent with some table contents ON the data base. This would typically be a lookup...
|
by: luci |
last post by:
Hello
I've developed several data access pages and I searched for the same
problems in different internet pages but I never got back a usable
answer. Here are my questions:
1) How is it possible to requery a single combobox in a data access
page?
Of course it's possible to requery the whole data access page (e.g.
MSODSC.DataPages(0).Requery or window.location.reload(true)) But
|
by: Donald Watson |
last post by:
I have created data access pages for my database that is sitting in a shared
folder on the network so all my users have access to it. Everything works
perfectly.
I have 2 data access pages built. One is for editing or adding entries to
the database. The second is for running a report listing all the current
entries.
Everything works perfectly but there is one little quirk I haven't figured
out yet.
|
by: Bob Alston |
last post by:
Anyone able to do this with Access created Data Access Pages, using
UseRemoteProvider parm on DAP and getting RDS configured properly on the
server so the DAP's activeX can access the database on the server?
If so any advise, good references, etc.???
I get the UseRemoteProvider to True
I set the name of the database to \\myservername\dbdirectory\dbname.mdb
and make sure that dbdirectory is a share name on the server
with web access...
|
by: Lyle Fairfield |
last post by:
In a recent thread there has been discussion about Data Access Pages. It
has been suggested that they are not permitted on many or most secure sites.
Perhaps, that it is so, although I know of no site that has this
prohibition, and I have uploaded DAPs to various sites and used them
from those sites.
I do not understand why any site manager would prohibit DAPs. To the
best of my knowledge DAPs, as HTM files, are merely hosted on the...
| |
by: Edlueze |
last post by:
I am developing some Data Access Pages (DAP) using Microsoft Access
2003 on Microsoft Windows XP.
When I try to open these pages (located on my C: drive), the display of
the data access page is blocked and I receive the following error
message in the Information Bar in Microsoft Internet Explorer:
"To help protect your security, Internet Explorer has restricted this
site from showing certain content. Click here for options."
|
by: NoEd |
last post by:
Hello,
I am looking for some advice on whether to use Data Access Pages. Basically
they will be used on a organization's intranet. The pages will be a simple
survey, about 20-40 questions, where the users will select an answer for
each question. The number of individuals answering questions is between
50 - 75.
Data Access Pages appear to the simplest way to obtain the needed
functionality, but they are not pretty. I will be using...
|
by: SRAM |
last post by:
Hi,
Problem statement: We have some amount of data stored in various excel
sheets and we generate a few reports from these data. We are in the
process of consolidating all data to reside in a single repository.
Currently, it is semi-automated i.e. we are using MS Excel for data
entry, consolidation and report generation (i.e. using formulas). We
require a tool that will provide:
a) A web-based interface for data entry (i.e. remote,
|
by: ADezii |
last post by:
There are essentially three techniques for publishing Access Data on the Web. The first technique is static, and does not allow for the dynamic addition or modification to the data, There is no direct link to the data, and in order to update it, you must republish. I am referring to the HTML Format. The second format, IDC, is an older, obsolete technology that runs on Microsoft web Servers. IDC has limited functionality, no script language...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |