Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Data Access Page
0 views
Skip to first unread message
DW
Dec 7, 2009, 10:51:01 AM12/7/09
to
I designed a Data Access Page. It works well at the office, but a user from
the field said she got this error: "Data provider could not be initialized"
and "Microsoft Jet database cannot open file. It is already open exclusively
by another user or you need permission to view file". Can anyone help?
the field said she got this error: "Data provider could not be initialized"
and "Microsoft Jet database cannot open file. It is already open exclusively
by another user or you need permission to view file". Can anyone help?
DW
Dec 8, 2009, 10:33:01 AM12/8/09
to
I have established a Data Access Page, where the html file can be shared with
field offices. However, the DAP refers back to the database, and even though
I moved the database under the same folder, the field offices are unable to
access the data through the DAP. It seems like some type of access issue.
Help?
field offices. However, the DAP refers back to the database, and even though
I moved the database under the same folder, the field offices are unable to
access the data through the DAP. It seems like some type of access issue.
Help?
Sylvain Lafontaine
Dec 8, 2009, 12:34:22 PM12/8/09
to
You cannot use the ODBC or the OLEDB provider for MS-Access/JET over the WAN
(Wide Area Network, Internet), only over a local LAN or through a VPN (but
in this case, the performance will be abysmal). If you want to go over the
WAN, you could use SQL-Server as the backend (performance will be OK is you
know how to do it right, otherwise it will plunge down too) or use remoting
with Terminal Server (probably your best option in term of simplicity and
performance but this is not a free solution).
(Wide Area Network, Internet), only over a local LAN or through a VPN (but
in this case, the performance will be abysmal). If you want to go over the
WAN, you could use SQL-Server as the backend (performance will be OK is you
know how to do it right, otherwise it will plunge down too) or use remoting
with Terminal Server (probably your best option in term of simplicity and
performance but this is not a free solution).
In all cases, using Data Access Pages is more or less a dead end: they have
been deprecated in Access 2007 and probably won't be supported at all with
Access 2010.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
"DW" <D...@discussions.microsoft.com> wrote in message
news:344F5574-92B0-4CE3...@microsoft.com...
david....@virginmedia.com
Feb 22, 2010, 2:41:28 PM2/22/10
to
"DW" <D...@discussions.microsoft.com> wrote in message
news:344F5574-92B0-4CE3...@microsoft.com...
Leo Schulz
Feb 23, 2010, 3:16:24 PM2/23/10
to
<david....@virginmedia.Ich habe kein Wort verstanden.
0 new messages