Competent Performer
Windows Vista 
Access 2003
I have an access database which was created in 2003. I opened a blank database and imported the definition and data in access 2010 and made the file an accde file. Now this file has a lock symbol next to the access symbol. I am also unable to edit the main form.
Any suggestions
VIP
Windows 7 64bit Access 2010 32bit
Edit the original accdb then republish as an accde.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows Vista Access 2003
Please explain a little more
VIP
Windows 7 64bit Access 2010 32bit
How did you make the file an accde? That is an executable only version. Not supposed to be able to do design edits. Do design edits with the accdb file.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows Vista Access 2003
I selected the option to make dbase accde from publish & save
VIP
Windows 7 64bit Access 2010 32bit
Okay, now do edits in the accdb file created by the import then repeat publish & save.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows Vista Access 2003
I dont want to modify the design only enter data in dbase
VIP
Windows 7 64bit Access 2010 32bit
Oh, I was confused by 'unable to edit the main form'.
You are unable to enter/edit data on the main form?
I've never used an accde.
There are multiple users?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VBA/SQL help: My code to autoassign records to users results in Run-time error 3141
Posting Permissions
Reply With Quote