[X]My Assistant

[JV63]

By putting that into the immediate window I get the reserved error popup (run time 2950).

[theDBguy]

Okay, so now, you'll just need to figure out a different method or approach to check if the code should run or not other than the way you're attempting to now. For example, do you even get an error with the following?

?DCount("*", "tblBackupDetails", "BackupDate=Date")

If so, can you please post all the field names in tblBackupDetails? Thanks.

[JV63]

I do get an reserved error with that immediate code also.

My backup table fields are:

ComputerName - Short Text
BackupDate - Date/Time
BackupFolder - Short Text
Filename - Short Text

[theDBguy]

Okay thanks. I don't see any reserved words in the names you used for your fields. Do you get an error with this?

?DCount("*", "tblBackupDetails")

[JV63]

Yes, reserved error as well.

[theDBguy]

Hi,

See if you can safely use DCount() against other tables without error. If so, then you might have to look more closely at the data in the problem table. Otherwise, check if you have any missing references preventing DCount() to work properly.

Hope it helps...

[JV63]

Ok, ,will take a look. the backup table is empty at the moment since it's a new module that's supposed to right to it but could have missing references for Dcount. Good suggestions.

[theDBguy]

Even if the table is empty, DCount("*","TableName") should return a 0. So, if you can't use DCount() on other tables, then DCount() is having a problem on your database. One common cause is a missing reference.

[JV63]

By commenting out the whole Dcount I got it to create a backup database. However I don't see any entry in my tblBackupDetails table.

If DCount("BackupDate", "tblBackupDetails", "BackupDate = date()") <> 0 Then
Exit Function
End If

So got closer to doing what I wanted but don't know what not having Dcount not work will do as the intent is to only create a backup once a day. I'm thinking Dcount has something to do with that.

[theDBguy]

Well, first, we'll need to make sure DCount() is working on your system. So, I would suggest trying it against a different table. As for its use in your function, it's merely checking if a backup was already created today. There is nothing I can see in the code you posted where you add a record to the table when a backup is created on a new day.

[JV63]

Yeah, something is up with Dcount cause I'm getting errors against other tables too.

[theDBguy]

Were you missing any references?

[JV63]

Not that I'm aware of. I'll have to look deeper but it's the same code I've used for other access databases and the backup module works perfectly in both backing up the back-end database and making entries in the tbl.

[theDBguy]

Hi,

If you get stuck, please consider posting a small copy of your DB, so we can give you a hand. Good luck.