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

Opening MS Access from a webpage.

P: n/a
I am responsible for maintaining our departmental intranet pages at work. I
would like to put a link from our website to a MS Access database which is
held on our Network drive.

The problem I have is that if Access has the startup properties set to
display a form, MS Access doesn't start (it appears in the processes window
in task manager but not in applications). If I change the startup properties
so that no form is opened and the database window is displayed the database
opens.

Does anyone have any ideas of how I can start the database with the form
running?
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Wed, 17 Aug 2005 14:21:45 GMT, "Andy P via AccessMonster.com"
<fo***@AccessMonster.com> wrote:

Access don't work over HTTP.
Rather, do things the old-fashioned and MSFT recommended way: split
the db in frontend and backend, provide each user with the frontend,
and link to the backend on some server.

-Tom.

I am responsible for maintaining our departmental intranet pages at work. I
would like to put a link from our website to a MS Access database which is
held on our Network drive.

The problem I have is that if Access has the startup properties set to
display a form, MS Access doesn't start (it appears in the processes window
in task manager but not in applications). If I change the startup properties
so that no form is opened and the database window is displayed the database
opens.

Does anyone have any ideas of how I can start the database with the form
running?


Nov 13 '05 #2

P: n/a
Tom,

Thanks for you reply. i'd already thought of your solution, but was trying to
save myself some work. Never mind!!

I still think it's strange that the database opens when I don't try to open a
form on start up, but then it's Microsoft!

Tom van Stiphout wrote:
Access don't work over HTTP.
Rather, do things the old-fashioned and MSFT recommended way: split
the db in frontend and backend, provide each user with the frontend,
and link to the backend on some server.

-Tom.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3

P: n/a
Andy P via AccessMonster.com wrote:
I still think it's strange that the database opens when I don't try to open a
form on start up, but then it's Microsoft!


You're making no sense whatsoever here. You're probably either not
using Access properly or are confused by it.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #4

P: n/a
some background info may be useful here.

I wrote an Access database a couple of years ago. I understand Access
reasonably well (I spent a whole year doing database design as part of my
BEng in Software Engineering) and as far as I know use it 'properly'. The
database resides on a network drive. At the moment the people adding records
to the database simply open the folder that contains the database, open the
database, add a new record and all works wonderfully. The Startup settings
are set so that a form opens on startup. This is effectively a switchboard,
although it wasn't created using the switchboard wizard, it is just a normal
form with a few command buttons on it to take people to different data entry
forms.

My boss decided that I should develop the departmental intranet site. He also
decided it would be nice if I could provide a link to the database. I don't
have time to develop a web based front end and run the database on the server
(either using a Data Access Page or writing some script). I just wanted the
current database to open from its current location. I thought it would be
something as simple as <a href="K;/folder/folder/database.mdb"> </a>. This
didn't work and after a few days of communal head scratching between several
Access developers at work and our IT support, using various path names and
trying with other database we found the reason why it wouldn't open.

The reason for this was the database start up settings. Because Access was
trying to open a form on startup, it wouldn't start properly. No Acces window
was opened however Access appeared to be running in the 'Processes' Tab of
Task Manager but it wasn't in the 'Applications' Tab and also a Database
Locking File had been created. I changed the start up settings so that no
form was opened and only the Database window was displayed. Using <a
href="K;/folder/folder/database.mdb"> </a>, Access started up as I would
expect and the datebase opened.

Has anyone come across this or a similar problem before, and does anyone know
of a way around it short of writing a web based front end?

Cheers

Andy


Tim Marshall wrote:
I still think it's strange that the database opens when I don't try to open a
form on start up, but then it's Microsoft!


You're making no sense whatsoever here. You're probably either not
using Access properly or are confused by it.

Nov 13 '05 #5

P: n/a
Andy P via AccessMonster.com wrote:
some background info may be useful here.

I wrote an Access database a couple of years ago. I understand Access
reasonably well (I spent a whole year doing database design as part of my
BEng in Software Engineering) and as far as I know use it 'properly'. The
database resides on a network drive. At the moment the people adding records
to the database simply open the folder that contains the database, open the
database, add a new record and all works wonderfully. The Startup settings
are set so that a form opens on startup. This is effectively a switchboard,
although it wasn't created using the switchboard wizard, it is just a normal
form with a few command buttons on it to take people to different data entry
forms.

My boss decided that I should develop the departmental intranet site. He also
decided it would be nice if I could provide a link to the database. I don't
have time to develop a web based front end and run the database on the server
(either using a Data Access Page or writing some script). I just wanted the
current database to open from its current location. I thought it would be
something as simple as <a href="K;/folder/folder/database.mdb"> </a>. This
didn't work and after a few days of communal head scratching between several
Access developers at work and our IT support, using various path names and
trying with other database we found the reason why it wouldn't open.

The reason for this was the database start up settings. Because Access was
trying to open a form on startup, it wouldn't start properly. No Acces window
was opened however Access appeared to be running in the 'Processes' Tab of
Task Manager but it wasn't in the 'Applications' Tab and also a Database
Locking File had been created. I changed the start up settings so that no
form was opened and only the Database window was displayed. Using <a
href="K;/folder/folder/database.mdb"> </a>, Access started up as I would
expect and the datebase opened.

Has anyone come across this or a similar problem before, and does anyone know
of a way around it short of writing a web based front end?

Cheers

Andy


Tim Marshall wrote:
I still think it's strange that the database opens when I don't try to open a
form on start up, but then it's Microsoft!


You're making no sense whatsoever here. You're probably either not
using Access properly or are confused by it.

Take a look at my web site for info in evolving from MS Access in
Windows to Access as part of a web site. Some of the tools GENERATE web
pages from the Access database tables. Take a good look at Raptier
(which has a FREE lite version)which does grids only and ATAF which can
do both one-record-at-a-time-forms as well as grids.

http://members.cox.net/tulsaalstons/...20Internet.htm

Bob
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.