Reconnect split database

[John]

How do I reconnect a split database in Access 97?

 

[Douglas J. Steele]

Why would you want to? Even my single-user databases are always split,
because of how much simpler it is to make changes.

If you're determined, though, simply delete all of the linked tables in your
front end, then select File | Get External Data | Import and import each of
the tables into your front end.

 

[John]

Thanks for the info. I am trying to convert from Acc 97
to 2003 and am having problems converting the separate
files. I thought I should reconnect, compress, convert to
2003, and then re-split.

 

[Douglas J. Steele]

There's no reason I can think of that you should need to go to that extent.

What error(s) are you encountering trying to convert the split databases?

 

[Ernie]

-----Original Message-----
Why would you want to? Even my single-user databases are always split,
because of how much simpler it is to make changes.

If you're determined, though, simply delete all of the linked tables in your
front end, then select File | Get External Data | Import and import each of
the tables into your front end.

You can do the same thing in reverse. Open the backend db
and use File / get external data / import and import all
of your forms, queries, reports etc into the backend,
probably without having to delete anything.

Just a thought

 

[Douglas J. Steele]

You can do the same thing in reverse. Open the backend db
and use File / get external data / import and import all
of your forms, queries, reports etc into the backend,
probably without having to delete anything.

Just a thought

While theoretically that would work, in practice it can introduce problems.
If you've set any non-standard references in your front-end, you wouldn't
get them in the backend that way. If you set start-up properties, you
wouldn't get them in the backend. In most of my databases, there are far
more objects in the frontend than in the backend (although, of course, the
objects in the backend tend to be much larger...)