Well, eventually they will both be switched over to SQL server 7. we are keeping it like this until we have finished development and one day it will get switched over. The main site DB is SQL. ----- Original Message ----- From: "Stephen Moretti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:52 AM Subject: Re: [ cf-dev ] More than one datasource in one query
> > > 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] > -- ** 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]
