Search results

Good morning, I have an Access 2003 database containing details of users from a SQL database. Unfortunately the SQL databse, of which I only have read access, only contains users email displaynames from AD not their actual SMTP addresses, which I need to update some data elsewhere following...

I would never advise the splitting of a database. If this is the kind of option you are looking at I would recommend a SQL Server back end and development of a front end to run on the clients machines. This could be Access or a .Net application. Cheers, Kev

I am surprised that the machine logs onto the network?!

You will need to provide more information than that I am afraid. Are you talking about user permissions to Access, forcing users to log on, is this database split with data on server and front end stored on local machine? Cheers,

I guess there is no reason why the address list couldn't be exported from Access and imported into Outlook. An easier why would be to import the data, right click blank table area and select Import. From the file type selection select Outlook() and follow the on-screen prompts. Regards,

Hi CeCe, Hopefully we can help. Can you advise as to what the problem is, and maybe post in a forum more relevant to the problem so that experts in that area will get visibility of it? Kind regards,

Thanks for the warm welcome :-)

Good afternoon everybody, My name is Kev. I have four years experience in developing applications with Microsoft Access and more recently experience of applications using both SQL Server and Oracle. Reasons for joining? You never know when you might hit a brick wall!

Thank you all for your help. With a little jigging about with the source data, I managed to achieve what was required with the method suggested by Brianwarnock, so special thanks to him. Thanks again all - no doubt I will be back in the future pestering for help, and obviously if I can help...

Thanks everyone for your suggestions. I'm going to take a look at this tomorrow now. I will report back. Thanks again, Kind regards,

If only it were that easy James. Thanks again for yours asssitance. Regards,

Just had another look at this. If I use - as a field seperator any other fields that use this seperator will become corrupted, i.e. team name field where by users team names sometimes have a - within them. I am now thinking that maybe I will need to import into Excel carry out the Text to...

Thanks James I thought that would probably be the case. Thanks for your help. Cheers, Kev

Hi all, I wonder if someone can help me with what should be a simple task. I have a table of user details that has been imported from an Oracle database. Within this table are two fields Personnel Number and ID. I would like each field to reflect the correct value for this field and if...