Database Window Missing

[box2003]

The database window is missing from my application. I have tried all the
normal option settings and clicked the appropriate menu bar buttons that
would display the window, nothing happens, blank screen where the window
would normall appear.

Observation, the database window screen does seem to have the horizontal
scroll bar all the way to the right and pulling the bar to extreme left does
not seem to make difference. Horizontal scroll bar returns to extreme right
position.

The size of the database is also increased from a normal 80 MB to a much
larger 320MB. Compact and repair makes no difference, same size retained and
no database window appearance.

Any ideas on next move?

 

[Gina Whipp]

Box2003,

Open Access and under Window on the Toolbar select one of the Tile
Vertically.

As for the size, 80 mb to 320 mb in how many days/weeks/months? Are you
adding alot of forms/tables/queries? If the database is growing this size
because of the data you storing you might want to consider upsizing to a SQL
Server because you're grow to out grow the capabilities of Access rather
quickly.

 

[box2003]

Your suggestion worked. The database grows when I perform all the imports,
do the database processing, then the database does a purge of imported files
to tables, then compacts. It was failing in some instances to reduce the
size. Rediscovering the Database Window, i was able to address the form and
a table that was part of my problem...

 

[Gina Whipp]

Glad to help!

 

[box2003]

I also agree 100% on the SQL Server migration. The client will not budge
off a penny to improve what is currently in production, a bunch of Access
datbases used in a financial business as their reporting tool. Some of the
databases on completion of processing grow to 1.2 GB. Personally knowing the
2 GB upper limit for Access and explaining some of the benefits to SQL
Server, the client still does not want to spend anymore than a penny on a
solution. It is frustrating and disappointing because, when I am gone, there
might be that day the replacement exceeds the 2 GB and then there may be
problems.

 

[Gina Whipp]

Well, in that case all you can do is keep a daily back-up because one day it
will become a problem.

 

[gllincoln]

Hi,

Two options I can think of... how well they would work for you depends on
the sort of details only you know.

There are the open source databases like MySQL -

You might consider breaking the database apart, separating front end to back
end (or in this case, maybe more than one back end). Sometimes this works
as an alternative; I've had a set of Access front ends working with five
backend Access databases. It isn't as cumbersome as it sounds (the
application was fairly complex), handled everything from POS to Timecards,
sales processing, shipping, and customer service. The system had over a
million transactions in the transaction table when we finally migrated the
back end to SQL.

Hope this helps,
Gordon

 

[Mark A. Sam]

Box,

If you don't have experience with Access and SQL Server, you should be aware
that you may run into a lot of issues, especially with speed, depending on
how you use queries and recordsets. You may need to do a lot of
redesigning.

God Bless,

Mark A. Sam