A database I am developing reports it is nearly 2Gb in size. As a result I cannot compact and repair it. How do I fix?

I'm not sure whether you mean that Access won't let you compact and repair or just that you don't have sufficient disk space to do so.

One solution, assuming you've got some free disk space, would be to create a new mdb and import the contents of the original database into it. You'd need to set certain things manually (e.g. Startup options) but it would cover most things.

Simon