Link Table First of Month

[surfbum3000]

I created a macro that links to a table in a Access database. On the first of every month, the database name changes to the current month name; e.g. this month (June 2005) the file is named 062005CALLS.MDB. Next month, on the 1st, a new file is created and will be named 072005CALLS.MDB, etc. I manually link to a table named LoggedCalls in the current named file. I would like to automate the process by:

1. Run the macro only on the first of the month. Can I use
Select DateAdd(mm,DateDiff(m,0,GetDate()),0))

2. Link to the table LoggedCalls regardless of the current database file name. Is there a way to set it up so I can link to the table in the file name C:\LOGS\MMYYYYCALLS.MDB?

 

[JamesLean]

Does this have anything to do with SQL Server? If not you might be better off posting in an Access forum.

--James

 

[surfbum3000]

sorry. posted wrong place.