Andy P via AccessMonster.com wrote:[color=blue]
> 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:
>[color=green][color=darkred]
>>>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![/color]
>>
>>You're making no sense whatsoever here. You're probably either not
>>using Access properly or are confused by it.[/color][/color]
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
