Re: Database Window Missing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" wrote:

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.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"box2003" <box2003@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9AB0CA5F-3ABB-45F1-B340-5A623012E4F4@xxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)