Replies

Thank you everyone for your time and effort replying to my post!

John Hutchison. What a fantastic idea for solving the 250! I have just finished studying “Data Collection via email” and it represents far less work on my part than building a Sharepoint application. In fact I have, in the past, considered trying to write a similar system myself, but this is done, it is standard and it does exactly what I need. Thank you!

kentg. Thank you for suggesting VM. I tried that once before but was unsuccessful. Recently, I made my pc dual boot and put my Offoce 2007 in the second boot. It is convenient because I have several partitions shared by both system which makes it easy to tranfer my development files. However, the system needs a re-boot to transfer from one to the other.
I may have another look at VM, thanks.
I’ll look through all of your other information in the next few days. It sounds very interesting!

Sorry, I didn’t write that I have been successful by converting to Access 2007. I do not believe that 2002 works at all!

Thanks for your reply Wendl.

One user is one the lan with a laptop, a second is on the lan with a desktop, the third user is on the lan with a Mac!
Two other users are remote with desktops and one is remote with a Mac.
The 250 planned remote users are not currently able to access their data.

I have started to write a login form for use in Access 2007, since I shall need to use the .accdb file format if I ever get to running on Sharepoint, and cannot run user security with the new format. I currently restrict the functionality of some of the six users by code in the load function of each form.

I think the 250 users can be managed with a single Sharepoint screen on the web, connected to the same .accdb data file. I shall have to handle the login inside the Sharepoint application for them.

I have had days of frustration and no real success trying to run Access 2002 with Microsoft’s Free Sharepoint site. I have now loaded a 30 day trial from Apptix:- which is working fine so far. Microsoft Small Business free site is not allowed in Australia and fpweb FREE SHAREPOINT WEB SITE is not currently working.

How am I doing so far? I shall keep this thred up to date in the hope that others can benefit from an Aussie’s blood sweat and tears! We don’t only play cricket over here!
Regards, Terry

I am running XP Pro.
All of the references seem Ok. I am impressed that some version 10 references were automatically replaced with version 12.
Unfortunately I do not yet have a solution. The problem exists only in 2007.
Thanks

Thank you John.
I have test run your code and it works fine after changing the reference to Office11
My original code now works as well because I have changed the Registry.
Over the weekend I shall test your code on another PC that does not have the Registry fix.
I’ll let you know what transpires. If your code works without the fix, it is definitely preferable.
Thanks for the help, Terry

I have a workaround which solves the problem.
The solution can be found in:- http://support.microsoft.com/kb/825765
Service Pack 3 for Office 2002 prevents the link from being made.
The workaround edits the Registry so that the security feature is disabled.
If anyone knows of a solution that does not compromise security, I would appreciate this information.
John, thank you for your help, Terry

Thank you for your suggestion John. Unfortunately your code has the same problem as mine: when Word has created the new document, using the template, the Mail Merge toolbar is mostly disabled, indicating that the link to the database does not exist
I received a runtime error and had to comment out line 3:-
wdApp.Activedocument.MailMerge.Destination = wdSendToNewDocument
This also indicates that it is not recognised as a Mail Merge document.
I also added two lines at the top of the code:-
Dim wdApp As Object
‘ Create Word Application Object
Set wdApp = CreateObject(“Word.Application”)
wdApp.Documents.Open FileName:=Parish2002_PATH & “Member Families Skeleton.doc”
wdApp.Application.Visible = True
‘wdApp.activedocument.mailmerge.Destination = wdSendToNewDocument
wdApp.ActiveDocument.MailMerge.Execute
wdApp.Documents(Parish2002_PATH & “Member Families Skeleton.doc”).Close SaveChanges:=wdDoNotSaveChanges
I am continuing to research this problem. Any additional help would be greatly appreciated, Terry

G’day Gwenda,
Thank you for the code you attached to your last posting. I have found it very useful. In fact it helped me develop a transfer function which I call when my MSAccess database is loaded. The function copies shared databases from my FTP site to the local computers. This all works perfectly in MSAccess 2002! Thank you very much! I have attached my code.
I have a further problem I am hoping you can solve for me. Some of my clients use MSAccess’97. One line of code will not compile:-
Result = InternetSetStatusCallback(mOpen, AddressOf INTERNET_STATUS_CALLBACK)
This will not compile because MSAccess’97 does not support “AddressOf”. Can you please tell me how to get around this?
Regards and many thanks, Terry

G’day Steve,
I have been trying to achieve the same MSAccess back-end result and finding your question has helped me understand the situation.
fyi:- I host my own webpage and ftp site. This is achieved by using http://www.dyndns.com/. This is free for non-commercial users and it works fine.
My first problem was caused by trying to use my FTP site to store the MSAccess backend. FTP can only transfer complete files and would not permit linking to an MSAccess database!
I have SQL-Server but could not decide from the documentation if MSAccess could connect over the internet. I suspected that I would have to translate the front end into web pages. Have you successfully connected using ODBC? I ask because this seemed to be your intention.
If I use SQL-Server, it will mean that I have to leave my pc running 24-7. Is there any way of Replicating the SQL-Server database in an MSAccess frontend?
Finally, is it all working as you expected?

Thanks again Hans. I shall attempt to set up SQL Server. I have a developer copy and I saw some discussion in this forum. I really appreciate the help, it has saved me wasting a lot of time.
Regards, mccer

Thank you Hans. If I set up a VPN, would it be possible to have a shared back-end database with several users running MSAccess front-ends?
Regards