Re: Access 97 crash

On Mar 5, 2:03 pm, "storrboy" <storr...@xxxxxxxxxxxx> wrote:
On Mar 5, 5:26 pm, "SilvrT" <rlye...@xxxxxxxxx> wrote:





On Mar 5, 1:21 pm, "storrboy" <storr...@xxxxxxxxxxxx> wrote:

On Mar 5, 4:50 pm, "SilvrT" <rlye...@xxxxxxxxx> wrote:

On Mar 5, 12:23 pm, "storrboy" <storr...@xxxxxxxxxxxx> wrote:

On Mar 5, 3:41 pm, "SilvrT" <rlye...@xxxxxxxxx> wrote:

I am trying to run a custom database written in Access 97 on a Win2003
server. I can open the database file and work with it but as soon as I
open it's splash screen, it bombs. This app runs fine on Win2000
Server.

Any ideas out there?

*****Back up the database.*****
Open the copy using the shift-click method to prevent code from
running.
Attempt to compact and repair.

If that fails re-open (using shift-click) and attempt to compile all
modules.
Check references and see that none are broken.
Start there and eliminate the easiest problems.

It had nothing to do with any of that but I did "stumble" onto the
solution. It has to do with Win2003 server security issue called "data
execution". I allowed this for msaccess and the database worked fine
after that.

thanks for your feedback.

I'm surprised you don't get a warning or something.- Hide quoted text -

- Show quoted text -

yeah, I can't figgure that one out but I was logged into the server
for quite a while. I logged off and back on with a different username
and I got the warning then. My login gives me domain admin
rights...the second login is sysop.

There's another one to add to the 'deal with the easy fixes' list -
turn it off and on again.
Can't tell you how many times that one has worked.- Hide quoted text -

- Show quoted text -

When a client asks "why is it taking so long" I generally reply...
"ask Bill Gates"! If it weren't for having to reboot so often when we
make some changes, the job would take half the time!

.

Relevant Pages

  • Need WAN/Branch OfficeSolution
    ... We are looking for the best recommendation for the following situation ... our server is Windows 2003 Standard Edition and it has network ... We have text documents & a database file for a program we ... currently sharing a cable Internet connection The workstations in BB ...
    (microsoft.public.windows.server.sbs)
  • Re: Hyperlink problem
    ... Did you change the extension to the database file - example: ... database.mdb to database.db as part of the upgrade? ... Adding the mime type to the server will be a better option. ... >>> user could download the file. ...
    (microsoft.public.frontpage.client)
  • Re: Attaching MDF with AttachDBFilename?
    ... The database file only needs to be attached one time -at the server. ... Clients only need to connect to the server and have access to the database. ...
    (microsoft.public.sqlserver.connect)
  • Re: KB960089 Breaks Sharepoint Services Web Sites
    ... removes the "Network Services" user from the permissions list for the Windows ... go to that database file as well as it's associated log file. ... security and removed the Network Services user from both the Windows Internal ... Sql server service does not wants to run. ...
    (microsoft.public.windowsupdate)
  • Re: Local datastore for visual basic .net aplication on a pda
    ... You don't need a backend server to use ... > most of the database access controls and etc available on the full .net ... here's my questions: Is there any way to use an sql ... > database file as an local datastore without the SQL server running? ...
    (microsoft.public.dotnet.framework.compactframework)