Hi
I am a bit concerned about the size of my Access Database. There are no pictures or anything, just a lot of tables and queries: yet the size is 150-200MB already!
I am a bit concerned about how much this will grow when the tables start to get a lot of data in: it's manageable when working on a wired LAN connection at the same location as the server, but when working via our WAN or on Wireless it can take ten or twenty minutes to save and close!
I have set it to automatically 'compact and repair'. I did think about trying to modify the field types to save on space, but many of them are links to autonumber fields in other tables, so they have to be Long.
Is this a common problem or is it likely I've made some glaring error?
Thanks
Chris