split database

[hdu]

I tried to create linked tables for the database on a server. However, the user and I map to the server by different drive name. If I split the database on my computer, the user is not able to access to the tables. This is true vice versa. Do you know what is wrong here?

 

[dcx693]

I don't think anything is "wrong" per se. Try specifying the server name using UNC like \\servername\share, not by using a drive letter. Either that, or get the user and yourself to use the same drive letter for the server.

 

[llkhoutx]

Another solution is to create a common dialog (directory tree) allowing the user the select the server folder and file.

 

[StacyStacy]

Hi. I had a similar situation in that I split my database. This is what happens when you split your database: a FE (frontend) and a BE (backend) copy will be created. Here's what you do: make a backup copy of the database itself. Split the database. Make a copy of the FE & BE for backup purposes. Copy the BE to the server. All you will see are tables in the BE. Now, you can manipulate the FE as you please. Copy it to the server as well. Go to the users desktop and generate an icon.

Please refer to the link below. Hopefully this can help. Thanks.

http://www.access-programmers.co.uk/forums/showthread.php?threadid=47286