Making a Demo All Access App. from ann Access FE and SQL BE 2

[sanan]

Hi there
I have made an App. using Access as FE abd SQL as BE, I would like to make a Demo Version of all Access App.
Can It be done?

Here are the details;
To be Exact, I have about 25 Tables, and 20 views as of yet.
Luckily, I have not started to create my Stored
Procedures, Functions, and reports.
Hopefully, I will stat them soon.
One question at the moment, Please correct me If I am wrong:
1. I need to create 1 or 2 New (empty) Access database.
2. Using DTS or Import/Export techniques, I can send all my Tables and Views to my newly created Access database.
Now here is my question, since I have made about 20 forms in my original app.,
What is the best way to move or copy all my forms to my Newly Created Access App (The one with all the Imported tables)?

Best regards
BijanBijan

 

[Frink]

Hallo,

You can use the File->Import facility to import Access objects (like forms) into an Access mdb.

It's easier to not split FE/BE for demo versions as they are a single file and you don't have to worry about re-linking tables if you change the database location.


- Frink

 

[sanan]

Hi Frink
Thanks so much for your comment,
It is a little strange, I actually knew about the Import function, But I failed to remember that It has Tab Control and I can also Import my forms.
Thanks so much for reminder.

Best Regards
Sanan

 

[Terpsfan]

This is a way to export all forms in your application using the AllForms collection. You can do this with other Access objects such as reports.

Dim obj as  AccessObject
Dim dbs as Object
Set dbs = Application.CurrentProject

For Each obj in dbs.AllForms
   Docmd.TransferDatabase acExport,"Microsoft Access",<destinationdatabasepath>,acForm, objName, obj.Name

Next obj

set obj = Nothing
set dbs = nothing

 

[sanan]

Hi Omega36
Thanks so much for your reply.
Can I also export the views from a SQL BE to my Access Demo
App.?
also about <destinationdatabasepath>
what is this?
is it the DNS? or the Location of App. in my computer?

Best regards
sanan

 

[Terpsfan]

The destinationdatabasepath is the actual file location of the database you want to export to. For example "C:\Databases\MyDatabase.mdb". If on a network the path would be like "\\servername\foldername\MyDatabase.mdb".