Search results

I will do thank you plog...

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, im enjoying reading your submissions thanks for contributing. I know a bit more now and can advise. The sql server will just be storing my tables, and are then linked back to the access FE. All queries will be executed on thr FE. I know this will never be true client server, it will...

Hi BParkinson, I am in total agreement with you on taking the queries into SQL server and using views and SP etc. But nfortunately my hands are tied in this case and I want to avoid pitfalls down the line. I understand what your saying re linking sql tables, but I had the impression its not...

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

OK Guys, Here is it the final solution to transfering data from an ms access table to a SQL server table --- 6 simple lines-- it was easy in the end, but took me 3 hours of trial and error! I am using windows Authntication you may need to put in usernm an password so I have a commented...

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 got it working thanks for the help !

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

Got my ADO string working so feel I have climbed a mountain. Thanks for the help. Still not clear on the main difference between DAO and ADO ! both seem to do the same thing:D

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

Hi, That makes sense alright, but is there any performance issues with linking? Can you base a form on a linked swl server table? See my next post. Thnaks again:D

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, Thanks for that, I think I get it but need to put the practice in. I will no doubt be comming back to you as my project progressess. kind regards :D

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