Hi
I have been tasked to design and maintain a
database of car information. I in simple reduced form have the following dataset
:
Imported Country DataTxt Field 1
Imported Static DataTxt Field 2
Imported Static DataTxt Field 3
…
Imported Static
DataTxt Field 15
Autonumber
Common Enterable data 1
Common Enterable data 2
…
Common Enterable
data 8
Data
Related to Mgr 1
Data Related to Mgr 1
Data Related to Mgr 1
Data Related to Mgr 1
Data Related to Mgr 2
Data Related to Mgr 2
Data Related to Mgr 2
Data Related to Mgr 3
Data Related to Mgr 3
Data Related to Mgr 3
Data Related to Mgr 3
Calculated Field 1
Calculated Field 2
Calculated Field 3
Calculated Field 4
Calculated Field 5
Calculated Field 6
RAG Status
Text
Field
Comments
Basically, the first 15 fields are imported data from
another database and UNMODIFYABLE - subsequent fields are data that needs to be
added by various different Mgrs.
a) It is my intention to have a SPLIT
form with the top half to add/modify the data all for fields after the 15th
field and the bottom half in read only mode only for viewing and selecting the
row to maintain.
b) There needs to be no need to add new record per se
manually, but the main feed will need to come from an import form another data
and will ONLY be for the first 15 fields.
c) There also needs to be a
way of filtering the data by country based on the first field. I am tempted to
place buttons on the top form the form which filter the data by a drop down etc.
d) I also need to be able to open this database up to multiple users. No
security needed.
This is going to be my first transition to ACCESS DB
after decades of being a VBA and .Net programming, so I am use to macros and
scripting.
My main hangup is the overriding question of whether I need
an "AutoNumber" field ? To date it feels like I do in order to uniquely identify
the car derivatives. BUT I am then unsure how to import data (both initially or
incremental) and then allow ACCESS to do the autonumber part of it.
I assume i would have an update query which is sitting on the external data DB
which inserts rows into my DB ?
My final consideration is whether this
needs to be a split database i.e. front and and backend detached so that it can
be truly multi-user ?
Any assistance would be greatfully appreciated.
Thanks in advance.