copy acc2K database

[Danny]

Greetings,

I took a new position to maintain a database, which is already in production. The database is split as front end/back end database where the table (be) on the server and the (fe) forms, queries, etc distributed users machine. My question is two fold:

1.I was trying to copy the database onto a CD or Flash drive so I can take it
home to make some changes. Do I need to delete the link so that both the fe and the be will be in the CD, or do I just need to go to the path in the cod and change it there?
When I open the Log in form in design mode and go to cod, I see the following:

Set dbs ‘db name’= wrkJet.OpenDatabase(“bhha_fs\Vol1\apps\folder name\db name.mdb”)

2.The database, among other application currently resides on a Novell server and the we are planning to move it to a different server (NAS server) what will be the steps to accomplish this?

Thanks in advance,
OCM

 

[WayneRyan]

Danny,

If you transport a database(s) on a CD, Windows will probably make it a
read-only file. You'll have to change that first. You won't be able to
run it from the CD, because Access won't be able to create a locking
file (.ldb).

On most databases, the back end doesn't care where it is located. You
don't have to do anything. Normally on the front-end, you just use the
linked-table manager and point the front-end to the tables in the
back-end.

If there is code that references some object explicitly, you will have
to supply that object in the appropriate location, or change the
reference. The object might be a picture (.bmp/.jpg), the front-end
or the back-end databases. Since the name in your case is [db name].mdb,
I'd guess that it points to the back-end database.

hth,
Wayne