Search results

Hi, I have a table that has 4 fields called TblStaffLeave ( PersonnelNo (PK), LeaveType(Int),StartDate (date), EndDate(date) Example data look like PersonnelNo, LeaveType,StartDate,EndDate 1234 , 1 , 1/7/2017, 17/7/2017 4353 , 1 , 15/8/2017, 19/9/2017...

Hi, I am designing a staff rostering system. It for 5 staff over 2 weeks, staff working a max of 39 he's per week. Any advice or links to suggestions. Kind regards

Hi Guys, I have been asked to investigate the efficiency (and wisdom) of moving an Access 2003 DB to SQL Server. Obvioulsy splitting the database into a Access Front End(FE) and Access back End(BE) Then imporintg the MS access tables into SQL Server. Then relinking the SQL Server tables to...

Hi Guys, Does anyone know where I can get the ADO code to upload records from local tabel in MS Access to a tabel on my SQL Server, there will only be about 20 rows at a time. I was thinking of creating a recordset RS from the Sql Table. Then use sql statement like INSERT(..Field...

Hi Guys, I have setup a new and I am getting a user login error msg that a bit vauge and thus not easy to identify. See attached screenshot. I am using windows Authentication I have added user and roles and permission to the database but still cannot connect the new user? I am user MS SQ...

Hi Guys, I have my ADO code up and working and am calling stored proc so it all good. But one problem I have hit on that I haven't been able to find a solution too it as follows; I want to pass a date into my sql server tables from Access. If I use an 'InputBox' in Access, it works great the...

Hi Guys, This question is about Front End design when using Access against a SQL Server Database. I am looking for advice on the way forward with a MS Access Front . There is really only 3 tables, Clients, Staff and WorkedHours on a sql server 2008 database Back End In terms of table...

Hi Folks, Can anyone provide a reliable ( and Simple) connection string (DSN Less) that will work with MS Access 2003 to connect ot SQL Server 2008. With a simple T-SQL Statement either updating a TblCLients or receiving a recordset kind regards

Apologies for the bad pun ! I am looking into whether I should link my SQL Server tables to my MS Access Front End or just use stored procedures to pass and receive data, as I will be running a relatively small database ( essentailly 3 smallish tables that will max about 150,000 records over 10...

Hi Guys, I am moving to SQL Server and will be using MS Acess 2003 specifically as a Front End to a SQL Server 2008 database. I have a form called FrmStats and a txt field called SName. When I click on a button I want to send the txt as a parameter to a Stored Procedure on SLQ Server. I...

Hi Guys, Am looking for a bit of advise I am seasoned MS Access Developer and love its simplicity and convenience particularly its Combo boxes. I don't enter the data in the property field of the combo box but instead tie it to a small table and use its fields. But I am moving to SQL Server...