Split Database and put back End in C: Drive

[Frank Situmorang]

Hello,

I do not have any server, but to enable me to make future development of
front end. Can I split database and put back end in the c:drive another
folder?

What is the best way.

Thanks in advance

 

[Beetle]

Yes you should split your db, and Access has a built in db splitter that makes
it quite simple. Make sure your code is compiled, do a compact & repair and
make a bakup copy just in case. Then go to tools / database utilities /
database splitter (this will vary slightly depending on what version of Access
you have). The wizard will walk you through the rest of it.

When you are done I would make another backup copy of the front
end. IMO you should always split your apps, that way if you corrupt the
front end while you're adding code / making design changes, you don't
risk losing your data. Just be sure to make regular backups.

 

[Armen Stein]

Yes you should split your db, and Access has a built in db splitter that makes
it quite simple. Make sure your code is compiled, do a compact & repair and
make a bakup copy just in case. Then go to tools / database utilities /
database splitter (this will vary slightly depending on what version of Access
you have). The wizard will walk you through the rest of it.

When you are done I would make another backup copy of the front
end. IMO you should always split your apps, that way if you corrupt the
front end while you're adding code / making design changes, you don't
risk losing your data. Just be sure to make regular backups.

And to answer the rest of your question, the back-end database can be
anywhere: another computer on your network, another folder on the same
computer, or even the same folder on the same computer.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com