Can't edit database connected to Access 2010 database?

users
#1

Hello everyone.

I have a Microsoft Access 2010 database that I would like to share with a
co-worker that is new to database software and does not use Access. I
thought LibreOffice Base would be the free database software that would be
easiest for him to use, but I am having some trouble with it myself. I
created a database file in Base and connected it to the Access file, but I
can't seem to edit the data in the tables in Base. I can edit those data
just fine in Access, and the edits cascade into Base. I just can't edit the
data in Base.

                Does anyone have an idea of what, if anything, I'm doing
wrong? Thank you.

-Douglas Pope

#2

Hi Douglas,

Douglas Pope schrieb:

Hello everyone.

I have a Microsoft Access 2010 database that I would like to share
with a co-worker that is new to database software and does not use
Access. I thought LibreOffice Base would be the free database
software that would be easiest for him to use, but I am having some
trouble with it myself. I created a database file in Base and
connected it to the Access file, but I can't seem to edit the data in
the tables in Base. I can edit those data just fine in Access, and
the edits cascade into Base. I just can't edit the data in Base.

Does anyone have an idea of what, if anything, I'm doing wrong?
Thank you.

Some time ago I made some experiments with MS Access and documented my findings in http://wiki.services.openoffice.org/wiki/Connecting_to_Microsoft_Access

Perhaps you get some hints there.

Kind regards
Regina

#3

...
I'm not sure about an Access 2010 file, but I can easily edit the
NWind.mdb file in LO 3.5.3. Note: to edit the date in the table, you use
'Open' rather then 'Edit'. 'Edit' allows you to edit the Field names
etc. Also note that LO 3.5.3 (Windows version) has dropdown selections
for 'Microsoft Access' and 'Microsoft Access 2007'. I do not know if
'Microsoft Access 2007' includes Access 2010. Do you have a test file?

When you right click on the table & select 'Open' what occurs? Does the
table open for you?

#4

Yes, I have a test file. When I connect using the "Microsoft Access 2007" option, I can open the table, but not edit it.

-Douglas Pope

#5

...
Would you mind sending it to me & I'll test from my side.

Thanks

Gary

#6

Unfortunately, I can't send my current test file to you because it contains company data. However, I can make a new test file and send that to you. I'll do that tomorrow.

-Douglas Pope

#7

Am 31.05.2012 02:48, Douglas Pope wrote:

Yes, I have a test file. When I connect using the "Microsoft Access 2007" option, I can open the table, but not edit it.

1) And the most likely reason is that your table has no primary key.
2) The second most likely reason is that your Access database relies on Access specific protection/permission/programming (mde, mdt, accdt, accde).

This is the community support address for all Base related questions and tutorials:
Search: http://user.services.openoffice.org/en/forum/search.php
Read Q&A: http://user.services.openoffice.org/en/forum/viewforum.php?f=13
Tutorials: http://user.services.openoffice.org/en/forum/viewforum.php?f=83
Base&Access: http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=25300

#8

Hi :slight_smile:
You can always upload test-files to Nabble so that more than 1 person can
test things out. Errr, obviously not files with confidential or sensitive
information.

When you upload to Nabble it put a clickable url link into the message
portion of the message and you can write normally around it. So, just use
the links to get to Nabble, navigate to this thread, reply to one of the
comments and then click on the "More" button. The top option there is
"upload file" and lets you browse in much the same way you would when
attaching something to an email.
Regards from
Tom :slight_smile:

#9

http://nabble.documentfoundation.org/file/n3987184/Test_files.zip
Test_files.zip

I attached my test files via Nabble. The structure is exactly the same as
the real files.

-Douglas Pope

P.S. All the tables have primary keys (called "ID" in the test files) and I
didn't use any Access special features.

#10

Another thing I just thought of regarding this problem is that maybe I could
change the back end so that both Access and LibreOffice would work as front
ends. (I can't abandon Access completely, though it would make for much
less work on my end if I could.) Would that be a better solution than
trying to get LibreOffice to edit the Access database? If so, what would be
a good back end?

Thanks again for all your time and effort.

-Douglas Pope

#11

Douglas

Another thing I just thought of regarding this problem is that maybe I could
change the back end so that both Access and LibreOffice would work as front
ends. (I can't abandon Access completely, though it would make for much
less work on my end if I could.) Would that be a better solution than
trying to get LibreOffice to edit the Access database? If so, what would be
a good back end?

I like MySQL/MariaDB as back end. Also, the current HSQL engine is
better than the embedded engine, but it requires Java.