splitting database

[tiger]

Hi,

Can some please share with me, the instruction on how to split a multi-user
database into front end (FE) and back end (BE) database.

I create a access vba interface with form for work and I put it on my work's
intranet....but I will like to make it a multi-user database without
recreating the application again.

Thanks
Tiger

 

[Tom Wickerath]

Hi Tiger,

You have two methods available:

1.) Tools > Database Utilities... > Database Splitter

or

2.) Manually. Create a new database. Import the tables and relationships
from your existing database into the new database. Then delete the tables
from your source database. Finally, in the source database, use File > Get
External Data > Link Tables...

Here is an article that you might want to read. It includes a link that
explains the benefits of splitting:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________