hi all,
I'd like to know if this is possible...I want to be able to create a new database stored in a new file (*.mdb) when I initiate a new project.
For example, a user can start a new project and store this information into the existing database set up with DSN thru the control panel.
Project.mdb
ProjectKey** (primary key)
ProjectName
ProjectDate
InfoKey
and then I would like to be able to create individual *.mdb files and somehow reference InfoKey to them, and have a user be able to access and update information in that mdb file, without me having to set up a DSN each time in control panel.
Is this possible, and if so, how would I approach this? I want to do this because of Access' 2GB limit.
HOpe I am clear.
