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.
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.
Last edited: