Access fails when attempting to view SQL table

  • Thread starter Thread starter Paul Newlin
  • Start date Start date
P

Paul Newlin

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
 
Just tried that - worked brilliantly.
Log file has gone from 2Gb to 1Mb !

Thanks
Paul
 
Back
Top