access not opening database

  • Thread starter Thread starter Arsenie Coseac
  • Start date Start date
A

Arsenie Coseac

weird thing happenning... we use an sql connection to use
a database in the network, the odbc connection is setup,
users are allowed login, etc. but, whenever access
attempts to open the database, i get a blank access
workspace without anything on it, no toolbars, no
database...

does anyone have a clue about what might be happenning
here?
 
Sounds as if the database may not have been closed down correctly in a prior
session.

You can try running a command to compact the database without trying to open
it and see if that rescues the database.

From Start menu, using Run, enter:

msaccess.exe "Location of original database file and filename" /compact
"Location and name of new database file to be created from it"


So, for example, if the original database file is named "TestFile.mdb" and
it's located in the C:\MyFolder\ folder, and I want the compacted file to be
named "CompactedTestFile.mdb" in that same folder:

msaccess.exe "C:\MyFolder\TestFile.mdb" /compact
"C:\MyFolder\CompactedTestFile.mdb"
 
The Start-up Options of your database may have been set incorrectly.

Try opening the database while you hold the Shift Key to bypass the Start-up
Options and get the normal Database Containers window and standard MenuBar.
 
Back
Top