Problem edititing forms!!

SGTE

New member
Local time
Today, 23:43
Joined
Oct 7, 2009
Messages
1
Office 2003 running under W7RC1 (have bought licences, awainting the end of October!)

2 pc's on a home/office LAN. The database resides in D:\Database. Both drive D: and the directory Database have been shared. Up until last week I have been able to edit/add to the forms within the database. Now I cannot edit the forms. I can add to /edit Tables, Queries and Reports. Can anyone shed a light on how to resolve this please?
 
Sounds like you might have corruption going on.

1. The database should be split (Backend - with tables only, Frontend with everything else)

2. A copy of the frontend should be on each user's computer (do not share a frontend and especially not over the network).

3. You might try importing everything into a new, blank database shell and see if that helps and then make sure that you follow #1 and #2 above.
 
I can't tell by your description how you set up the share but
you should make sure to use UNC paths (\\server\share\) when linking tables instead of mapped drives (D:\) or even (\\server\D\). Just FYI
 
I can't tell by your description how you set up the share but
you should make sure to use UNC paths (\\server\share\) when linking tables instead of mapped drives (D:\) or even (\\server\D\). Just FYI
Actually, it depends on your situation. In ours, where I work, we were saved a LOT of relinking work because we use mapped drives. They changed servers on us but kept the same drives. So, we didn't have to do much (except change the reference for a pdf add-in). So, I wouldn't necessarily make a generalization about always using UNC. UNC is good in most situations where your users do not have standard drive mappings. But if you do have standard drive mappings, it can actually be fine and a life saver at times. :)
 
Except in the cases where Windows assigns a different drive letter than usual.
Don't know how common that is nowadays but my school of thought was always use UNC.
Alas, there are pros and cons to any decision you make in life.
 
Except in the cases where Windows assigns a different drive letter than usual.
Windows doesn't do it, you do it. Or in our case we have software that does it as each user logs in. And you can control what windows does on your own machine (if you have admin privileges). You can set something to ALWAYS be drive Q (for example a USB jump drive).

So, anyway, it is all relative and I would agree that in the majority of cases it is good to go down the UNC path. But just good to know that there are exceptions to the rule and when it is a good time to use the exception. :)
 

Users who are viewing this thread

Back
Top Bottom