Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Split database

Resolved · Medium Priority · Version 2007

Reply Tue 9 Aug 2011, 16:27Delegate Will said...

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?

For upcoming training course dates see: Pricing & availability

Reply Fri 12 Aug 2011, 16:41Trainer Simon said...

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

Reply Thu 6 Oct 2011, 16:23Trainer Rodney said...

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

Reply Fri 7 Oct 2011, 14:05Trainer Richard said...

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 articles

· How To Create An Index Report In Access
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· How To Use The Analyze Table Tool In Access
· When To Use Access, When To Use Excel
· MS Access and Database Normalisation

Please browse our web site to find out more about
access course and other Microsoft training courses.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips