ACCESS FEED: Re: [MS_AccessPros] SQL backend and Access Front end

Rabu, 01 Januari 2014

Re: [MS_AccessPros] SQL backend and Access Front end

Duane

Thank You. I asked a sql guy several months ago about a similar situation and he told me that opening a sql file is not portable.
I will give it a try and see if it works

Jim Wagner

Sent from Yahoo! Mail for Windows 8

From: Duane Hookomduanehookom@hotmail.com>
Sent: ‎Wed, ‎Jan‎ ‎1‎, ‎2014 at ‎11‎:‎27‎ ‎AM
To: Access Professionals Yahoo Group ms_access_professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] SQL backend and Access Front end

Hi Jim,

You don't "open" a sql file from Access. You link to the tables and views from the SQL database. The SQL databases are typically one or more files on your hard drive. When you create a new SQL database, you have the option of specifying where you want to create the database and transaction log files. I believe this could be on a usb drive.

When I want to move a database to a new server or different folder, I first detach the database, move it, and reattach at its new location.

All of this is managed through SQL Server Management Studio. There are probably utilities that allow you to keep databases synchronized across multiple locations. If you want to use the USB drive, I expect it would need to have the same drive letter for your desktop and laptop.

Duane Hookom MVP
MS Access

________________________________
> From: luvmymelody@yahoo.com
>
> Hello all,
>
> I have a question about front ends and backends.
>
> I tried a couple of months ago this scenario.
>
> I have sql express on my work desktop. I tried to open the sql file on
> my work laptop and it did not recognize the file in sql express. I was
> wondering if there was a way to make this file portable so that I can
> create a front end and keep it on a usb drive to the sql file on the
> usb drive? I have a personal task database that I would like to learn
> to use sql as the back end and access as the front end.
>
> Thank You
>
> Jim Wagner