Save a Copy of Entire DB

[somewageslave]

Hi guys! I'm new here and I recently got into a job that requires me to use Access... a lot. I'm looking for a little help, as I am deathly afraid of accidentally writing over the existing DB and reports/queries. I technically have two questions:




1.) How to save an entirely new copy of an existing DB (I've tried this already, but it seems to keep opening the old document so I'm afraid it's pulling from the same source).


2.) How to add a new field to all existing reports (for example, I have a report that shows a client's Name/Address/Age, but I now want to add new columns that will show the Client ID number and another column that might show something like a link to another report for overdue fees that this client has owed).
How might I go about doing this?


I have attached a little picture showing what the main page for the Access DB looks like.


Thank you gents!

[ranman256]

sub BackupDb()
vSrc = currentdb.name

i = InStrRev(vSrc, "\")          
If i > 0 Then
  vDir = Left(vSrc, i)
  vDb = Mid(vSrc, i + 1)
else
  msgbox "Error"
  exit sub
end if


vTarg = vBackupDir & vDb 


filecopy vSrc, vTarg
end sub

[somewageslave]

I'm so sorry - I'm very new at this. I can only assume those are SQL commands? Can you please tell me how I should use them?

[ranman256]

no, these are vb commands.
they go in a button click event, or called by a macro

[June7]

No, that is VBA which is very different from SQL.

What exactly did you do to make copy of db? I really don't know what you mean by 'keep opening old document'. Since it's a copy, both files have the same 'documents'.

Add field/column by opening objects in design view and modifying.

Have you completed any tutorials - online or book? A forum is not the proper medium for learning basics.

[somewageslave]

I just hit "Save As" to copy the entire document and have been opening it from the new document instead. However, even if I do that, it still shows the old DB's name and not the new name that I chose for it. I hope that makes sense.

I've been doing some tutorials and I can do the basics, such as adding new columns/keys to entries, etc., but I haven't quite gotten to the VBA or SQL portions yet (which the current DB uses).

Thanks for the help!

[June7]

Do you mean the name that shows on the application header above the ribbon?

The file name is not necessarily the same as the database name (title).

File > Options > Current Database > Application Options > Application Title

And how are you opening the database - directly by clicking the file in Windows Explorer or from a shortcut?

[somewageslave]

Ah, you're right. So this is an entirely separate copy that just happens to have the same application title name. I'll change that so as not to confuse myself in the future.

Thank you gents!