Access Page

J

jk

Hello,

Does a access page work in a similiar fashion as a FE/BE design where users
are sharing a folder?How does one place the tables on the web page to be
filled in from individual users?
Please advise
 
S

Sylvain Lafontaine

Not exactly; it is more like a FE/BE with Linked Tables than a shared
database under JET.

Data Access Pages are a complicated matter and cannot be explained in a few
words. They don't work well if you want to use a MDB file as the BE, even
if only locally on a LAN, and usually require that you upsize your database
to MSDE or SQL-Server, especially if you want to work over the WAN but it is
also not a bad idea even for a LAN.

S. L.
 
J

jk

Thanks,
Do you know where i can get more info on this subject since i could have
sworn i read that tables could be placed on a web site and either tables
could be filled from a remote location or at the very least reports uploaded
to the web site.
 
S

Sylvain Lafontaine

By itself, the JET Oledb provider (the one which is used when you have a MDB
file as the BE) cannot work over the Internet; you need to wrap it inside
the RDS provider if you want to. However, the use of RDS is now deprecated
by Microsoft since 2 or 3 years because of deep security concerns. If you
still want to and have some time to loose, then you can take a look at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp

With this page open, you will also find many other articles about DAP by
looking at the menu at the left. There is also a newsgroup exclusively for
Data Access Page: m.p.a.dataaccess.pages

Of course, this is about the DAP technology. There are other choices for
posting your reports to the web site, like using ASP or going whith the .NET
Framework and using ASP.NET.

S. L.
 
J

j nnh

TEst
Sylvain Lafontaine said:
By itself, the JET Oledb provider (the one which is used when you have a
MDB file as the BE) cannot work over the Internet; you need to wrap it
inside the RDS provider if you want to. However, the use of RDS is now
deprecated by Microsoft since 2 or 3 years because of deep security
concerns. If you still want to and have some time to loose, then you can
take a look at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp

With this page open, you will also find many other articles about DAP by
looking at the menu at the left. There is also a newsgroup exclusively for
Data Access Page: m.p.a.dataaccess.pages

Of course, this is about the DAP technology. There are other choices for
posting your reports to the web site, like using ASP or going whith the
.NET Framework and using ASP.NET.

S. L.
Click to expand...
 
Top