split database

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Split database

Split database

resolvedResolved · Medium Priority · Version 2007

Will has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Split database

When the database is split so that a 'back-end' file is created housing the tables, is there a way to reverse the process and 'unsplit' the database so that there is only 1 main file as before?

RE: Split database

Hi Will,

Thank you for your question.

I have looked within Access and cannot see a way of achieving this.

However, I will talk with my other Access colleagues and search some forums.

If we come up with anything I will email you.

Regards

Simon

RE: Split database

Hello Will,

Further to your question on un-splitting a database.

One way of getting things back the way they were is by importing the tables from the backend to the frontend
database. You will have to delete the linked versions of the tables and rename the imported tables to the correct names.

I would suggest you make a backup of your backend and frontend databases before trying this.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 14 Oct 2011: Automatically marked as resolved.


 

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips


Server loaded in 0.1 secs.