proboably, but it can be done as long as you are carefull.

if you can establish one site first and then try some test connectivity directly between the SQL servers...

i can't see any problems changing the MDP on a regular basis as long as you make sure that other processes aren't affected.

i suppose it will give you time...

looks like your only hope is to create your own form of replication,

use update insert and delete triggers to drip feed data between sites (use linked servers to keep...

there are a couple of ways of doing it

but i prefer

use mydatabase

go

select count (*) from sysfiles where maxsize -1 and (size/maxsize)>0.85

this will tell you how many files are over the...

what was the reason for changing in the first place?

if it was a particular query or stored procedure that was causing the problem then you should try and correct that...

ok - just a few more questions, and hopefully we should be able to come up with some good ideas

what sort of link do you have between the 2 database...

what have you used as declarations for the recordset objects?

for example

Set mrstCalc = mdbCalc.OpenRecordset("tabExpectedIncomeCalc")

are you explicitly specifying ADO recordsets?

i think we can manage that.

watch this space in the next few days.

so what you're trying to do is replication between two ISPs

do you have any ideas about conflict management? what if the same record is changed at the same time on...

i've had something similar, i never tracked the problem down exactly, but it was due to the content of the email it was sending.

do you have other alerts working...

i assume your using 2005 express beta...??

if so then when you get it working can you tell me how to create a datbase??????

i've installed and all you can do is...

you can usually reinstall your MDAC from microsoft downloads.

simply choose the version number you want and install.

maybe expressing the functions with an explicit alias (AS X, AS Y) might remove the problem?

as for count(0)

i don't know - never used it before , i always find...

i did this

select 'DBCC '+name+char(10)+char(13)+' GO ' from sysobjects

and got

DBCC sysobjects

GO

DBCC sysindexes

GO

DBCC syscolumns

GO

DBCC systypes

GO

DBCC syscomments

ok - have you installed something like XP service pack 2? this apparently tightens security - i wonder if it's done something stupid like block port 1434 or 1433

if not...