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...

thanks Thanks buddy that solves my problem! regards, Nick

Thanks Thanks a lot. Regards Nick

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...

Please help.

I dont have any primary key in the table.

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...

Pls help....

Thanks for your reply Dear Doc man, Thanks for your reply ... Scenario is that I have access database which resides on shared drive now there are certain set of records which needs to be entered by different users at same time. If you would like to enter any field then i would like you to...

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)...