Posted by kkrizl on 12/07/06 18:53

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?

[Back to original message]