Search results

I have 3 tables namely master, Trans and archive. Master table contains all the records. Trans table contains records which are issued to any user where as Archive table contains the records which are above 90 days old. Table structure is as follows. Master Table -> Document type, Document...

Hi! I just want to know that " How to split the Access database in Front End and Back End application"? I am creating a database that i want to store on server and simultaneously want to give access to 20 terminals (cleints) to access the database. Secondly, I have to provide a field in a...

Hi! I want to create a database using MS Access that can be accessible by 80 users for information search purpose. At the same time at least 20 users out of 80 can make modifications. Need suggestion will that be possible in access. The database will store in shared drive. Also want to know...

I am facing an issue in importing data from excel sheet to MS Access table. The issue is I am trying to import excel sheet that contains 100 records into access table. Both the excel sheet and access table have same field names. Now the issue is when i use the MS Access | File | Get External...

Hi! I have a table that contains 15 fields and the same table have nearly 1000 records. Now the process goes like that every time I am getting an Excel file that I have to imported in MS Access table (the table which i referred on top). However only 4 fields needs to be populated(appended)...