BE Database on Web Site

[BillD]

I have been looking for a way to setup my database on a web-site. I have a FE
Database that connects with linked tables to a BE SQL Server Database setup
on my desktop. I want to be able to place the SQL Server database with the
Tables on a web Server and be able to access that database with the Access
Front End Database.
Any help greatly appreciated.

Bill D

 

[Larry Linson]

I have been looking for a way to setup my database on a web-site. I have a
FE
Database that connects with linked tables to a BE SQL Server Database
setup
on my desktop. I want to be able to place the SQL Server database with the
Tables on a web Server and be able to access that database with the Access
Front End Database.

If you are talking about accessing a Jet or ACCDB BE from an Access front
end _across the web_, you need to look into Windows Terminal Services,
Citrix Metaframe, or other remote access software. The web connections just
aren't fast enough for it to be feasible to run a split database over the
web. On the other hand, if your web database is providing data for a web
app done in .ASP or .ASPX and you have a workstation on the same LAN as the
server, then you are OK -- provided your local user can obtain appropriate
permissions on the server.

Larry Linson
Microsoft Office Access MVP