Ask Your Question

Saving Base table as Access format

asked 2017-09-08 21:12:07 +0100

vcas gravatar image

updated 2017-09-08 21:36:57 +0100

Ratslinger gravatar image

I can load an Access database in Base and work with it. Can I then save or export an updated database back into Access format so that the originator can use it in his Access 2000?

edit retag flag offensive close merge delete


Access2Base is for macros. Tag removed.

Ratslinger gravatar imageRatslinger ( 2017-09-08 21:37:56 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-09-09 00:18:41 +0100

peterwt gravatar image

When you "Load" an Access database you are just linking to the Access Tables. Any changes you make to the Tables are therefore changing the Tables in the Access database file. If that database is then opened in Access the changes made in Base will be seen.

edit flag offensive delete link more

answered 2017-09-08 21:27:33 +0100

Ratslinger gravatar image

When you connect to an Access DB using Base you are working with the .mdb file (the Access DB). Therefore there is nothing to export. The .mdb should have the current data.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-08 21:12:07 +0100

Seen: 230 times

Last updated: Sep 09 '17