By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 3,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Problem Opening Access forms and macros from database residing on a Windows 2000 web server using IIS

P: n/a
I've tried to research this problem, and I haven't been able to find
any references to it. Probably because I shouldn't be doing it, but it
was working, and now it's not.
I'm trying to develop a small application to run on our intranet. I
have a lot of old knowledge, and not a lot off access to new knowledge,
so I'm shooting from the hip and fumbling.
I have a small Access database that I'm using as a back end for some
..ASP pages. There are a couple of tables that are linked to a SQL
database running on a separate server. I'm able to update the Access
tables on the web server from the .ASP pages, no problem. I wrote some
reports and queries in Access, and I can open the database on the web
server by using My Computer and opening the file on the web server,
just like it was any other file server. I can open tables (including
the ones that are linked to the SQL server), and run reports and
queries, no problem. I wrote a macro to run several queries, and when I
try to run it, my computer freezes. I can't even end the application,
I have to manually turn off my computer. The same thing happens when I
open my Switchboard form. If I FTP the database from the webserver
down to my desktop, everything works fine. It also worked fine before
our network folks set up a new web server and copied some stuff over
there. I'm thinking that there's probably some option or reference
that needs to be set, but they don't always like to help us with this
sort of thing. Does anyone have any ideas?

Dec 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
kkrizl wrote:
I've tried to research this problem, and I haven't been able to find
any references to it. Probably because I shouldn't be doing it, but it
was working, and now it's not.
I'm trying to develop a small application to run on our intranet. I
have a lot of old knowledge, and not a lot off access to new knowledge,
so I'm shooting from the hip and fumbling.
I have a small Access database that I'm using as a back end for some
.ASP pages. There are a couple of tables that are linked to a SQL
database running on a separate server. I'm able to update the Access
tables on the web server from the .ASP pages, no problem. I wrote some
reports and queries in Access, and I can open the database on the web
server by using My Computer and opening the file on the web server,
just like it was any other file server. I can open tables (including
the ones that are linked to the SQL server), and run reports and
queries, no problem. I wrote a macro to run several queries, and when I
try to run it, my computer freezes. I can't even end the application,
I have to manually turn off my computer. The same thing happens when I
open my Switchboard form. If I FTP the database from the webserver
down to my desktop, everything works fine. It also worked fine before
our network folks set up a new web server and copied some stuff over
there. I'm thinking that there's probably some option or reference
that needs to be set, but they don't always like to help us with this
sort of thing. Does anyone have any ideas?
You really cannot run an Access application from a web browser. YOu can
access the jet tables and even use Access' queries. But you can't use
forms or reports directly.

there is software available that apparently allows access to Access
reports via the web. See this list and links:

http://webpages.charter.net/bobalsto...s%20from%20Web

If you want to read more about my investigation into porting Access
applications to the internet, read on here:

http://webpages.charter.net/bobalsto...20Internet.htm

http://webpages.charter.net/bobalsto...onSoftware.htm

Have fun.

Bob
Dec 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.