Recent content by Bombbastic22

Hi all, Totally new to all of this carry on so please excuse my ignorance. I have successfully migrated my access database to MS SQL server 2008 and it works quite well. However, I have done this on the remote server and when I copy the access file over to the desktop, I can't connect to...

It links lovely actually. .............it's kind of a referential wizard thing that you use to pull in the contents of fields in other tables so the user can select the person they want to add to the form instead of plonking in an id which references another table. I came accross it online and...

Lol. I guess I was a little lazy in my explanation there. Sorry about that. There is just a little bit of access functionality that I'm thinking may cause me headaches down the road............due to it possibly not working in the same way when the database has ms sql in the back end as opposed...

I wonder though - would there be any drawbacks to using multi field primary keys when you port access tables into mssql? I was trying to increase usability and as it's not a huge database, I thought it would be handier for the user than having to go looking for ids. It's one of those tables you...

Hey thanks for the reply. I was feeling pretty lost when I posted that. Just started a new job and the boss wants me to work wonders with software and such that I've never used before. I got there anyway - SSMA is a great tool for this purpose. I can't believe it works so nicely and links...

I have received orders from above to take an access 2007 database and have it sit on top of an mssql database. It's proving to be a serious headache and I'm not sure about the practicalities of it. Any advice on same would be super. Thanks in advance fellow geek a zoids!