> I think i have replaced all of the queries that reference that field. I > agree, the should both be numeric, that's why I changed it. > > The two datasources are separate as it is easier to manage like this. One is > to record information from the site, the other holds admin information. The > admin database is small at a few MB but the logging database is around 100 > MB so it is easier to copy the admin DB to and from the production server > without the logging information attached. > Sounds like a good plan.....
Just planting a seed.... Have you thought about using a more robust DB for the logging? Another 50 to 100mb and Access will become totally unmanageable, rather just difficult to manage. (Honest guv. I haven't been in that situation in the past) Regards Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
