| | |
|
|
|
Access fails when attempting to view SQL table |
|---|
| message from Paul Newlin on 1 Jun 2004 |
Hi
I have an SQL Server 2000 database - running fine - ADP project against it
works well.
When I "Transfer" the database to another server I cannot view 2 out of the
20 odd tables in the database.
i.e. will not return any records when I try to open it - will not allow me
to view the design. All the other tables are OK. I have repeated this a few
times now - switching servers for the transfer.
I am desperate to reduce the size of the log file on the database - over a
gigabyte in size - and it seems as this will be the best method of doing
it - if I can guarantee that everything still works at the end.
Paul
|
| Kevin3NF replied to Paul Newlin on 1 Jun 2004 |
Have you tried backup up the log file on the SQL Server...and then
truncating the log file?
|
| Paul Newlin replied to Kevin3NF on 1 Jun 2004 |
Just tried that - worked brilliantly.
Log file has gone from 2Gb to 1Mb !
Thanks
Paul
"Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23U2uAJ$REHA.2332@TK2MSFTNGP10.phx.gbl...
|
| Kevin3NF replied to Paul Newlin on 1 Jun 2004 |
Log and data file backups should be part of your regular maintenance to
avoid this problem and provide recoverability in the event of data
corruption, hardware failures, etc.s
|
|
Archived message: Access fails when attempting to view SQL table (MS Access)
