Jumat, 10 Agustus 2018

[MS_AccessPros] Re: UNC vs mapped drive for linked tables

 

I never rely on mapped drives. Users can disconnect or change the mapping to another letter...Way too much overhead. UNC paths are much more reliable and speed isn't affected much as it was in the old days. When your front end opens make it connect to a table in the back end and leave the connection open. That will increase performance quite a bit. See the article at fmsinc


Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com


---In MS_Access_Professionals@yahoogroups.com, <jcross@crossproducts.plus.com> wrote :

Hi

Is there any speed advantage of linking tables one way or the other? Or any other advantages one over the other?

Thanks 

Jane

 

__._,_.___
Posted by: wrmosca@comcast.net
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: SQL Server Express as backend question

 

Jim - SQL Express can be installed on a server. I wouldn't share a database on your desktop. Performance over a network will be horrible.


Do you really need SQL Server for your database?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com




---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :

Hello all,

I have been playing with SQL Server express for awhile now. I even connected it to a personal task database I have been using for a decade. It took a long time to get everything to work on the forms and other things.

But I have a question that I asked someone at work and they said it probably could not be done.

So I have SQL Server Express installed on my desktop. Is there anyway to allow others access to the database? I do not think it should be done, but I was wondering if the database file is on a network drive would it work?

Thank you

Jim Wagner


__._,_.___
Posted by: wrmosca@comcast.net
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Selasa, 07 Agustus 2018

[MS_AccessPros] SQL Server Express as backend question

 

Hello all,

I have been playing with SQL Server express for awhile now. I even connected it to a personal task database I have been using for a decade. It took a long time to get everything to work on the forms and other things.

But I have a question that I asked someone at work and they said it probably could not be done.

So I have SQL Server Express installed on my desktop. Is there anyway to allow others access to the database? I do not think it should be done, but I was wondering if the database file is on a network drive would it work?

Thank you

Jim Wagner


__._,_.___
Posted by: luvmymelody@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: Error Trapping for a Append Query

 

Thank You Bill,

I just saw this. it never showed up in my Yahoo inbox. I will work on this.

Jim

__._,_.___
Posted by: luvmymelody@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: SQL Server Native Client 11.0 - Some advice please

 

OLE DB is definitely not the way to go (it had been deprecated but, https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/ however, Microsoft might have another change of mind, it's a mess, however you look at it, https://blogs.msdn.microsoft.com/sqlreleaseservices/snac-lifecycle-explained/ )

The Native Client is also being replaced/renamed... by/to the "ODBC Driver 13 for SQL Server" so the line of preference should be:

ODBC Driver 13 for SQL Server
SQL Server Native Client 11.0 (support until July 2022)
SQL Server Native Client 10.0 (support until Sept. 2019)
SQL Server (seemingly supported until heck freezes over)

With emphasis on "should".

The "SQL Server" driver has had some updates/fixes but presents the least functionality. In reality, take the best you can get and in general don't go to a newer client than the Backend SQL Server you've been given to play with.

At one client I just gave in and implemented "SQL Server" Driver for all workstations because it "just worked" even though it was demonstrably slower. "Power Users" got an upgrade if they had a problem.

Yours,
Andrew

__._,_.___
Posted by: yahoo@craven.de
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)