jgoodman00 and Craig0201,
Thanks so much for replying! Two brilliant solutions to my problem. I think my own will cause me more grief than it's worth. I never knew about the Environ function. Wow! The things you could do with it. Craig, storing drive mappings as UNCs is simply....SIMPLE...
Thanks for replying, Uncle Jack!
I'm sorry I didn't make it clear in my earlier post, but I'm using Access Project with MSDE. My main problem isn't the data itself, which will all be stored on the server, but user specific information. For example, some of my forms allow users to save Excel...
Hi!
I'm working on an Access Project(.adp) that will eventually be distributed to several users on a network. I want to allow some degree of customisation e.g. default directories, combo lists, etc that can be set up locally. Instead of modifying the program itself, I thought of placing all the...
Hi Al!
Thanks for replying. I think I'm going to have to do quite a bit of reading on all this. Can you recommend a good beginners book for someone like me? I don't even know what VPN stands for. That should give you an idea of where I stand at the moment.
Thanks again.
KL
"There's...
Hello!
I'd like to connect an Access Project (ADP) from home to MSDE/SQL Server 7, installed on a network server at work. I've done some VBA programming with Access but this is way out of my league so I'd just like a few pointers to get started. What should I consider (IP Address, TCP/IP...
Hi All!
I'm working on an Access ADP with MSDE as the backend and I can't seem to requery my form after I delete a record. My form's recordsource property is set to an SQL statement as follows.
Forms!frmViewBoardData.RecordSource = "SELECT * FROM tblBoardData WHERE ContactID = " &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.