Importing from Distributable Database

  • Thread starter Thread starter Eddy
  • Start date Start date
E

Eddy

I am using the following code to import from one mdb file to another in
Access2003.

strTableName = "tbl1"
strDBName = "C:\Database\Database.MDB"

Set db = DBEngine.Workspaces(0).OpenDatabase(strDBName, False, True, "")
Set rst = db.OpenRecordset(strTableName)
Set db1 = CurrentDb()
Set rs1 = db1.OpenRecordset("tbl1", dbOpenDynaset)


I am going to distribute both databases using the Access 2003 Developers
Extensions. My question is will this code work after the database is made
into a distributable one using the Startup and Package Wizards int the
Developersextensions. Will I still be able to import from and to the new
program?
 
There should be no trouble importing data (or queries or macros, I think)
from one mdb to another with the runtime.

There will be problems trying to import forms, reports or modules, as they
require the ability to get into Design mode, which the runtime doesn't
support.
 
Back
Top