Search results

Hi all, Seeing some strange behavior here. I have a database front end with an Excel spreadsheet as a linked table. On occasion, when one of my users either starts up the database, or attempts to run a query that pulls from that linked table, it will automatically open up the linked...

Ok, small issue. I have an Access database that pulls data from another department's Excel spreadsheet. My database seemed to be locking their spreadsheet any time someone ran a query that drew data from the link, so I created an intermediatary spreadsheet that basically links to all of the...

Hi all. I currently have a pharmaceutical lot database set up in the following format: MFGData (table w/Manufacturing Info) QAData (table w/ Quality Assurance Info) QCData (table w/ Quality Control Info) PASData (table w/ Process & Analytical Science Info) SCData (table w/ Supply Chain Info)...