Hi All,
I am a new entrant to this group.
In my workplace, I am required to start a new Access database with network access to a limited number of users (about 25). We have an IT department who will help us in the installation.
I have few questions in this regard:
1. What is a better option - to start a database on the personal computer, populate the files, generate the most immediate queries and then copy the database file to the network folder;
- or right away start with a new database on the network with access permission only for me until the database is loaded with information before opening for the users?
2. We have a larger SQL database which holds corporate data. Eventually we would like some of the data (a few tables) from the Access database to be exported to SQL and similarly we would like to import some tables from the SQL database to Access. We envisage that this will be a periodical process (once in a month) to update the data in both the databases.
How best can we address this issue at the design stage of the Access tables? I mean in deciding about the data types of the fields etc.
Presently we have the main data in Excel tables.
3. I appreciate if the experienced specialists can offer advice and suggest some reference material for an exercise of this nature. We would like to avoid the common pitfalls associated with this task. The size of the database is obviously limited by the choice of Access.
Thanks in advance.