Hi all,

After reading all the posts in this thread

I think i might have to restart the project i working on. I have about 6 Access apps all at about 20mb...

wouldn't taking the SQL from the queries and creating them in SP's and Views be a good start. It would depend on the complexity of the prog. If it is...

If the transaction log is being backed up regularly , shouldnt the SQL server be overwriting the commited transactions ? if you have an adequate size for the transaction log,...

I too have the same issue, and have not been able to find an easy way to do it, short of changing the queries to SQL format in the design...

The other thing to do after this would be to set defaults on those columns you dont want nulls in? This would minimize having to do this sorta thing...

Thanks for that information

I think I could start with that first and then see how else to lock down the system

Thanks again for the info ! 🙂

Made my and hopefully...

Hi, Do you have a backup schedule ?

if the data is not critical (but when isn't it?) just do a transaction log backup and delete it , run some optimizations...

I agree that it could be just a logon issue

with the SQL server

You can also register and update the current instance of SQL server in Active Directory, If it hasn't...

I had a similar issue (not with sp3) but it was because someone had changed the actual directory to the default dir eg (\mssql\backup\) as opposed to a drive that...

Hi MDACs have been checked and we have upgraded MDACS to the pre XP machines to XP standard and they still work but the XP's dont. Maybe I need...

Ritch,

I use SQL7 and SQL2000 and i find the SQL7 to be a little buggy in this instance, it could be the setup...

Thanks for the info on this guys. 🙂

Hi,

Is there a specific way to set SQL server to use simple mode in SQL7 ?. I cant seem to find doco on this and have looked almost everywhere. Its...