Create a field from a database name

[sleoni]

Hi All,
I have multiple access databases each with a single table in them and I need to take the name from each of them and have a field in the individual tables automatically created and for each row of data in the table I need the new field to be populated with the individual database name. Is there a query that can do this? Even if I have to run a query on each database to create and populate the field.

Thanks for looking

 

[pwbrown]

Not sure if CurrentProject.Name will work or not.